Google Implementation:

Initially, we attempted Google Mail service integration using Nodemailer, but faced scope approval issues, leading us to develop a custom solution with a different scope to meet Google's requirements.

Microsoft Implementation

In integrating with Microsoft mail services, we explored existing SDK methods but encountered challenges due to ineffective methods and poor documentation. We crafted our solution carefully considering Microsoft's service limitations.

Stripe Implementation:

TroveWorks utilises Stripe for subscription and payments. During implementation, we dealt with a partially implemented system, addressing challenges like subscription downgrades and handling subscriptions when users remove all payment cards.

Multi-Tenant Implementation:

When implementing multi-tenancy, we had to choose between two approaches: using single email and password login credentials across organisations or providing distinct login credentials for each organisation. This decision was pivotal and required careful consideration of the implications and benefits of each approach.

Development of Teams, Groups and Assign Collectors

Troveworks allows users to create teams, groups, and assign collectors, with interconnected data manipulation. We transitioned group development from a local to a remote database, and custom table features were created to fulfil required functionalities not supported by AG-grid.

Syncing data from local to cloud and vice versa:

We established seamless data synchronisation between the user's local and cloud data. This involved creating middleware to capture write operations, store them locally, and sync them remotely without any user visibility. To enhance efficiency, Celestial team optimised SQL queries during bulk data uploads, achieving a high level of performance. Additionally, we addressed a backend performance issue by analyzing and configuring AWS (Amazon Web Services), such as PostgreSQL and EC2, leading to client-approved proposals.