dogpawhat.tech / preloading-example
this repo has no description
0
fork

Configure Feed

Select the types of activity you want to include in your feed.

preloading-example / src / articles / __content / live-query.md
at main 1.0 kB view raw view code
Ciarán Curley what a trip
fdca93e7

Electric SQL synced collection#

Live queries use Electric SQL to keep client-side data in sync with the server database in real time. Instead of polling or manual refetching, database changes are pushed to connected clients automatically.

How it works#

  1. The client establishes a sync connection to the Electric SQL server
  2. A live query is defined using the TanStack DB collection API
  3. When database records change, updates stream to connected clients
  4. The UI re-renders automatically with fresh data

Benefits#

  • Real-time updates: Changes appear immediately without manual refresh
  • Offline support: Local data remains available during connectivity interruptions
  • Multi-user: All connected clients see each other's changes in real time

Trade-offs#

Live queries require the Electric SQL sync infrastructure. They introduce additional complexity compared to simple REST fetching but are the right choice for collaborative or real-time applications where data freshness matters.