Why SQLite may become foundational for digital progress

• sqlitebrowser

  279 19,896 9.0 C++

  Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

  

• comdb2

  4 1,284 9.6 C

  Bloomberg's distributed RDBMS

  

Bloomberg [1] uses SQLite in a custom distributed RDBMS engine of theirs in a way I lack the knowledge to completely understand its design.

I remember Richard Hipp mentioning Bloomberg in one of his interviews (don't ask me which one, I don't remember), that they use SQLite to serve billions of bank transaction on a daily basis without a problem.

  [1] https://github.com/bloomberg/comdb2

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

  

• sqlitestudio

  41 4,195 9.2 C

  A free, open source, multi-platform SQLite database manager.

• datasette

  186 8,862 9.2 Python

  An open source multi-tool for exploring and publishing data

I personally love DBeaver for SQL, but I did stumble across a thats-not-how-it-was-intended-for-usecase for Datasette [0]. Datasette is intended to be a way to share static SQLite databases. However, I was recently debugging a Django application where I lacked appropriate tooling to inspect what was happening in the database. However, I am a huge fan of Datasette, so why not? While the Django debug server was running, I was able to launch datasette in a separate terminal and have a live view into the database while the application was free to mutate the underlying data. You can even write custom SQL inside the browser to select/modify any interesting data.

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

• termdbms

  18 1,628 0.0 Go

  A TUI for viewing and editing database files.

https://github.com/mathaou/termdbms

Granted I'm the author, but until I get around to rewriting it from the ground up, I really think it saves a lot of time for editing single cells, querying, and viewing in a headless environment.

• sqlitefs

  1 1 10.0 Java

  Simple file system over SQLite (by andyhebear)

[3] is in Go, lacks a LICENSE file, has been inactive four months, the README is in Russian, but well the demo code works. pkg.go.dev will not display its API.

[1] https://github.com/andyhebear/sqlitefs

• sqlitefs

  4 46 10.0 Rust

  sqlite as a filesystem

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

  

• sqlitefs

  2 12 4.7 Go

  sqlite as a filesystem for golang apps (by jilio)

• sqlite-gui

  26 1,043 4.2 C

  Lightweight SQLite editor for Windows

I've tried over 15 sqlite management tool, but SqliteStudio is my favorite! And recently discovered https://github.com/little-brother/sqlite-gui

Suggest a related project