sqlite truly is the sqlite of databases
November 28, 2024 at 11:09 PM
sqlite truly is the sqlite of databases
You jerks leave sqlite alone SQLite did nothing wrong
October 8, 2025 at 10:28 PM
You jerks leave sqlite alone SQLite did nothing wrong
Cited on in the SQLite docs. That's pretty cool.
August 24, 2026 at 2:57 PM
Cited on in the SQLite docs. That's pretty cool.
this data format could've been sqlite
January 12, 2026 at 6:45 PM
this data format could've been sqlite
Well, I implemented a Merkle PATRICIA Trie in SQLite.
No, not on top of SQLite. In SQLite.
WITH RECURSIVE plus WITHOUT ROWID plus a small app-defined function.
Might be time to stop.
(This is for a very cool verifiable transparency log indexing thing.)
No, not on top of SQLite. In SQLite.
WITH RECURSIVE plus WITHOUT ROWID plus a small app-defined function.
Might be time to stop.
(This is for a very cool verifiable transparency log indexing thing.)
June 5, 2025 at 10:58 PM
Well, I implemented a Merkle PATRICIA Trie in SQLite.
No, not on top of SQLite. In SQLite.
WITH RECURSIVE plus WITHOUT ROWID plus a small app-defined function.
Might be time to stop.
(This is for a very cool verifiable transparency log indexing thing.)
No, not on top of SQLite. In SQLite.
WITH RECURSIVE plus WITHOUT ROWID plus a small app-defined function.
Might be time to stop.
(This is for a very cool verifiable transparency log indexing thing.)
I saw an sqlite db doing something weird today. that's the one thing sqlite isn't supposed to do! but I guess with 40 million sqlite dbs, one of them was going to be weird eventually.
March 25, 2026 at 2:22 AM
I saw an sqlite db doing something weird today. that's the one thing sqlite isn't supposed to do! but I guess with 40 million sqlite dbs, one of them was going to be weird eventually.
Just when I thought I've seen it all, a PostgreSQL extension shows up that allows you to embed a SQLite database inside a table. github.com/frectonz/pgl...
November 19, 2024 at 2:19 PM
Just when I thought I've seen it all, a PostgreSQL extension shows up that allows you to embed a SQLite database inside a table. github.com/frectonz/pgl...
Tailscale has recently "found" two SQLite corruption bugs, now both fixed upstream in sqlite.org/releaselog/3...
The first:
sqlite.org/wal.html#wal...
The second:
sqlite.org/staleexpridx...
Fun times holding SQLite in unique ways!
SQLite folk have been a joy to work with & worth every penny.
The first:
sqlite.org/wal.html#wal...
The second:
sqlite.org/staleexpridx...
Fun times holding SQLite in unique ways!
SQLite folk have been a joy to work with & worth every penny.
SQLite Release 3.53.0 On 2026-04-09
A complete list of SQLite releases in a single page and a chronology are both also available. A detailed history of every check-in is available at SQLite version control site.
sqlite.org
April 9, 2026 at 5:34 PM
Tailscale has recently "found" two SQLite corruption bugs, now both fixed upstream in sqlite.org/releaselog/3...
The first:
sqlite.org/wal.html#wal...
The second:
sqlite.org/staleexpridx...
Fun times holding SQLite in unique ways!
SQLite folk have been a joy to work with & worth every penny.
The first:
sqlite.org/wal.html#wal...
The second:
sqlite.org/staleexpridx...
Fun times holding SQLite in unique ways!
SQLite folk have been a joy to work with & worth every penny.
Here is an insane piece of lore inside SQLite's source code
I am researching VACUUM and I was studying their code. In VACUUM, SQLite creates a temp file prefixed with `etilqs_`
Here is why:
I am researching VACUUM and I was studying their code. In VACUUM, SQLite creates a temp file prefixed with `etilqs_`
Here is why:
April 17, 2026 at 4:28 AM
Here is an insane piece of lore inside SQLite's source code
I am researching VACUUM and I was studying their code. In VACUUM, SQLite creates a temp file prefixed with `etilqs_`
Here is why:
I am researching VACUUM and I was studying their code. In VACUUM, SQLite creates a temp file prefixed with `etilqs_`
Here is why:
my proposal:
Where is data stored? sqlite
How is data organized? sqlite
What is the unit of data? sqlite
How are relations expressed? sqlite
How are datasets composed? sqlite
How are schemas defined? sqlite
Where is data stored? sqlite
How is data organized? sqlite
What is the unit of data? sqlite
How are relations expressed? sqlite
How are datasets composed? sqlite
How are schemas defined? sqlite
August 1, 2024 at 11:27 PM
my proposal:
Where is data stored? sqlite
How is data organized? sqlite
What is the unit of data? sqlite
How are relations expressed? sqlite
How are datasets composed? sqlite
How are schemas defined? sqlite
Where is data stored? sqlite
How is data organized? sqlite
What is the unit of data? sqlite
How are relations expressed? sqlite
How are datasets composed? sqlite
How are schemas defined? sqlite
Solution: sqlite
This blog post is a cautionary tale of the disaster that is trying to scale PostgreSQL beyond its limits.
I firmly expect to have someone cite it to me as an example of how PostgreSQL scales extremely well.
I firmly expect to have someone cite it to me as an example of how PostgreSQL scales extremely well.
Scaling PostgreSQL to power 800 million ChatGPT users
By Bohan Zhang, Member of the Technical Staff
openai.com
January 23, 2026 at 2:01 PM
Solution: sqlite
[expanding brain meme]
sqlite is a database
sqlite is a file format
sqlite is a table serialization format
sqlite is a database
sqlite is a file format
sqlite is a table serialization format
March 23, 2024 at 10:56 PM
[expanding brain meme]
sqlite is a database
sqlite is a file format
sqlite is a table serialization format
sqlite is a database
sqlite is a file format
sqlite is a table serialization format
I spent the last few days learning the SQLite C interface and writing a Go wrapper so I could access my database without the high-level abstractions provided by existing libraries. This isn't very pragmatic, but it gave me a reason to finally learn cgo, and how SQLite works under the hood.
November 9, 2024 at 8:26 PM
I spent the last few days learning the SQLite C interface and writing a Go wrapper so I could access my database without the high-level abstractions provided by existing libraries. This isn't very pragmatic, but it gave me a reason to finally learn cgo, and how SQLite works under the hood.
i looooooooooooooove in memory sqlite btw, retweet if you love in memory sqlite
October 20, 2025 at 1:42 AM
i looooooooooooooove in memory sqlite btw, retweet if you love in memory sqlite
Database? SQLite until proven otherwise
September 21, 2026 at 5:04 AM
Database? SQLite until proven otherwise
shoutout to SQLite . gotta be one of the best open source projects .
June 27, 2026 at 6:50 PM
shoutout to SQLite . gotta be one of the best open source projects .
me when im a normal guy with normal opinions: this zip file could have been a sqlite database. this interplanetary linked data content-addressed archive could have been a sqlite database. this crates.io git index could have been a sqlite database
May 4, 2025 at 9:32 PM
me when im a normal guy with normal opinions: this zip file could have been a sqlite database. this interplanetary linked data content-addressed archive could have been a sqlite database. this crates.io git index could have been a sqlite database
New plugin for sqlite-utils that lets you ask questions of a SQLite database (or a even against one or more CSV/TSV/JSON files) in human language and have an LLM write a SQL query for you to get the answer. simonwillison.net/2024/Nov/25/...
Ask questions of SQLite databases and CSV/JSON files in your terminal
I built a new plugin for my sqlite-utils CLI tool that lets you ask human-language questions directly of SQLite databases and CSV/JSON files on your computer. It’s called sqlite-utils-ask. Here’s …
simonwillison.net
November 25, 2024 at 1:34 AM
New plugin for sqlite-utils that lets you ask questions of a SQLite database (or a even against one or more CSV/TSV/JSON files) in human language and have an LLM write a SQL query for you to get the answer. simonwillison.net/2024/Nov/25/...
Wait... SQLite is coming to Node.js? I missed this.
December 12, 2024 at 2:20 PM
Wait... SQLite is coming to Node.js? I missed this.
days since sqlite being stringly typed has bit me: 0
February 3, 2025 at 9:27 PM
days since sqlite being stringly typed has bit me: 0
heartwarming: sqlite is probably good enough for you
I finally looked into why the For You sqlite db file has been growing to be quite large - 589GB.
To prevent the unlimited growth I regularly delete likes older than 90 days. The size of the "ratings" table should be stable (there are ~20M likeds per day).
Turns out another source of growth is...
To prevent the unlimited growth I regularly delete likes older than 90 days. The size of the "ratings" table should be stable (there are ~20M likeds per day).
Turns out another source of growth is...
August 23, 2026 at 4:55 AM
heartwarming: sqlite is probably good enough for you
so close to using SQLite in production 6 million times
June 23, 2024 at 5:02 PM
so close to using SQLite in production 6 million times
We are unflagging Node.js SQLite API soon! I've been working with it for a bit, and it's amazing!
SQLite | Node.js v23.3.0 Documentation
SQLite#
nodejs.org
November 25, 2024 at 4:59 PM
We are unflagging Node.js SQLite API soon! I've been working with it for a bit, and it's amazing!
software engineering is about two things:
- when to use sqlite
- when to use postgres
- when to use sqlite
- when to use postgres
May 5, 2026 at 3:53 PM
software engineering is about two things:
- when to use sqlite
- when to use postgres
- when to use sqlite
- when to use postgres