Dev tools · alternatives · 2026

24 alternatives to A simple demo of Postgres wire protocol and SQLite as storage engine

postgres + sqlite = pglite. Contribute to viggy28/pglite development by creating an account on GitHub.

This project demonstrates how to build a Postgres-compatible wire protocol implementation using SQLite as the underlying storage engine. It serves as an educational reference for developers interested in understanding… Below are 24 products that do a similar job, ranked by how close each is in meaning and then by launch-day votes. A simple demo of Postgres wire protocol and SQLite as storage engine launched in 2024; newer entries below may have overtaken it.

1. 1
   Embed an SQLite database in your PostgreSQL table▲180

   pglite-fusion is a PostgreSQL extension that allows you to embed SQLite databases into your PostgreSQL tables by enabling the creation of columns with the `SQLITE` type. This means every row in the table can have an embedded SQLite database. In addition to the PostgreSQL `SQLITE` type, pglite-fusion provides the `query_sqlite`` function for querying SQLite databases and the `execute_sqlite` function for updating them. Additional functions are listed in the project’s README. The pglite-fusion extension is written in Rust using the pgrx framework [1]. ---- Implementation Details The PostgreSQL…

   2024 · github.com · its alternatives →

2. 2
   PGlite – in-browser WASM Postgres with pgvector and live sync▲509

   Hey, Sam and the team from ElectricSQL here. PGlite is a WASM Postgres build packaged into a TypeScript/JavaScript client library, that enables you to run Postgres in the browser, Node.js and Bun, with no need to install any other dependencies. It's 3mb Gzipped, now has support for many Postgres extensions, including pgvector, and it has a reactive "live query" API. It's also fast, with CRUD style queries executing in under 0.3 ms, and larger, multi-row select queries occurring within a fraction of a single frame. PGlite started as an experimental project we shared on X, and the…

   2024 · pglite.dev · its alternatives →

3. 3
   ElectricSQL, Postgres to SQLite active-active sync for local-first apps▲617

   Hi HN, James, Valter, Sam and the team from ElectricSQL here. We're really excited to be sharing ElectricSQL with you today. It's an open source, local-first sync layer that can be used to build reactive, realtime, offline-capable apps directly on Postgres with two way active-active sync to SQLite (including with WASM in the browser). Electric comprises a sync layer (built with Elixir) placed in front of your Postgres database and a type safe client that allows you to bidirectionally sync data from your Postgres to local SQLite databases. This sync is CRDT-based, resilient to conflicting…

   2023 · electric-sql.com · its alternatives →

4. 4
   Replicate App-Embedded DuckDBs into PostgreSQL with SyncLite OSS▲73

   Hi HN, We have been building SyncLite, an open-source platform to simplify offline-first application development. If your application uses SQLite or DuckDB, SyncLite lets it continue using the local database as usual while synchronization happens in the background. For SQL-based applications, SyncLite records transactions into transactionally consistent .sqlog files using SQLite as an open replication format. A background consolidator replays those transactions, derives row-level CDC and schema changes, and applies them transactionally to destination databases like PostgreSQL. The same…

   2024 · github.com · its alternatives →

5. 5
   Bi-directional sync between Postgres and SQLite▲356

   Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…

   2023 · powersync.com · its alternatives →

6. 6
   Pg_replicate – Build Postgres replication applications in Rust▲216

   A high-performance Postgres replication engine written in Rust. Embed it in your Rust application or run it as a standalone binary. - supabase/etl

   2024 · github.com · its alternatives →

7. 7
   Turbolite – a SQLite VFS serving sub-250ms cold JOIN queries from S3▲185

   I built a SQLite VFS in Rust that serves cold queries directly from S3 with sub-second performance, and often much faster. It’s called turbolite. It is experimental, buggy, and may corrupt data. I would not trust it with anything important yet. I wanted to explore whether object storage has gotten fast enough to support embedded databases over cloud storage. Filesystems reward tiny random reads and in-place mutation. S3 rewards fewer requests, bigger transfers, immutable objects, and aggressively parallel operations where bandwidth is often the real constraint. This was explicitly inspired…

   Mar 2026 · github.com · its alternatives →

8. 8
   I open-sourced the in-memory PostgreSQL I built at work for E2E tests▲379

   In-memory Postgres for unit/E2E tests. Contribute to hexclave/pgmock development by creating an account on GitHub.

   2024 · github.com · its alternatives →

9. 9
   pgwire-replication - pure rust client for Postgres CDC▲46

   Lean tokio-based Postgres wire-protocol logical replication client (pgoutput) with TLS and SCRAM. - vnvo/pgwire-replication

   Jan 2026 · github.com · its alternatives →

10. 10SO
    SQLite Online – 11 years of solo development, 11K daily users▲465

    SQL OnLine - SQLite, DuckDB, PGLite, MariaDB / MySQL, PostgreSQL, MS SQL Server. AI error analysis, User-friendly interface for Data Science. No registration for start, No DownLoad, No Install. | sql compiler, federated queries, temporal query federation, BI Analytics

    2025 · sqliteonline.com · its alternatives →

11. 11
    Distributed SQLite on FoundationDB▲150

    Hello HN! I'm building mvsqlite, a distributed variant of SQLite with MVCC transactions, that runs on FoundationDB. It is a drop-in replacement that just needs an `LD_PRELOAD` for existing applications using SQLite. I made this because Blueboat (https:&#x2F;&#x2F;github.com&#x2F;losfair&#x2F;blueboat) needs a native SQL interface to persistent data. Apparently, just providing a transactional key-value store isn’t enough - it is more easy and efficient to build complex business logic on an SQL database, and it seems necessary to bring a self-hostable distributed SQL DB onto the platform.…

    2022 · github.com · its alternatives →

12. 12
    MongoDB Protocol for SQLite▲147

    A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.

    2023 · github.com · its alternatives →

13. 13
    gRPSQLite – A SQLite VFS for remote databases via gRPC▲16

    A SQLite VFS for remote databases via gRPC. Contribute to danthegoodman1/gRPSQLite development by creating an account on GitHub.

    2025 · github.com · its alternatives →

14. 14
    PgCat, Postgres pooler with sharding, load balancing and failover▲233

    PostgreSQL pooler with sharding, load balancing and failover support. - postgresml/pgcat

    2022 · github.com · its alternatives →

15. 15
    Postgres as a VectorDB GUI▲162

    Contribute to Z-Gort/Reservoirs-Lab development by creating an account on GitHub.

    2024 · github.com · its alternatives →

16. 16
    Open source, logical multi-master PostgreSQL replication▲151

    Logical multi-master PostgreSQL replication. Contribute to pgEdge/spock development by creating an account on GitHub.

    2025 · github.com · its alternatives →

17. 17UP
    Understand Postgres wire protocol by writing a simple program▲11

    Link to the repo https:&#x2F;&#x2F;github.com&#x2F;viggy28&#x2F;pglite

    2023 · viggy28.dev · its alternatives →

18. 18
    Postgres-SQLite: SQLite as first-class types in Postgres▲15

    In Memory SQLlite as a Postgres data type. Contribute to michelp/postgres-sqlite development by creating an account on GitHub.

    2025 · github.com · its alternatives →

19. 19
    Rqlite v4.0 – With node-to-node encryption▲101

    The lightweight, fault-tolerant database built on SQLite. Designed to keep your data highly available with minimal effort. - Release v4.0.0 · rqlite/rqlite

    2017 · github.com · its alternatives →

20. 20
    Rlite – A serverless Redis-compatible database▲27

    self-contained, serverless, zero-configuration, transactional redis-compatible database engine. rlite is to Redis what SQLite is to SQL. - seppo0010/rlite

    2015 · github.com · its alternatives →

21. 21
    Cloud-Ready Postgres MCP Server▲167

    Hey HN, I built pg-mcp, a Model Context Protocol (MCP) server for PostgreSQL that provides structured schema inspection and query execution for LLMs and agents. It's multi-tenant and runs over HTTP&#x2F;SSE (not stdio) Features - Supports multiple database connections from multiple agents - Schema Introspection: Returns table structures, types, indexes and constraints; enriched with descriptions from pg_catalog. (for well documented databases) - Read-Only Queries: Controlled execution of queries via MCP. - EXPLAIN Tool: Helps smart agents optimize queries before execution. - Extension…

    2025 · github.com · its alternatives →

22. 22
    Serverless Postgres▲159

    This is a MVP for Serverless Postgres. 1&#x2F; It uses Fly.io[0], which can automatically pause your database after all connections are released (and start it again when new connections join). 2&#x2F; It uses Oriole[1], a Postgres extension with experimental support for S3 &#x2F; Decoupled Storage[2]. 3&#x2F; It uses Tigris[3], Globally Distributed S3-Compatible Object Storage. Oriole will automatically backup the data to Tigris using background workers. I wouldn't recommend using this in production, but I think it's in a good spot to provoke some discussion and ideas. You can get it running…

    2024 · github.com · its alternatives →

23. 23RA
    RedixDB – a fast persistent key-value store with the Redis protocol▲75

    a very simple pure key => value storage system that speaks Redis protocol with Postgres as storage engine and more

    2018 · alash3al.github.io · its alternatives →

24. 24AT
    A tool to seed your dev database with real data▲129

    A bunch of developers and myself have created RepliByte - an open-source tool to seed a development database from a production database. Features: - Support data backup and restore for PostgreSQL, MySQL and MongoDB - Replace sensitive data with fake data - Works on large database (> 10GB) (read Design) - Database Subsetting: Scale down a production database to a more reasonable size - Start a local database with the prod data in a single command - On-the-fly data (de)compression (Zlib) - On-the-fly data de&#x2F;encryption (AES-256) - Fully stateless (no server, no daemon) and lightweight…

    2022 · its alternatives →

Ranked by how close each launch is in meaning, then by votes. Prices were read from each product’s own site when checked and can change. Refine with your own description →