Hacker News new | ask | show | jobs
by andrewchambers 13 days ago
It is sqlite3. Emphasis on the 3 - it already has 'editions'.
1 comments
Retr0id 13 days ago
The "3" refers to the file format (or rather, represents a breaking file format change vs 2), which the devs have committed to keep backward-compatible until 2050. https://sqlite.org/lts.html
link
andrewchambers 13 days ago
It also refers to what the binary on my PATH is called, also what the library name I need to pass to link against it.

They even had an sqlite4:

https://sqlite.org/src4/doc/trunk/www/design.wiki

link
anitil 13 days ago
Oooh I'd forgotten about that! I'm keen on the real (non-rowid) primary keys and covering indexes. I'm not sure about defaulting to decimal math, but I suppose the reasoning makes sense
link