Re: [sqlite] Success stories

Thanks for sharing your experience, would you please introduce how you deal with the concurrency? Regards, Kevin. > Hello! > > I did migrate two projects from PostgreSQL (one is ~22 Gb database with very > complex reports) and now migrate oracle project (>100 Gb billing database > with

Re: [sqlite] Question of reusable rowid

Aha, AUTOINCREMENT ... Thanks a lot, Kevin > http://www.sqlite.org/autoinc.html > > Rgds, > Simon > > 2008/6/13 Kang Kai <[EMAIL PROTECTED]>: >> Hi, >> >> In an application I use the default 'rowid' column as identifier of objects >>

[sqlite] Question of reusable rowid

Hi, In an application I use the default 'rowid' column as identifier of objects stored in table. I found that if I delete the record that has the maximal rowid, the rowid will be reused when I insert a new record. This mechanism may cause mismatched data in my application because there're