#sqlite

Free and open source database client built natively for developers - TableProApp/TablePro

Query your SQLite database any time, anywhere

Understanding query planner quirks yielded a ~35% speedup.

Convergent, Replicated SQLite. Multi-writer and CRDT support for SQLite - vlcn-io/cr-sqlite

Around a month ago, Frontpage.fyi migrated away from Vercel Postgres aka Neon Serverless Postgres to Turso. Since then, we have read almost 7 million rows of data and written a little over 3000.

Redis re-implemented with SQLite. Contribute to nalgeon/redka development by creating an account on GitHub.

Introduction If you are relying on SQLite as your production database, then it makes sense to have some sort of a backup strategy. Those backups would come handy in a multitude of situations. For example, if you face a catastrophic hardware failure and lose all the data on your server. Or if you face a…

CLI for SQLite Databases with auto-completion and syntax highlighting - dbcli/litecli

LibSQL Studio is a fully-featured, lightweight GUI client for managing SQLite-based databases like Turso, LibSQL, and rqlite. It runs entirely in your browser, so there's no need to download anything

What you need to know before putting SQLite in production

UUID primary keys are ok with SQLite because they use the secret rowid as the key for clustering the table

Lots of database management tools include some kind of schema diagram view, either automatically generated or manually editable so you can get the layout just right. But it's usually part of a much bigger suite of tools, and sometimes I don't want to install a tool, I just want to get a basic overview quickly.