r/sqlite • u/StatureDelaware • Jul 18 '25
r/sqlite
•
u/copilot_husky
•
Jun 10 '26
Lifetime award to Richard Hipp for SQLite
At #CesiumDevConf in phili. I had chance to talk to him.
r/sqlite • u/albertsteenstrup • Apr 25 '26
SQLite GUI (SQLite Graph Studio)
Hi all,
I am a soon-to-graduate data scientist and like many others these days have a lot of side projects on my table. Many of them are at some point touching local databases, where sqlite is a great fit. I was looking through existing SQLite GUI's (https://www.beekeeperstudio.io/, https://sqlitebrowser.org/, https://sqlitestudio.pl/) simply to give me an overview of my data and do simple edits/queries, but found that a lot of them is either behind a paywall and/or doesn't offer quick overviews of the data like .e.g supabase schema visualiser does fairly well.
So I spend a couple of days creating SQLite Graph Studio, which is open source and free to download as well. Useful for fast iterating projects. Not intended for production environments. Build in swift, as I wanted to try out a skill in codex. It is created with coding agent platforms (Codex, Kiro and vscode copilot).
Feedback welcome!
Features:
Interactive schema graph with foreign-key relationships and cardinality
Inline row editing with right-click actions (add, clone, delete)
SQL query runner with explain as well
Column sorting, filtering, and search
Multi-node selection and dragging
Minimap for large schemas
r/sqlite • u/trailbaseio • Feb 21 '26
TrailBase 0.24: Fast, open, single-executable Firebase alternative now with Geospatial
TrailBase is a Firebase alternative that provides type-safe REST & realtime APIs, auth, multi-DB, a WebAssembly runtime, SSR, admin UI... and now has first-class support for geospatial data and querying. It's self-contained, easy to self-host, fast and built on Rust, SQLite & Wasmtime.
Moreover, it comes with client libraries for JS/TS, Dart/Flutter, Go, Rust, .Net, Kotlin, Swift and Python.
Just released v0.24. Some of the highlights since last time posting here include:
Support for efficiently storing, indexing and querying geometric and geospatial data š
For example, you could throw a bunch of geometries like points and polygons into a table and query: what's in the client's viewport? Is my coordinate intersecting with anything? ...
Much improved admin UI: pretty maps and stats on the logs page, improved accounts page, reduced layout jank during table loading, ...
Change subscriptions using WebSockets in addition to SSE.
Increase horizontal mobility, i.e. reduce lock-in: allow using TBs extensions outside, allow import of existing auth collections (i.e. Auth0 with more to come), dual-licensed clients under more permissive Apache-2, ...
Check out the live demo, our GitHub or our website. TrailBase is only about a year young and rapidly evolving, we'd really appreciate your feedback š
r/sqlite • u/trailbaseio • Dec 12 '25
TrailBase 0.22: Open, single-executable, SQLite-based Firebase alternative now with multi-DB
TrailBase is an easy to self-host, sub-millisecond, single-executable FireBase alternative. It provides type-safe REST and real-time APIs, WASM runtime, auth & admin UI. Comes with type-safe client libraries for JS/TS, Dart/Flutter, Go, Rust, .Net, Kotlin, Swift and Python. Its WASM runtime allows authoring custom endpoints and SQLite extensions in JS/TS or Rust (with .NET on the way).
Just released v0.22. Some of the highlights since last time posting here include:
Multi-DB support š: record APIs can be backed by `TABLE`/`VIEW`s of independent DBs.
This can help with physical isolation and offer a path when encountering locking bottlenecks.
Better admin UI: Schema visualizer now also on mobile, column visibility control, NULL filtering and many more tweaks.
Extended WASM component/plugin management.
Check out the live demo, our GitHub or our website. TrailBase is only about a year young and rapidly evolving, we'd really appreciate your feedback š
r/sqlite • u/trailbaseio • Nov 13 '25
TrailBase 0.21: Open, single-executable, SQLite-based Firebase alternative with a WASM runtime
TrailBase is an easy to self-host, sub-millisecond, single-executable FireBase alternative. It provides type-safe REST and real-time APIs, auth & admin UI. Its built-int WASM runtime enables custom extensions using JS/TS or Rust (with .NET on the way). Comes with type-safe client libraries for JS/TS, Dart/Flutter, Go, Rust, .Net, Kotlin, Swift and Python.
Just released v0.21. Some of the highlights since last time posting here include:
Extended WASM component model: besides custom endpoints, "plugins" can now provide custom SQLite functions for use in arbitrary queries, including VIEW-based APIs.
The admin UI has seen major improvements, especially on mobile. There's still ways to go, would love your feedback š.
Convenient file access and image preview via the admin UI.
Much improved WASM dev-cycle: hot reload, file watcher for JS/TS projects, and non-optimizing compiler for faster cold loads.
Many more improvements and fixes, e.g. stricter typing, Apple OAuth, OIDC, support for literals in VIEW-based APIs, ...
Check out the live demo, our GitHub or our website. TrailBase is only about a year young and rapidly evolving, we'd really appreciate your feedback š
r/sqlite • u/Nthomas36 • Aug 13 '26
How we tracked down a 16-year-old SQLite bug
Interesting article
r/sqlite • u/Maxteabag • Dec 15 '25
Sqlit - Terminal UI for browsing SQLite databases


