Why open source software rocks...
I use phpMyAdmin to do all my database work. One of it's features is that for every operation it gives you the SQL statement. When I'm making changes to the database during development, I save up these SQL statements in a file to I can repeat them on the live server during deployment.
One thing that isn't repeatable/scriptable is working with the foreign key constraints. phpMyAdmin doesn't give the constraints a name so they are dynamically generated by the server. That's no good if you want to script drops/changes to them. I just took 10 minutes to modify phpMyAdmin so it gives the constraints a consistent name.
It's going to save me tons of deployment time (I've been doing the constraint changes manually).
And, yes, I'm working on a Saturday.. ;(
July 21st, 2007 5:52pm
Why should a communist work???
July 21st, 2007 6:15pm
Sounds like something I would do. ;-)
I don't think it's so much FOSS SW sucks as much as we programmers want to kick the DBA out of the way and do everything ourselves. We are programmers, not para-IT/business hacks. ;-D
"Why should a communist work???"
I'm not a communist. ;)
July 21st, 2007 6:20pm
July 21st, 2007 6:23pm
Ooo.. I just fixed a bug in phpMyAdmin!
July 21st, 2007 6:59pm
July 21st, 2007 7:11pm
hurray for the OP!
July 21st, 2007 7:54pm
open source software rocks. it has bugs we can fix and feel good about.
July 21st, 2007 7:58pm
>> Why should a communist work???
Err, because that's a fundamental principle of communism?
July 22nd, 2007 12:12am
So let me get this straight... oss rocks because you modified phpmyadmin to do something MSSQL does out of the box?
July 23rd, 2007 11:14am