On 3/16/18, Jens Alfke <[email protected]> wrote: > Yes, the solution involves creating a table as you described, but the table > is derived from and dependent on the original JSON data, and needs to be > kept up to date as that data changes. Triggers are the best way I know of to > do that, but I'm open to other ideas.
Perhaps use FTS4 or FTS5 with a custom tokenizer that understands JSON? -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
