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.
Synthesized Answer
Based on 3 community responses
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.
Key Takeaways
Use Postgres's logical replication to capture changes
Leverage a messaging system like Kafka or RabbitMQ for data streaming
Implement a custom query engine using SQLAlchemy or Drizzle schemas
I think you can use Tanstack DB in this case. It fits what you need ideally, if I'm not wrong. It's a wrapper over Electric. However, it's currently in beta, so you can check it out. It's too handy and simple