SQLedge

lastmod 2023-08-22created 2023-08-221 edits

A tool that replicates Postgres to SQLite at the Edge

Features

• Streams changes to SQLite using Postgres logical replication
• Includes a built-in Postgres Wire Proxy, so it runs as if connecting to Postgres
  • Reads run on the local SQLite, and writes are forwarded to the upstream Postgres being replicated
  • This lets apps run fast and locally at the Edge, and implements eventually consistent data access
• Currently no separate SQL translation is done, so only syntax that works on SQLite can be used (simple things like SELECT; Postgres-specific functions and syntax are not supported)

See also

• Postgres
• SQLite

Favorite site

• zknill/sqledge