I wanted a fast way to connect and browse my database without opening a heavy GUI. I tried some other TUI's but they were never intuitive for me.
So I created Sqlit - a lightweight, keyboard-driven TUI that lets you open SQLite files, browse tables, and run queries. Just point it at a .db file and execute some queries.
Features:
- Open local .db files directly
- Browse tables, views, and schema
- Run queries with syntax highlighting and autocomplete
- SSH tunnel support (inspect SQLite on remote servers)
- Vim-style editing
- Themes (Tokyo Night, Nord, etc.)
Its main focus is to make it enjoyable to connect, browse and query your database. It tries to do one thing really well, and it deliberately avoids competing with massive, feature-rich GUI's that take forever to load and bloated with features you never use.
r/sqlite • u/Limp_Celery_5220 • Dec 29 '25
Manage SQLite, MySql, Postgres, MongoDB, and Elasticsearch in a single app
I just added a new database library toĀ DevScribe. It now supportsĀ MySQL, SQLite, PostgreSQL, MongoDB, and ElasticsearchĀ ā all in a single application.
You can write andĀ document your database queriesĀ alongside your project documentation, and alsoĀ visualize the database schemaĀ in the same place. No more jumping between DB tools and docs.
Everything isĀ local-first and offline, so your data stays on your machine.
I originally built DevScribe for my own backend work to reduce tool switching, and this update moves it closer to that goal. Happy to hear feedback or suggestions from others who deal with multiple databases.
r/sqlite • u/fdelux6 • Oct 10 '26
SQLite 3.54.0 released
Release log: https://sqlite.org/releaselog/3_54_0.html
Some items that stood out to me:
About 4% faster on speedtest1, and about 7.5% faster than 3.51.0 from a year ago
CLI now shows column headers by default even when a query returns no rows
.diskusedis now built into the CLI, and sqlite3_analyzer is deprecatedNew %j and %J conversions in printf() and format() for JSON string literals
UPDATE skips expression indexes when the indexed value is unchanged
r/sqlite • u/s13k_ • May 09 '26
Real-workload SQLite benchmark on a $5 VPS
I ordered the cheapest Hetzner CX23 ($4.99/mo, shared-resources tier) and ran a real-workload SQLite benchmark on it. Not a microbenchmark ā a 6 GB database on a box with 3.7 GB of RAM, so reads actually have to touch disk.
Mixed OLTP workload (70% reads, 25% updates, 5% inserts): 3.9k ops/s, p99 = 710 µs, p999 = 2.2 ms.
= 14 million ops/hour on a $5 VPS, with sub-3 ms tail latency.
r/sqlite • u/principleMd • Jul 07 '26
Sqlite has about 1.2 million lines of code and 40% are from one contributor. The man behind Sqlite Dr Richard Hipp
r/sqlite • u/swe129 • Apr 02 '26
SQLite Features You Didnāt Know It Had: JSON, text search, CTE, STRICT, generated columns, WAL
r/sqlite • u/geekwithattitude_ • Apr 13 '26
I'm sharding SQLite by entity with BEAM actors. 1.5M events/sec on 5 cores.
I wanted to explore what happens if you take SQLite seriously as a production database but shard it by entity (user, account, device) instead of by table.
Each entity gets its own partition in one of N SQLite shard files. Each shard has its own writer actor (BEAM/Erlang process) that batches writes into transactions. Reads for a single entity come from actor memory (nanoseconds). Cross-entity queries go through rqlite projections.
On an M1 with the standard write path: 63K events/sec (vs 30K Cassandra, 18K CockroachDB on same hardware). In Docker with the native C writer and 5 cores: 1.5M events/sec. ScyllaDB on the same Docker setup: 49K. macOS performs slightly worse than Linux due to I/O scheduling so the Docker numbers are higher.
The batch path packs 500 events into a single NIF call, 2 Erlang messages per 500 events vs 1000 for individual writes.
Backups use Litestream streaming every WAL change to S3. Scaling is "add a node, entities redistribute via consistent hashing."
Written in Gleam. Has a TypeScript SDK.
https://warp.thegeeksquad.io
Benchmarks: https://gitlab.com/dwighson/warp/-/blob/master/docs/benchmarks.md
r/sqlite • u/dsecurity49 • May 30 '26
I built a job queue using Flask and SQLite instead of Redis ā here's what I learned about SQLite under load
The project is called Intent Bus. I built it because I wanted to trigger scripts on my devices from a cloud server without opening ports or setting up Redis for something that runs maybe a few times a day.
It is aimed at indie developers and home lab people. The kind of workload it is actually built for is a background script that fires a notification when something finishes, or a Pi that picks up a task when your laptop tells it to. Not high frequency, not mission critical, just reliable enough to trust.
What I was curious about was whether SQLite would fall apart under concurrent workers. The assumption is always that it will. With WAL mode and Waitress as the WSGI server it ended up handling 40 concurrent workers at 34 jobs per second with 99% success and no lock contention at all. For something running a few hundred jobs a day that is genuinely more than it will ever need.
The actual bottleneck was not SQLite. It was the WSGI layer. Gunicorn on a single thread collapsed under concurrent polling. Switching to Waitress fixed it immediately.
The protocol is plain HTTP so workers can be written in anything. There is also a Python SDK on PyPI if anyone prefers that.
Curious if anyone has actually hit SQLite's limits in a similar setup and what pushed it over the edge.
r/sqlite • u/jrebhan • May 03 '21
Hosting SQLite databases on Github Pages - (or any static file hoster)
phiresky.github.ior/sqlite • u/SuccessfulReality315 • Sep 21 '25
Another distributed SQLite
Highly available leaderless SQLite cluster powered by embedded NATS JetStream server.
Connect using PostgreSQL wire Protocol or HTTP
r/sqlite • u/Somewhat_Sloth • Sep 29 '24
rainfrog ā a database management tui
rainfrog is a lightweight, terminal-based alternative to pgadmin/dbeaver. it features vim-like keybindings for navigation and query editing, shortcuts to preview rows/columns/indexes, and the ability to quickly traverse tables and schemas.
it originally only supported postgres, but thanks to a big contribution from Frank-III (https://github.com/Frank-III), mysql and sqlite support are in preview! they haven't been tested as extensively as postgres, so they are still considered unstable; use with caution in production environments.
bug reports and feature requests are welcome: https://github.com/achristmascarl/rainfrog
r/sqlite • u/Much-Television-9449 • Oct 02 '26
How we saved $4,000/mo by replacing Redis with SQLite for our job queue
r/sqlite • u/copilot_husky • Aug 19 '26
Reliability Lessons From SQLite - Richard Hipp | SSW 2026
All about testing