wilsonehusin

OP here, yeah it’s definitely not specific to SQLite. However, I personally don’t find it intuitive to “create database” for short-lived CLI apps because it sounds weird to have such “heavy” dependency — but this experience made me realize SQLite isn’t “heavy” at all and should probably be considered more often!

OP here — that's interesting, thank you for sharing! I use http://modernc.org/sqlite for easier static compilation and haven't observed unexpected behaviors, but will keep that in mind!

I agree with the key-value store too — there are some instances where I wish for a columnar database, but settling to use SQLite with key-value store ended up pretty okay.