On Wed, May 20, 2015 at 8:05 PM, Simon Slavin <slavins at bigfraud.org> wrote:
> Posting this not because I agree with it but because the subject has come > up here a couple of times. > > < > https://www.clever-cloud.com/blog/engineering/2015/05/20/Why-Auto-Increment-Is-A-Terrible-Idea/ > > > > "Today, I?ll talk about why we stopped using serial integers for our > primary keys, and why we?re now extensively using Universally Unique IDs > (or UUIDs) almost everywhere." > As i recall (maybe incorrectly), one of sqlite4's problems is that auto-inc is difficult with its storage model (don't remember why, just seem to remember hearing/reading that). Perhaps this approach could be a viable alternative? -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal "Freedom is sloppy. But since tyranny's the only guaranteed byproduct of those who insist on a perfect world, freedom will have to do." -- Bigby Wolf