63 stories tagged sqlite, newest first.
365 points by otoolep | 62 comments
Philip O'Toole's blog post recounting the history of distributed SQLite since he launched rqlite in 2014, covering dqlite, Litestream, LiteFS, libSQL/Turso, cr-sqlite and Cloudflare D1.
4 points by SAUMS | 0 comments
GitHub repository for sqlthon, a simple Python package providing a lightweight layer for SQLite3 operations.
81 points by tosh | 17 comments
GitHub repository for APSW, Another Python SQLite Wrapper, a C extension providing a thin Python interface to the SQLite database library.
27 points by thomask1995 | 20 comments
GitHub repository for Durable Actors, an MIT-licensed open-source TypeScript alternative to Cloudflare Durable Objects with per-actor SQLite and configurable compute.
171 points by cvburgess | 89 comments
Supabase blog post by CEO Paul Copplestone announcing the company is acquiring Turso to evolve database infrastructure for AI agents creating many databases.
352 points by bashtian | 150 comments
Landing page for Capsule, a desktop app that packages HTML apps, assets, and user data into a single portable SQLite-based .capsule file.
479 points by setheron | 90 comments
Blog post by Farid Zakaria on replacing the ELF executable format with SQLite databases, and how the idea pairs with Nix.
1128 points by ropbear | 215 comments
Tailscale blog post describing how the team tracked down a 16-year-old SQLite bug related to write-ahead log (WAL) resets.
690 points by ymir_e | 342 comments
JFrog Security Research blog post examining whether recently published critical SQLite CVEs are real vulnerabilities or LLM-generated slop reports.
339 points by gnyeki | 154 comments
Blog post arguing SQLite has bad defaults, such as ignoring foreign key constraints, and should adopt Rust-style editions to fix them without breaking compatibility.
454 points by vantareed | 249 comments
GitHub issue on openai/codex reporting that Codex CLI's SQLite feedback logs can write about 640 TB per year, rapidly wearing out SSDs.
664 points by tomasol | 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.
318 points by tjek | 232 comments
Turso blog post announcing the retirement of its $1,000 bug bounty program for data-corruption bugs, citing effects of AI.
577 points by whatisabcdefgh | 177 comments
SQLite documentation page explaining that SQLite is a US Library of Congress Recommended Storage Format for datasets, alongside XML, JSON, and CSV.
465 points by vidluther | 253 comments
Show HN post for Pardonned.com, an open-source searchable database of US presidential pardons scraped from the DOJ website and built with SQLite and Astro.
867 points by brilee | 274 comments
Lalit Maganti's essay on building syntaqlite, a set of SQLite devtools, over three months with AI coding agents, covering where AI helped and where it hurt.
612 points by cpcloud | 193 comments
Landing page for micasa, an open-source Go terminal UI for tracking home maintenance, projects, and documents in a single SQLite file.
459 points by pmaze | 137 comments
A site showing thematic "trails" of linked excerpts across 100 non-fiction books, automatically discovered by Claude Code.
341 points by alexpadula | 407 comments
SQLite documentation page explaining why SQLite is implemented in C and why there are no plans to rewrite it in another language.
667 points by keepamovin | 201 comments
Hacker Book, a browser-based offline archive of Hacker News (2006–2025) served as sharded SQLite files queried via WebAssembly.
334 points by upmostly | 102 comments
A DB Pro blog post explaining how to index JSON data in SQLite using virtual generated columns for fast queries.
333 points by emschwartz | 80 comments
Fly.io blog post introducing Litestream VFS, a SQLite virtual filesystem feature for Litestream replication.
344 points by speckx | 124 comments
Blog post by Anders Murphy benchmarking SQLite at 100k transactions per second over a billion rows, arguing its embedded single-writer design helps it scale.
588 points by modinfo | 172 comments
Homepage of PocketBase, an open-source single-file backend offering a realtime database, authentication, file storage, and an admin dashboard.
398 points by samrolken | 283 comments
GitHub repository for nokode, an experimental web app where every HTTP request is handled directly by an LLM using database, response, and memory tools instead of code.
339 points by HunOL | 155 comments
A Jellyfin server team blog post explaining SQLite concurrency limitations and how Jellyfin addresses database locking issues.
436 points by sqliteonline | 136 comments
SQLite Online is a browser-based SQL editor for running queries against SQLite, DuckDB, PGLite, and server databases like MariaDB, PostgreSQL, and MS SQL.
392 points by emschwartz | 174 comments
Fly.io blog post announcing the release of Litestream v0.5.0, the SQLite streaming replication tool.
648 points by __bb | 166 comments
Product page for Base, a native macOS SQLite database editor with schema inspection, table altering, and database attaching features.
417 points by indiehackerman | 107 comments
Engineering.fyi is a search engine indexing engineering blogs from companies like Google, Meta, Stripe and OpenAI; the capture shows a Cloudflare verification page.
785 points by dvektor | 491 comments
Turso blog post by Preston Thorpe describing how he came to work on database software while incarcerated, part 2 of his story.
413 points by usrme | 87 comments
Fly.io blog post announcing a revamped version of Litestream, the SQLite streaming replication and backup tool.
437 points by ingve | 169 comments
Blog post by Alex Chan describing a faster method to copy large SQLite databases from remote servers to a local machine than plain rsync.
722 points by stevekrouse | 159 comments
Geoffrey Litt's blog post describing Stevens, a family AI assistant built with one SQLite memories table and cron jobs hosted on Val.town.
607 points by neilk | 110 comments
Carl Sverre's blog post launching Graft, an open-source transactional storage engine for lazy, partial replication with strong consistency backed by object storage.
332 points by PaulHoule | 151 comments
A Rivet blog post by CTO Nathan Flurry arguing that SQLite-on-the-server suits hyper-scale sharded databases better than small-scale apps.
450 points by avinassh | 85 comments
Blog post summarizing the paper "SQLite: Past, Present, and Future" and explaining how Bloom filters made SQLite analytical queries 10x faster.
336 points by avinassh | 140 comments
Blog post with notes on the paper "Serverless Runtime / Database Co-Design With Asynchronous I/O", the research behind Limbo, a Rust rewrite of SQLite.
380 points by yarapavan | 109 comments
Blog post by Matt Blewitt recommending seven database technologies to study for a week each in 2025, including Postgres, SQLite, DuckDB, ClickHouse, and others.
540 points by thunderbong | 104 comments
Homepage of SQLiteStudio, a free desktop application for creating, editing, and browsing SQLite databases, announcing the 3.4.6 hotfix release.
603 points by whatever3 | 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.
328 points by thecodemonkey | 111 comments
Wafris blog post explaining why its open-source Rails web application firewall client moved from a Redis datastore to SQLite, with benchmark charts.
374 points by yla92 | 127 comments
SQLite documentation page explaining that reading and writing small blobs in SQLite is about 35% faster and uses less disk space than individual files.
323 points by punnerud | 54 comments
Homepage of DB Browser for SQLite, an open source visual tool for creating, searching, and editing SQLite database files on Windows, macOS, and Linux.
590 points by memset | 140 comments
GitHub repository for SmoothMQ, an open source Go single-binary, SQLite-backed, API-compatible drop-in replacement for Amazon SQS.
468 points by tempodox | 80 comments
GitLab repository for sqlite-schema-diagram, a tool that generates diagrams of SQLite database schemas, licensed under GNU AGPLv3.
694 points by Anon84 | 130 comments
Greg Wilson's "SQL for the Weary" lesson notes with working examples for instructors teaching SQL to data scientists in about 100 queries.
407 points by finallyy | 87 comments
SQLite branch documentation describing wal2 journal mode, how to enable it, and its advantage over legacy WAL mode for checkpointing.
512 points by dgudkov | 118 comments
Homepage of PocketBase, an open-source single-file backend offering a realtime database, authentication, file storage, and an admin dashboard.
579 points by nalgeon | 181 comments
SQLite forum post by Richard Hipp announcing JSONB, a binary rewrite of SQLite's JSON functions that landed on trunk and can be several times faster.
523 points by thunderbong | 265 comments
Blog post by Carl Sverre arguing that frontend apps end up reimplementing database features like caches and indexes, and proposing a frontend-optimized database stack.
324 points by matharmin | 94 comments
Landing page for PowerSync, a bi-directional Postgres-to-SQLite sync engine enabling offline-first, real-time reactive apps.
562 points by samwillis | 161 comments
Homepage of ElectricSQL, an open-source sync layer for building reactive, realtime, local-first apps on Postgres with active-active sync to SQLite.
404 points by weeber | 236 comments
SQLite essay presenting a thought experiment on how the OpenDocument Presentation format could benefit from being built on SQLite instead of ZIP archives.
951 points by qsantos | 249 comments
A csvbase blog post showing how to fetch and analyze the European Central Bank's exchange-rate zipfile using curl, sqlite, pandas and gnuplot.
653 points by vincelt | 309 comments
A page showing raw answers from about 60 LLMs to 20 prompts testing reasoning, instruction following, and creativity, browsable by prompt or model.
326 points by spanspan | 64 comments
GitHub repository for learndb-py, a SQLite-like relational database written from scratch in pure Python to teach database internals.
323 points by clessg | 62 comments
GitHub repository for SQLedge, a tool that replicates a Postgres database to SQLite instances running on the edge.
414 points by nalgeon | 125 comments
Documentation for Cloud Backed SQLite, a system for storing and accessing SQLite databases in cloud blob storage such as Azure and Google Cloud.
339 points by bsmith89 | 124 comments
SQLite source file os.h on a GitHub mirror, highlighting a comment explaining why temporary files were renamed with the 'etilqs_' prefix in 2006.
405 points by xavdid | 341 comments
Blog post by David Brownman introducing a tool to build a searchable SQLite archive of your Reddit data ahead of Reddit's June 2023 API changes.
480 points by notjoemartinez | 144 comments
GitHub repository for yt-fts, a Python command-line tool that scrapes a YouTube channel's subtitles into SQLite for full-text search with timestamped links.
471 points by thunderbong | 171 comments
GitHub repository for Atuin, a Rust tool that replaces shell history with a SQLite database and offers optional encrypted sync across machines.