Comment by ecuaflo
2 days 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.
2 days 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.
Agreed, 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.
I spent some time learning those queries for a project and when I grokked it they where very handy.
With Claude you barely had to learn the language this days as you just need to prompt, but SQLite column is an interesting idea.
wouldn't that just be a foreign key to another table or, a list of keys or am i missing something?
I 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.