3 ms·
Does anybody know how to make it work with UUID as primary keys? I got stuck on that a while back and it randomly corrupts when using rowid. Couldn't figure out
by freeqaz 2y ago
Does anybody know how to make it work with UUID as primary keys? I got stuck on that a while back and it randomly corrupts when using rowid. Couldn't figure out a solution other than migrate my schema to use a sequential integer instead.
- mischa_u 2y agoUse an UNINDEXED column, see https://www.sqlite.org/fts5.html#the_unindexed_column_option https://www.sqlite.org/fts5.html#the_unindexed_column_option