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
 16 comments - (Comments are closed)  Geek Stuff, SQL, Zend Framework  Automatic Generation, Doctrine, Integration, Models, ORM, Zend Framework 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 In a previous post I discussed the stumbling blocks and security concerns that the mysql documentation doesn’t tell you about having a mysql user create csv files on the filesystem. I ran into yet another issue. In order to do what I want with these csv’s, they have to have column headers. I thought . . . → Read More: MySQL CSV’s with column headings — Part 1 3 comments - (Comments are closed) Geek Stuff, Hacking and Security, SQL cache, CAST, column headers, column heading, CSV, Database Abstraction, dependency injection, describe table, descriptors, FILE permission, length, metadata, MySQL, pear, reflection, system user, truncate, truncation, UNION 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 22 comments - (Comments are closed) Geek Stuff, SQL CSV, DoS, escapes, FILE privilege, filesystem, INTO OUTFILE, MySQL, mysql system user, mysql user, OUTFILE, permissions, security, vulnerability 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 9 comments - (Comments are closed) Geek Stuff, SQL Can't create table, composite key, composite primary key, create table, Error 150, example, foreign key, index, InnoDB, key, key order, MySQL, reference table, references 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 14 comments - (Comments are closed) Geek Stuff, SQL access, alter table, comment, create, creating a table, database, effort, multiple, MySQL, SHOW, SQL, table, table comments, update |
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