[sqlite] non-integer rowid/document id

Hi all, I'm working with FTS5 and I'd like to guarantee that a particular document is indexed only once. I have what I consider to be a document id, but it is not an integer value its a hexadecimal string, think GUID/md5/sha1. Since the fts5 rowid column is an integer, it appears I'll need to

[sqlite] JSON1 detecting if a path exists vs. json null value

On December 9, 2015 at 13:05:37 PM, Richard Hipp (drh at sqlite.org) wrote: >? > Also are there optimizations in place so that a column that is a json string? > is only? > parsed once if it is involved in json1 functions? For example:? >? No. The JSON parsing turned out to be so fast that such

[sqlite] JSON1 detecting if a path exists vs. json null value

Hi, I?m experimenting with the json1 extension, and I?d like to confirm the proper way to detect if a key exists in the json, vs its value being null. For example: ? sqlite> select json_extract('{"a":2,"c":[4,5,{"f":7}]}', '$.x'); ? sqlite> select json_extract('{"a":2,"c":[4,5,{"f":7}]}',