Live Queries in SurrealDB enable a simple yet seamless way of building modern, responsive applications, whether connecting to SurrealDB as a traditional backend database, or when connecting directly to the database from the frontend. Live queries give developers the ability to receive real-time change notifications to data as it is happening, without the ability to subscribe to historic changes.
integrated directly within the table, row, and field level permissions of SurrealDB, each live query notification is unique and tailored to the authentication of the user who issued the query. Regardless of what a user has subscribed to, notifications will only be delivered based on the authenticated session of that user.
Live queries support subscribing to full record data, receiving only partial record updates with specific projected fields, or by using a native JSON-patch and diff-patch-match implementation - even the exact concise document changes as they occur, whenever a document is modified.
By bringing the simplicity of Live Queries alongside the advanced nature of pre-defined aggregate views, you can now build powerful dashboards that rely on aggregate data queries, computationally expensive analytics queries, and filtered collections of massive data sets - that update in real time as your data in the database changes.