Re: [sqlite] bounded id

2017-03-15 Thread Clemens Ladisch
Jan Danielsson wrote: > I can't make the rowid a uint32_t, but that's essentially the > behavior I'm looking for CREATE TABLE transfers ( ID INTEGER PRIMARY KEY CHECK (ID BETWEEN 0 AND 4294967295), [...] ); But if you want the values to wrap around after old ones have been deleted, you

[sqlite] bounded id

2017-03-15 Thread Jan Danielsson
Hello, I have a wire-protocol which uses an uint32_t to identify transfers, and each of the transfers is represented by a row in a table in an sqlite database. I can't make the rowid a uint32_t, but that's essentially the behavior I'm looking for -- I'd like to be able to insert a new row