Why SQLite may become foundational for digital progress

• sqlitebrowser

  281 20,946 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:

  

• InfluxDB

  www.influxdata.com featured

  Purpose built for real-time analytics at any scale. InfluxDB Platform is powered by columnar analytics, optimized for cost-efficient storage, and built with open data standards.

  

• comdb2

  5 1,359 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

• sqlitestudio

  44 4,534 9.8 C

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

• datasette

  189 9,389 9.3 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,684 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

  6 219 0.0 Rust

  sqlite as a filesystem

• SaaSHub

  www.saashub.com featured

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

  

• sqlitefs

  2 13 4.5 Go

  sqlite as a filesystem for golang apps (by jilio)

• sqlite-gui

  26 1,089 4.0 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