alt Hacker NewsI was looking for a way to index a JSON column that contains a JSON array, like a list of tags. AFAIK this method won't work for that; you'll either need to use FTS or a separate "tag" table that you index.
Replies
MyOutfitIsVague • last Friday at 5:33 PM
Yeah, SQLite doesn't have any true array datatype. I think you could probably do it with a virtual table, but that would be adding a native extension, and it would have to pack its own index.
rini17 • last Friday at 5:22 PM
You can use triggers to keep the tag table synchronized automatically.
I would want that too. It's possible in MySQL: https://dev.mysql.com/doc/refman/8.4/en/create-index.html#cr...