Re: [Phpwebsite-developers] PEAR DB and auto_increment

[Bob T <bo...@el...>]

-1 on this 

I think a sequence number, when used as an ID, should be called only once, and then thrown away even if it is not used.

It may not be a huge coding problem, but it could lead to a huge error, if someones private data was exposed to someone else.  Why take the risk?  If you have grabbed a number and then released it, why return it?  It costs nothing.  There are lots of numbers.  What about if the number 6 is returned and the high number is already 15?  Will the sequence function find 6 and use it again?   It would be lots of overhead to find the blank spots, and for what reason?  

Re:
"For example, if we add 1, 2, and 3 and then 3 is deleted, auto_increment
will add 4. Our new functionality will add 3 instead (it doesn't keep
track of that stuff). Possible problem? Only if a module developer did not remove all linked material. In other words, a module could have 3 as a linked id because it did not know it was deleted. So it would pull 3's data. Not a huge problem, but one we would have to be wary of while
programming.