# zknill/sqledge

Replicate postgres to SQLite on the edge

Repository: https://github.com/zknill/sqledge
Canonical: https://ross.abutalabs.com/products/sqledge
Language: Go
License Family: other
Last push: 2024-06-17T10:09:56+00:00

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

## Adoption (not part of the score)
Stars 1041, forks 21 (observed 2026-08-28T04:03:20.559191+00:00)

## What it is
SQLedge replicates a Postgres database to a local SQLite file using Postgres logical replication, serving reads from SQLite while forwarding writes to upstream Postgres. It includes a Postgres wire-protocol proxy so applications can connect as if to Postgres and get fast, eventually consistent local reads.

## Use cases
- run read-heavy apps at the edge with local SQLite reads
- replicate postgres to sqlite for fast local queries
- serve reads locally while writing to a central postgres
- proxy postgres wire protocol with sqlite-backed reads
- eventually consistent read replica on the edge
- stream postgres changes into an embedded sqlite database

## When to choose
- your workload is read-heavy and can tolerate eventual consistency
- you want low-latency local reads close to your app
- your read queries are simple SELECTs compatible with SQLite syntax
- you want a lightweight read replica without running a full Postgres instance

## When to avoid
- you need Postgres-specific SQL functions or syntax in read queries
- you require strong consistency between reads and writes
- you need a production-stable, well-supported solution (project is alpha with no license)
- your schema relies on Postgres features SQLite lacks, like complex types or extensions

## Facets
- artifact type: service
- maturity: experimental
- function: database, streaming, proxy, http-server
- domain: databases, microservices, backend, developer-tools
- platform: go, self-hosted
- tags: postgres, sqlite, logical-replication, edge-computing, read-replica, wire-protocol, linux, macos

## Member repositories
- zknill/sqledge (main) score 28

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:03:20.559191+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-30T07:03:00.161058+00:00, confidence not recorded.
  - readme: https://github.com/zknill/sqledge (fetched 2026-08-28T04:03:20.559191+00:00, sha d90069ace660)
- Data as of 2026-08-30T08:39:29.467469+00:00.