Our client is a software solutions provider for construction companies, public bodies, architects, accountants, surveyors, engineers, notaries, building experts and professional firms.
Architecture
PROJECT
Having a suite of highly successful desktop apps, Our client was on a look out for the next generation of their products which will suit the newer workforce and workflows. This app is developed as an intermediate solution to enable cloud collaboration. Simply Database Synchronization(SyncroDb) is a Web API platform developed for creating a customized file storage with users data. There are several data storage applications, yet SyncroDb will be used to organize your data and store your files and details of your clients in a specific manner. The local storage system of SyncroDb Application is shifted to cloud storage.
CHALLENGES
SOLUTION
SyncroDb Application provides APIs for adding, updating and deleting the data in a cloud storage for any user who is registered in the application.
Users can add, update, delete and fetch files or clients of their organization from the database using dynamic GraphQL APIs for accessing the PostgreSQL database and Azure Blob Storage. API documentation provides details and steps to consume the APIs or access the data directly from the Postman.
Secured the application using Azure AD Authentication to allow users with valid email and password to access the data based on their type.
BENEFITS
SyncroDb APIs will allow users to fetch the sorted data with their own choice of filter along with the pagination.
SyncroDb APIs create signed urls for uploading and downloading files in order to directly allow the end user to upload the file in the Azure storage. This feature provides a cost effective solution for organizing and storing data.
APIs are secured in such a way that a particular user cannot access the files and clients of another user, whereas an admin user will have the rights to add and update users as well as modify or view any clients or files.
TOOLKITS/LANGUAGES
.Net Core 6
PostgreSQL
CLOUD SERVICES
Azure Compute
Azure Storage
Azure AD Authentication
Azure PostgreSQL
LANGUAGES | PLATFORM
C#.NET
GraphQL