Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

Actually even senior developers or architects make mistakes. Philosophy grad or not, it doesn't matter. That's to be expected.

What's more questionable is:

* Developers have access to the production database from their machine, while it should only be accessible to the front machines within the datacenter.

* Junior developers don't need an access to production machine, only sysops and maybe the technical PM.

* No backup of the production database. WTF???

If they had a hardware failure they would have been in the same shit.



I'll add another one:

* No Foreign Keys

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


Well, depending how you configure your cascade clearing the user table could have cleared all the other tables also :)

"on delete cascade"!


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.


Exactly!!!!


It's a nice theory, but not everybody has that much staff. You can get by with proper backups and running against local copies of production.


Constrains also act like bug protections. If you screw up your database tells you right away, and not a beta tester much later.


You're preaching to the choir. :)




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: