Re: Generating unique row ID ints.

2006-10-01 Thread Nick Vatamaniuc
The primary key is usually there to uniquely identify each row. There are a couple of ways to generate them: One is to always create a new integer id (sequentially or random) when you insert a new row. This means that if you insert the same data again, the row will always be duplicated. Usual

Re: Generating unique row ID ints.

2006-10-01 Thread Paul Rubin
"Simon Wittber" <[EMAIL PROTECTED]> writes: > Some of the tables require single integer primary keys which might be > exposed in some parts of the web interface. If users can guess the next > key in a sequence, it might be possible for them to 'game' or > manipulate the system in unexpected ways. I

Generating unique row ID ints.

2006-10-01 Thread Simon Wittber
I'm building a web application using sqlalchemy in my db layer. Some of the tables require single integer primary keys which might be exposed in some parts of the web interface. If users can guess the next key in a sequence, it might be possible for them to 'game' or manipulate the system in unexp