What is the most modular real-time sync engine?

Question

For a new app I'm developing I'd like to give it the fast and responsive feel that apps like Linear have. By having real-time querying, syncing and write operations. I'm no expert on the matter, so feel free to educate me. I have looked into a couple of options such as Convex, ElectricSQL, Zero, Liveblocks, etc.. I feel like they always come short in a couple of ways and the best way to summarize that is their modularity.

HackerNews · Accepted Answer

You're looking for a highly modular sync engine that can integrate with your existing Postgres database and backend infrastructure. To achieve real-time querying and syncing, consider using a combination of technologies. One approach is to leverage Postgres's built-in replication features, such as logical replication, to capture changes and propagate them to your application. You can then use a messaging system like Kafka or RabbitMQ to handle the data streaming and processing.

What is the most modular real-time sync engine?

Resources