Re: [sqlite] Indexing multiple values per row

> On Mar 15, 2018, at 11:27 AM, Jay Kreibich wrote: > > Recognize the fact that if you’re storing data in a JSON string, to the > database that is just one single value: a string. I am very well aware of that. What _I_ (and my co-workers) are implementing is a higher-level

Re: [sqlite] Indexing multiple values per row

> On Mar 15, 2018, at 12:33 PM, Jens Alfke wrote: > > I'm wondering what the best way is to efficiently search for data values that > can appear multiple times in a table row. SQLite indexes, even expression > indexes, don't directly work for this because they obviously

[sqlite] Indexing multiple values per row

I'm wondering what the best way is to efficiently search for data values that can appear multiple times in a table row. SQLite indexes, even expression indexes, don't directly work for this because they obviously only index one value per row. Traditional relational-database design says to