2 ms·
Hard to make it visible to others. Can't use standard VCS/diff/etc., so you don't get history unless you store it manually. Limited and cumbersome types, e.g. y
by lmm 2y ago
Hard to make it visible to others. Can't use standard VCS/diff/etc., so you don't get history unless you store it manually. Limited and cumbersome types, e.g. you can't use sets in a natural way (I think sqlite may now have some sort of support for JSON columns but they're clunky).
- yawpitch 2y agoFair enough if it’s not your tool of choice, but I think you may have missed a lot of what SQLite can do these days. https://antonz.org/sqlite-is-not-a-toy-database/ https://antonz.org/sqlite-is-not-a-toy-database/
- lmm 2y agoI don't think any of that contradicts anything I said?
- yawpitch 2y agoYou can import and export CSV, JSON, etc (including parquet via an extension) which gets you VCS diffs for history. Set operations are built in (though I admit they may be as “natural” as you like), and there’s been decent (though, again, your idea of cumbersome may be different than mine) JSON blob support for some time. It’s a tool that consistently gets underestimated at the same time it’s also consistently improving.