Skip to content

Releases: mahabubul470/liveSQL

v1.0.0-beta.1

07 Mar 18:16

Choose a tag to compare

v1.0.0-beta.1 Pre-release
Pre-release

LiveSQL v1.0.0-beta.1

First public beta. All packages published to npm with the beta dist-tag.

Install

npm install @livesql/server@beta @livesql/core@beta
npm install @livesql/react@beta        # or vue, svelte

What's included

  • WAL-based CDC — PostgreSQL logical replication via pgoutput for guaranteed delivery
  • Reconnection backfill — clients resume from last offset, missed events replayed
  • JWT auth — query param or Authorization header, with table and row-level permissions
  • Server-side filtering"status = shipped" syntax, no SQL execution
  • Event batching — up to 50 events or 16ms flush interval
  • Backpressure detection — drops events for slow clients (bufferedAmount > 1MB)
  • Framework SDKs — React (useLiveQuery, useLiveTable), Vue (useLiveQuery, useLiveTable), Svelte (liveQuery, liveTable)
  • WAL slot monitoring — lag warnings, inactive slot detection
  • Failover recovery — automatic replication slot recreation
  • Observability hooks — onEvent, onClientConnect, onClientDisconnect, onBackpressure, onSlotLost

Testing

  • 163 tests across 15 test files (unit, integration, chaos)
  • 23 chaos tests covering 6 failure modes
  • k6 load test: 1,000 concurrent clients, p95 96ms, 0% connection failures

Docs

Feedback

This is a beta — the API may change based on community feedback. Please open issues for bugs, ergonomic problems, or feature requests.

Full changelog: https://github.com/mahabubul470/LiveSQL/blob/main/CHANGELOG.md