SQLedge is a tool that uses Postgres logical replication to stream changes from a source Postgres database to a SQLite database. It allows for running apps on the edge and provides local, fast, and eventually consistent access to data. SQLedge includes an SQL generator that generates SQLite insert, update, and delete statements based on replication messages. It also uses a Postgres wire proxy to read from the local SQLite database and forward writes to the upstream Postgres server. Compatibility can be an issue when running SQL statements that need to interact with both databases. SQLedge maintains a table to track the progress of replication messages. All configurations are read from environment variables.
https://github.com/zknill/sqledge