Skip to main content

Local-First Apps

WorkaDB enables local-first applications to use full PostgreSQL SQL features without running a server. This is useful when you need JSON queries, window functions, or strict transaction semantics on-device.

Pattern​

  • Use WorkaDB as the local store for application state.
  • Replicate to a server-side PostgreSQL instance for sync.
  • Keep schemas identical across local and server deployments.

Because the engine uses PostgreSQL semantics, the same SQL runs everywhere.