SQLite-based databases on the Postgres protocol? Yes we can

• postlite

  18 1,190 0.0 Go

  Discontinued Postgres wire compatible SQLite proxy.

Note that this already exists on top of SQLite proper - authored by Ben Johnson (Litestream, Fly.io etc.) - https://github.com/benbjohnson/postlite

• libsql

  21 7,720 9.9 C

  libSQL is a fork of SQLite that is both Open Source, and Open Contributions.

  

Wild stuff

- Fork of SQLite with new features https://github.com/libsql/libsql

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• sqld

  9 917 9.6 Rust

  Discontinued LibSQL with extended capabilities like HTTP protocol, replication, and more.

  

- And you can embed it in your application and it will really talk to a "SQLite" database over the network: https://github.com/libsql/sqld (not a lot on consistency, I wonder how multiple writers are handled?)

• bottomless

  1 33 1.8 Rust
  

- Oh, and if you're wondering about backup to S3, they have that too: https://github.com/libsql/bottomless

- Uh, sqld can integrated with this https://github.com/losfair/mvsqlite, so now your SQLite is backed by FoundationDB!?

- Meanwhile Litestream exists https://github.com/benbjohnson/litestream/

• mvsqlite

  26 1,318 0.0 Rust

  Distributed, MVCC SQLite that runs on FoundationDB.

- Oh, and if you're wondering about backup to S3, they have that too: https://github.com/libsql/bottomless

- Uh, sqld can integrated with this https://github.com/losfair/mvsqlite, so now your SQLite is backed by FoundationDB!?

- Meanwhile Litestream exists https://github.com/benbjohnson/litestream/

• litestream

  165 9,964 7.5 Go

  Streaming replication for SQLite.

- Ben is developing https://github.com/superfly/litefs at Fly after stopping the streaming replication effort https://github.com/benbjohnson/litestream/issues/8

- And, of course, SQLite has announced a new backend that hopes to support concurrent writes and streaming replication: https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html

What a time for SQLite

• litefs

  38 3,620 8.0 Go

  FUSE-based file system for replicating SQLite databases across a cluster of machines

  

- Ben is developing https://github.com/superfly/litefs at Fly after stopping the streaming replication effort https://github.com/benbjohnson/litestream/issues/8

- And, of course, SQLite has announced a new backend that hopes to support concurrent writes and streaming replication: https://sqlite.org/hctree/doc/hctree/doc/hctree/index.html

What a time for SQLite

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• StorX

  5 14 10.0 PHP

  PHP library for flat-file data storage

I wrote a small PHP library that gives you a key-value storage interface to SQlite files: https://github.com/aaviator42/StorX

I've been dogfooding for a while by using it in my side projects.

And there's a basic API too, to use it over a network: https://github.com/aaviator42/StorX-API

• StorX-API

  2 2 10.0 PHP

  A REST API for StorX

I wrote a small PHP library that gives you a key-value storage interface to SQlite files: https://github.com/aaviator42/StorX

I've been dogfooding for a while by using it in my side projects.

And there's a basic API too, to use it over a network: https://github.com/aaviator42/StorX-API

• roapi

  24 3,070 6.9 Rust

  Create full-fledged APIs for slowly moving datasets without writing a single line of code.

  

Very cool and well executed project. Love the sprinkle of Rust in all the other companion projects as well :)

The ROAPI(https://github.com/roapi/roapi) project I built also happened to support a similar feature set, i.e. to expose sqlite through a variety of remote query interfaces including pg wire protocols, rest apis and graphqls.

• stream-sqlite

  2 23 0.0 Python

  Python function to extract rows from a SQLite file while iterating over its bytes

  

Related: michaelc @ uktrade did some intresting work streaming sqlite with python in this repo - https://github.com/uktrade/stream-sqlite

Suggest a related project