Auto-increment IDs

[retorquere]

Is there a way to generate numeric auto-increment IDs rather than GUIDs as primary keys?

[maradotwebp]

You can write a helper function to do that.

// Initialize userTableId with the highest number not present already
let userTableId = Math.max(...(await many(userTable)).map(u => u.id + 1));
const genUserTableId = () => userTableId++;

// Now, whenever you create an entity, use `genUserTableId` to generate your ID.
await insert(userTable, { id: genUserTableId(), name: "Adrian", age: 24 });

[retorquere]

Might be faster to use Date.now() and check for existence.

[maradotwebp]

Also a solution :D (users with stricter privacy settings will cause more conflicts tho). As long as your ID is locally unique in a table, BlinkDB is fine with it.

[retorquere]

Didn't know that, but I think I'm not susceptible to it, my code runs in privileged (chrome) mode in Firefox.