maevsi / sqitch

maevsi's database migrations.
https://maev.si
1 stars 3 forks source link

feat(sql): evaluate uuids instead of ids #14

Closed dargmuesli closed 1 year ago

dargmuesli commented 1 year ago

UUIDs prevent the viability of guessing attacks while they might introduce slightly lower performance. It is to be checked if using uuids only, e.g. for the upload table, results in urql caching problems (deleting an upload does not remove it from its graph cache).

See https://formidable.com/open-source/urql/docs/graphcache/normalized-caching/#custom-keys-and-non-keyable-entities