3 ms·
I think SQLite columns for SQLite would be superior to SQLite’s JSON columns whose operators are a whole ‘nother query language you need to learn and seem compa
by ecuaflo 2y ago
I think SQLite columns for SQLite would be superior to SQLite’s JSON columns whose operators are a whole ‘nother query language you need to learn and seem comparatively limited.
- maCDzP 2y agoI spent some time learning those queries for a project and when I grokked it they where very handy.
- ray_v 2y agowouldn't that just be a foreign key to another table or, a list of keys or am i missing something?
- ecuaflo 2y agoI think it’s useful when you only need to query one way and can then avoid a join each time/extra schema complexity of a join table.
- james_marks 2y agoAgreed, the JSON search queries in Postgres are esoteric, to say the least. But after spending some time with a mixed-schema table at even modest scale, I’m wondering how often a better design could have cut the whole problem off.
- xyc 2y agoWith Claude you barely had to learn the language this days as you just need to prompt, but SQLite column is an interesting idea.