Ask HN: How Can I Make My Front End React to Database Changes in Real-Time?

1. Hasura

   1 234 31,487 9.9 TypeScript

   Blazing fast, instant realtime GraphQL APIs on all your data with fine grained access control, also trigger webhooks on database events.

   

   [4] https://github.com/hasura/graphql-engine/blob/master/architecture/live-queries.md

2. Civic Auth

   www.civic.com featured

   Auth in Less Than 5 Minutes. Civic Auth comes with multiple SSO options, optional embedded wallets, and user management — all implemented with just a few lines of code. Start building today.

   

3. readyset

   2 25 4,948 9.8 Rust

   Readyset is a MySQL and Postgres wire-compatible caching layer that sits in front of existing databases to speed up queries and horizontally scale read throughput. Under the hood, ReadySet caches the results of cached select statements and incrementally updates these results over time as the underlying data changes.

   

   - Some platforms like Supabase Realtime [3] and Firebase offer subscription models to database changes, but these solutions fall short when dealing with complex queries involving joins or group-bys.

   My vision is that the modern frontend to behave like a series of materialized views that dynamically update as the underlying data changes. Current state management libraries handle state trees well but don't seamlessly integrate with relational or graph-like database structures.

   The only thing I can think of is to implement it by myself, which sounds like a big PITA.

   Anything goes, Brainstorm with me. Is it causing you headaches as well? Are you familiar with an efficient solution? how are you all tackling it?

   [1] https://readyset.io/

4. materialize

   3 127 5,959 10.0 Rust

   Real-time Data Integration and Transformation: use SQL to transform, deliver, and act on fast-changing data. (by MaterializeInc)

   

   [2] https://materialize.com/

5. RxDB

   4 50 22,269 9.9 TypeScript

   A fast, local first, reactive Database for JavaScript Applications https://rxdb.info/

   

   I'm interested in this problem also!

   I think there is a large overlap with projects that market/focus on offline-first experiences.

   AFAIK this problem can be solved by:

   1) Considering a client-side copy of the database that gets synced with the remote DB. This is an approach [PowerSync](https://www.powersync.com/) and [ElectricSql](https://electric-sql.com/) and [rxdb](https://rxdb.info/) take!

6. electric

   5 37 8,125 9.9 Elixir

   Real-time sync for Postgres.

   

   I'm interested in this problem also!

   I think there is a large overlap with projects that market/focus on offline-first experiences.

   AFAIK this problem can be solved by:

   1) Considering a client-side copy of the database that gets synced with the remote DB. This is an approach [PowerSync](https://www.powersync.com/) and [ElectricSql](https://electric-sql.com/) and [rxdb](https://rxdb.info/) take!

7. materialite

   6 2 137 8.9 TypeScript

   Differential Dataflow & Incremental View Maintenance for JavaScript

   

   Hey, Electric co-founder here.

   Yup, our reactivity is quite simple at the moment, as described, and works quite well because SQLite is so fast. There are other projects doing more sophisticated reactivity algorithms, like Riffle/LiveStore, which has a reactive DAG optimised to avoid re-rendering and https://github.com/vlcn-io/materialite, which is like differential dataflow for live queries.

   They're quite bleeding edge at the moment, but you can expect more efficient primitives for incremental view maintenance / efficient subscriptions to land in the embedded database layer quite soon.

   Just also re: above, shape filtering for partial sync landed in v0.10 https://electric-sql.com/blog/2024/04/10/electricsql-v0.10-r... :)

8. RethinkDB

   7 27 26,873 1.2 C++

   The open-source database for the realtime web.

   

9. CodeRabbit

   coderabbit.ai featured

   CodeRabbit: AI Code Reviews for Developers. Revolutionize your code reviews with AI. CodeRabbit offers PR summaries, code walkthroughs, 1-click suggestions, and AST-based analysis. Boost productivity and code quality across all major languages with each PR.

   

10. perspective

    8 59 9,091 9.4 C++

    A data visualization and analytics component, especially well-suited for large and/or streaming datasets.

    

Suggest a related project