SQLite-on-the-Server Is Misunderstood: Better at Hyper-Scale Than Micro-Scale

1. td

   1 20 8,844 9.9 C++

   Cross-platform library for building Telegram clients

   

   TDLib (Telegram Database library)[0] uses SQLite.

   In Telegram Bot API, each TDLib instance handles more than 24,000 active bots simultaneously.[1]

   [0]: https://github.com/tdlib/td

   [1]: https://core.telegram.org/tdlib

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. litestream

   2 199 13,714 9.6 Go

   Streaming replication for SQLite.

   

   Maybe I am misunderstanding which part you want in the cloud, but that sounds like litestream https://litestream.io/

4. starbasedb

   3 5 1,156 1.4 TypeScript

   HTTP SQLite scale-to-zero database on the edge built on Cloudflare Durable Objects.

   

   The folks over at StarbaseDB (https://starbasedb.com/) are working on building tools for shareded SQLite.

   From the companies I've talked to, most developers using this architecture are building quick scripts to do this in-house. Both Turso and Durable Objects SQLite already a surprising amount of usage that people don't talk about much publicly yet, so I suspect some of this tooling will start to be published in the next year.

5. ClickBench

   4 104 1,021 9.9 HTML

   ClickBench: a Benchmark For Analytical Databases

   

6. Internet-Places-Database

   5 60 413 8.2 JavaScript

   Database of Internet places. Mostly domains

   

   Might be a little bit off topic. I created a web page, with data. I didn't want to host VPS, be charged for traffic. I do not want also to play with cloudflare and self-hosting.

   My solution? The app is a webpage, which reads SQLite. If user wants to use app, the database is downloaded, unpacked, and used on users device.

   Links:

   - https://github.com/rumca-js/Internet-Places-Database - search.html provides a preview for my database file (but code supports also reading zip file).

   - https://rumca-js.github.io/search?file=top&page=1&search=neo... - uses JSON files stored in a zip file. Will be replaced soon with zip + sqlite file

   - https://rumca-js.github.io/search?file=music&view_display_ty... - example showing my fav music. As above uses JSON files, in a zip file

7. mvsqlite

   6 30 1,556 3.9 Rust

   Distributed, MVCC SQLite that runs on FoundationDB.

   

   SQLite has the ability to do exactly this, minus the versioning: https://sqlite.org/cloudsqlite/doc/trunk/www/index.wiki

   Implementing snapshot backups on top of that would be as simple as a VACUUM and S3 PUT

   For point-in-time restores, mvsqlite is a cool solution: https://github.com/losfair/mvsqlite

Suggest a related project