Re: FN-FORUM: What's the best development platform for creating Web 2.0 business applications?

date posted 21st November 2007 14:21

Quoting Dom Latter [EMAIL REMOVED]

>> This is really where I came in. Not all of my tables have a single ID
>> field, and I prefer not to use autonumber fields.
>
> Why on earth not?
>
> I tend to stick an auto-increment ID and a timestamp on *everything* - useful
> for debugging.

I agree - well, I always use an auto_increment ID column. I tend
not to use auto-timestamps, because I found I had a lot of issues with
them auto-updating every time something was done to that row - I use a
date/time field for things like when a row has been created or
"deleted" (Where possible, a "deletion" in my databases means that a
flag is set to say "deleted", rather than removing the row itself -
it's saved a whole heap of data a couple of times now)

Alex
http://www.ozbon.com