News for hackers. Stuff that matters.
Re:How I Fired Myself by mbell on Wednesday February 27, 2013 @01:38PM (#5293993)
I'll add another one:

* No Foreign Keys

Attempting to clear the table should have just thrown a constraint violation error.

Re:How I Fired Myself by eloisant on Thursday February 28, 2013 @04:28AM (#5297893)
Well, depending how you configure your cascade clearing the user table could have cleared all the other tables also :)

"on delete cascade"!

Re:How I Fired Myself by mbell on Thursday February 28, 2013 @11:29AM (#5299378)
True on MySql with InnoDB, wouldn't be true with postgres.

You'd have to use TRUNCATE CASCADE on postgres to avoid the foreign key error.

Re:How I Fired Myself by jasonswett on Wednesday February 27, 2013 @04:57PM (#5295244)
Exactly!!!!