Nobody likes to be called a dummy by a dummy.

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.. ;(
Permalink Send private email Wayne 
July 21st, 2007 5:52pm
Why should a communist work???
Permalink Rick Zeng 
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
Permalink Send private email LinuxOrBust 
July 21st, 2007 6:16pm
"Why should a communist work???"

I'm not a communist.  ;)
Permalink Send private email Wayne 
July 21st, 2007 6:20pm
+1 phpMyAdmin
Permalink Send private email Impractical Economist 
July 21st, 2007 6:23pm
Ooo..  I just fixed a bug in phpMyAdmin!
Permalink Send private email Wayne 
July 21st, 2007 6:59pm
what?
Permalink gdf 
July 21st, 2007 7:11pm
hurray for the OP!
Permalink php curious 
July 21st, 2007 7:54pm
open source software rocks. it has bugs we can fix and feel good about.
Permalink strawdog soubriquet 
July 21st, 2007 7:58pm
>> Why should a communist work???

Err, because that's a fundamental principle of communism?
Permalink Send private email Mongo 
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?
Permalink Send private email JoC 
July 23rd, 2007 11:14am

This topic is archived. No further replies will be accepted.

Other topics: July, 2007 Other topics: July, 2007 Recent topics Recent topics