alt Hacker NewsNo network, no write concurrency, no types to speak of... Where those things aren't needed, sqlite is the de facto standard. It's everywhere.
Replies
BenjiWiebe • today at 3:27 PM
SQLite did add 'STRICT' tables for type enforcement.
Still doesn't have a huge variety of types though.
➕ show 1 reply
Perfect summary. I'll add: insane defaults that'll catch you unaware if you're not careful! Like foreign keys being opt-in; sure, it'll create 'em, but it won't enforce them by default!