Show HN: ElectricSQL, Postgres to SQLite active-active sync for local-first apps

Re:Show HN: ElectricSQL, Postgres to SQLite active-active sy... by prepor on Thursday September 21, 2023 @11:39AM (#37599304)

> Writes automatically cause any relevant live queries to update.

How do you decide what queries are relevant?

[ Parent | on HN ]

Re:Show HN: ElectricSQL, Postgres to SQLite active-active sy... by prepor on Thursday September 21, 2023 @11:45AM (#37599395)

https://github.com/electric-sql/electric/blob/main/clients/t...

  // Once we have electric, we then establish the data change
  // notification subscription, comparing the tablenames used by the
  // query with the changed tablenames in the data change notification
  // to determine whether to re-query or not.
  //
  // If we do need to re-query, then we use the saved function to reuse the query

So it re-runs queries on all updates in tables from the query.

[ Parent | on HN ]