2008
01.29

My MySQL project

Finally got around to creating a project on Sourceforge: MyHelper. Right now, it’s just some stored procedures and functions for determining data and index sizes for databases using the MyISAM and InnoDB engines. Each one is individually licensed (using the BSD license.) I have 2 more stored procedures to add (return a list of tables with no primary key and a list of tables with the primary key) but I haven’t committed my changes to Subversion yet because I’m still testing them. I’ll be adding more code as I refine the stuff I’ve written over the years (their current state is highly environment-specific so I need to “genericise” them – if that’s a word.)
A word about licensing. I’m opting to license each script/procedure/function individually. This is because the project, as a whole, is made up of individual pieces that may or may not have a dependency on each other and the project is not a “software package” that you install and use. Each script, stored procedure or function may stand on its own and you have the option to use what you want. It’s an ala carte repository of stuff. Use what you want, leave behind what you don’t need. Putting a license on the whole package didn’t make sense given this distribution model so each has its own license.

So, if you develop with MySQL or manage MySQL databases, check ‘em out and let me know what you think.

  1. [...] segnalo: l’uscita di Hyperic 3.2; i 230 aggiornamenti di PostBooks 2.3; il lancio di MyHelper, un interessante strumento che aiuta nella gestione di MySQL; in ultimi un articolo sui tool che [...]

  2. The code I wrote that you’d like to add to MyHelper was written on company time, blogged about on my company blog, and thus http://www.pythian.com owns the code. Please make it clear that the work is provided by The Pythian Group, and a link to the website would be nice.