# benbjohnson/postlite

Postgres wire compatible SQLite proxy.

Repository: https://github.com/benbjohnson/postlite
Canonical: https://ross.abutalabs.com/products/postlite
Language: Go
License: Apache-2.0
License Family: permissive
Archived: true
Last push: 2023-10-02T13:49:22+00:00

## Health v2 (maintenance only)
Score: 10/100 (v2, computed 2026-09-02T17:46:02.011165+00:00)
- activity 0, release rhythm 35, longevity 100
- inputs: {"age_days": 1617, "days_push": 1066, "days_rel": null, "gap_med": null, "n_releases_24m": 0}
- flags: no_releases, archived
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1228, forks 37 (observed 2026-08-28T04:04:03.514701+00:00)

## What it is
Postlite is a Go network proxy that exposes remote SQLite databases over the Postgres wire protocol, translating Postgres frontend messages into SQLite transactions and back. It also mirrors the pg_catalog via virtual tables so standard Postgres GUI tools and clients can connect to SQLite files.

## Use cases
- connect psql or a Postgres GUI tool to a remote SQLite database
- administer SQLite databases over the network using Postgres clients
- run queries against SQLite files through the standard Postgres port 5432
- browse remote SQLite data with database management tools

## When to choose
- you need to use Postgres-based GUI tools or psql against remote SQLite files
- you want a lightweight proxy without converting your databases to Postgres

## When to avoid
- you need a maintained or production-ready solution (the project is explicitly unmaintained)
- you need full Postgres feature support rather than basic wire-protocol translation
- you only access SQLite locally and don't need network access

## Facets
- artifact type: service
- maturity: abandoned
- function: proxy, database, http-server
- domain: databases, developer-tools, self-hosted
- platform: windows, cross-platform, cli, go
- tags: postgres-wire-protocol, sqlite, network-proxy, proof-of-concept, unmaintained, linux, macos

## Member repositories
- benbjohnson/postlite (main) score 10

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:03.514701+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T06:15:10.058320+00:00, confidence not recorded.
  - readme: https://github.com/benbjohnson/postlite (fetched 2026-08-28T04:04:03.514701+00:00, sha 49b0b1a95bea)
- Data as of 2026-08-30T08:39:29.467469+00:00.