Go and SQLite in the Cloud

• rqlite

  112 14,862 9.9 Go

  The lightweight, distributed relational database built on SQLite.

  

Once you need to graduate from one large server (which will take you a long way in many cases), there are tools like [rqlite](https://github.com/rqlite/rqlite) that can handle clustering. With WAL mode enabled, SQLite can handle a surprising amount of traffic that would fit a lot of use cases.

• datasette

  187 8,881 9.2 Python

  An open source multi-tool for exploring and publishing data

A long way off from PostgREST, but you might be able to hack together something sort of similar with Datasette [0] and the new JSON api. Not out of the box at all, but the potential is there to get a similar product.

[0]: https://datasette.io/

• 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.

  

• postlite

  18 1,190 0.0 Go

  Discontinued Postgres wire compatible SQLite proxy.

I've not use this myself, but Ben Johnson's https://github.com/benbjohnson/postlite in front of SQlite might allow you to use PostgREST? I recall him saying on a podcast that his goal was to be able to point the large ecosystem of PG tools at SQlite.

• sqlc

  169 10,837 9.7 Go

  Generate type-safe code from SQL

  

Not exactly what you want, but I've been using https://sqlc.dev to generate hydration code from SQL queries and loving it!

• marmot

  33 1,621 8.6 Go

  A distributed SQLite replicator built on top of NATS

Hey, I am author of Marmot (https://github.com/maxpert/marmot) would love to get in touch and explore a few things with you. I’ve been using Marmot in production in a while scaling couple of services, and since you mentioned LiteFS I would love to pick your brain, and explore couple of ideas with you. Multiple ways to get in touch including Github discussions or discord channel. Hope to see you around!

• showcase

  10 150 4.7 TypeScript

  REST api for your database (PostgreSQL/Sqlite/ClickHouse/MySQL).

  

Yes there is but not FOSS

https://github.com/subzerocloud/showcase/tree/main/flyio-sql...

• go-sqlite-bench

  2 3 10.0 Go

  Benchmarking Go + SQLite (by kalafut)

Finally got around to this: https://github.com/kalafut/go-sqlite-bench

• 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.

  

Suggest a related project