| ▲ | AlexErrant 6 days ago | |
I 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. | ||
| ▲ | 5 days ago | parent | next [-] | |
| [deleted] | ||
| ▲ | garaetjjte 5 days ago | parent | prev | next [-] | |
I would want that too. It's possible in MySQL: https://dev.mysql.com/doc/refman/8.4/en/create-index.html#cr... | ||
| ▲ | MyOutfitIsVague 5 days ago | parent | prev | next [-] | |
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 5 days ago | parent | prev [-] | |
You can use triggers to keep the tag table synchronized automatically. | ||