← Back to Projects
QLite

QLite

Go SQLite Postgres Wire Protocol TCP

A managed SQLite service that speaks the Postgres wire protocol. Any Postgres client — psql, Go's database/sql, Python's psycopg2 — can connect and run queries against SQLite databases.

Technical Highlights

  • Postgres wire protocol implemented from scratch (StartupMessage, SSL negotiation, authentication, query execution, error handling)
  • Multi-tenant architecture where each connection's database name maps to an isolated SQLite file
  • Database branching for instant copies useful for debugging or experimentation
  • Concurrent connections via goroutines with WAL mode for safe parallel reads/writes
    • Source Code