Zend Framework and Doctrine

Well it’s looking like Doctrine is the heavy weight data mapping solution of the lot. Zend Framework was often criticized for having no serious Model methods. Models was just sort of where you put your nuts and bolts database code. Some folks like the structure of the Active Record model that you see in Rails . . . → Read More: Zend Framework and Doctrine

Instant Access to 5 million row CSV for MySQL

I was investigating the CSV storage engine for mysql, having never used it. I found out, much to my relief, that it’s a relatively new thing — went standard with 5.1, but certainly not in the kits of luddites like me who have to stay four or five versions back because we can’t afford downtime . . . → Read More: Instant Access to 5 million row CSV for MySQL

How to make MySQL spit out CSV’s

Don’t you hate it when you know you solved a problem three years ago but you can’t remember what the solution was? I ran into that recently. I was trying to make mysql generate a csv directly from query results. I remembered that you can do it, and I had an example of the correct . . . → Read More: How to make MySQL spit out CSV’s

MySQL InnoDB Create Table composite key problem and solution

I was getting the nitpicky error 150 when trying to create an InnoDB table with foreign keys. I had very carefully checked several times that all the key types and names matched exactly including UNSIGNED (which is what gets most people), and that I had an index on every foreign key as required by my . . . → Read More: MySQL InnoDB Create Table composite key problem and solution

Column Comments in MySQL

A while back I was lamenting that table comments in MySQL get overlooked, and did a post on it, both how to create them, how to update them, and how to view them. The fact that my table comment post remains quite popular indicates that mySQL hasn’t SEO’d their pages on it thoroughly enough, . . . → Read More: Column Comments in MySQL

How to create and maintain table comments in MySQL

How to create, see and update table comments so your database scheme is somewhat self documenting . . . → Read More: How to create and maintain table comments in MySQL

A sample text widget

Etiam pulvinar consectetur dolor sed malesuada. Ut convallis euismod dolor nec pretium. Nunc ut tristique massa.

Nam sodales mi vitae dolor ullamcorper et vulputate enim accumsan. Morbi orci magna, tincidunt vitae molestie nec, molestie at mi. Nulla nulla lorem, suscipit in posuere in, interdum non magna.