SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s(phiresky.github.io)

152 points by Maksadbek 3 years ago | 57 comments

Embedding Lua in Sqleibniz with Rust(xnacly.me)

52 points by xnacly 1 year ago | 2 comments

Hosting SQLite Databases on GitHub Pages (2021)(phiresky.github.io)

52 points by WA9ACE 1 year ago | 15 comments

Prefer strict tables in SQLite(evanhahn.com)

313 points by ingve 3 months ago | 160 comments

Safe relational database queries using the Rust type system(blog.lucasholten.com)

264 points by lukastyrychtr 1 year ago | 145 comments

Python: Just Write SQL(joaodlf.com)

192 points by joaodlf 3 years ago | 228 comments

SQLiteStudio: Create, edit, browse SQLite databases(sqlitestudio.pl)

540 points by thunderbong 1 year ago | 104 comments

Homepage of SQLiteStudio, a free desktop application for creating, editing, and browsing SQLite databases, announcing the 3.4.6 hotfix release.

SQLite is all you need for durable workflows(obeli.sk)

664 points by tomasol 5 months ago | 365 comments

Obelisk blog post arguing that SQLite, backed up to S3, is sufficient for many durable workflow systems, responding to DBOS's Postgres argument.

Executable Is a SQLite Database(fzakaria.com)

479 points by setheron 2 months ago | 90 comments

Blog post by Farid Zakaria on replacing the ELF executable format with SQLite databases, and how the idea pairs with Nix.

SQLite JSON at full index speed using generated columns(dbpro.app)

334 points by upmostly 10 months ago | 102 comments

A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.

SQLite Is a Library of Congress Recommended Storage Format(sqlite.org)

577 points by whatisabcdefgh 5 months ago | 177 comments

SQLite documentation page explaining that SQLite is a US Library of Congress Recommended Storage Format for datasets, alongside XML, JSON, and CSV.

Sqlite3 WebAssembly(sqlite.org)

603 points by whatever3 2 years ago | 178 comments

Documentation index for SQLite's official WebAssembly and JavaScript APIs, enabling sqlite3 use in WASM-capable browsers, in beta since version 3.40.