Does anybody know how to make it work with UUID as primary keys? I got stuck on ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		freeqaz on Aug 9, 2024 \| parent \| context \| favorite \| on: SQLite FTS5 Extension 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 on Aug 9, 2024 [–]

Use an UNINDEXED column, see https://www.sqlite.org/fts5.html#the_unindexed_column_option

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact