Hello, some primary key questions.
I have a requirement of needing to loosely paginate products based on insert sequence.
- If I were to hash the Primary Key, is this the correct syntax?
create table "products" ("id" int default unique_rowid(), "name" string, primary key (id) USING HASH WITH BUCKET_COUNT = 8);
- Documentation of USING HASH WITH BUCKET_COUNT warns it is an experimental feature. Is there a chance of deprecation in the near future?
- Am I better off with a UUID Primary Key + hash indexed timestamp instead? Pros/Cons?
Is there some alternative solution I’m not considering, but should? Thanks!