Postlite is an archived proof-of-concept proxy that makes remote SQLite databases accessible through the PostgreSQL wire protocol. It lets standard PostgreSQL clients connect to SQLite files as if they were regular Postgres databases. The proxy translates PostgreSQL frontend messages into SQLite transactions, then converts SQLite results back into PostgreSQL-compatible responses. It also mirrors parts of the PostgreSQL catalog through an attached in-memory database with virtual tables. This helps GUI clients inspect schema and system information more successfully. Postlite is useful as a reference for protocol translation, SQLite administration experiments, and lightweight database tooling, but it is no longer maintained.
Features
- PostgreSQL wire protocol proxy
- Remote SQLite database access
- Postgres client compatibility goal
- SQLite transaction translation
- In-memory pg_catalog simulation
- Archived Go proof of concept