Keeping web clients in continuous (real-time) sync with relational database (preferably PostgreSQL) server/backend database
Budget: $250 – $750 USD
The purpose is to keep data in web clients in continuous sync with a server/backend relational database (PostgreSQL). From our understanding, we have had ideas like listed below, but feel free to propose any better, alternative solution of your choice.
- Using FDW - Foreign Data Wrapper for PostgreSQL - for indexedDB.
- Use e.g. RxDB with an adapter for PostgreSQL.
- Manually build a solution that trigger on database updates and send a copy of such transaction to web clients that are known in a list. (The preferred choice of Postgres is because of that Postgres have triggers on views.) Maybe over websocket and update IndexedDB and/or only update a variable containing the objects corresponding to the rows in the view. Updates in the client could be handled the opposite way, or that the clients writes directly to the server database. This synchronization mechanism should be autonomous. One challenge here is to update via the views or in some way split to the dependent tables.
Additional skills: Good English, Structured and well organized.
Please answer with a proposed solution.
- Using FDW - Foreign Data Wrapper for PostgreSQL - for indexedDB.
- Use e.g. RxDB with an adapter for PostgreSQL.
- Manually build a solution that trigger on database updates and send a copy of such transaction to web clients that are known in a list. (The preferred choice of Postgres is because of that Postgres have triggers on views.) Maybe over websocket and update IndexedDB and/or only update a variable containing the objects corresponding to the rows in the view. Updates in the client could be handled the opposite way, or that the clients writes directly to the server database. This synchronization mechanism should be autonomous. One challenge here is to update via the views or in some way split to the dependent tables.
Additional skills: Good English, Structured and well organized.
Please answer with a proposed solution.