Zend Server 5.6 is out

Kevin Schroeder writes; Zend Server 5.6 is out.  I’m actu­ally pretty stoked about this release.  Here’s a few rea­sons why.

Zend Server CE now con­tains the full Zend Server stack.  Why do I find this excit­ing?  Because the upgrade path from CE to the full ver­sion is stu­pid easy.  That means you can try out all of […]

UTF-8 fields in MySQL">About using UTF-8 fields in MySQL

Joshua Thi­jssen writes; I some­times hear: “make every­thing utf-8 in your data­base, and all will be fine”. This so-called advice could not be fur­ther from the truth. Indeed, it will take care of inter­na­tion­al­iza­tion and code-page prob­lems when you use UTF-8, but it comes with a price, which may be too high for you to […]

Akrabat_Db_Schema_Manager: table prefix support

Rob Allen posts; I’ve updated Akrabat_Db_Schema_Manager so that it now sup­ports table pre­fixes.
It uses the application.ini key of resources.db.table_prefix as I couldn’t think of a bet­ter one and then uses that for the schema_version table’s name and also makes it avail­able in your change objects.
For exam­ple, if application.ini con­tains resources.db.table_prefix = “myapp”, then […]

DDL statements, However…">MySQL does support preparing some DDL statements, However…

Bill Kar­win gives some insight into some work arounds when cre­at­ing func­tions, trig­gers and pro­ce­dures using Zend Frame­work;
MySQL does sup­port prepar­ing some DDL state­ments, even in older ver­sions. See http://dev.mysql.com/doc/refman/5.1/en/sql-syntax-prepared-statements.html
for lists of what state­ments can be pre­pared.
How­ever, some DDL state­ments are still not sup­ported as pre­pared state­ments, for exam­ple CREATE FUNCTION, CREATE […]

Migrating MySQL latin1 to utf8 – The process

Hav­ing cov­ered the prepa­ra­tion and char­ac­ter set options of per­form­ing a latin1 to utf8 MySQL migra­tion, just how do you per­form the migra­tion cor­rectly.
Com­plete story again at Migrat­ing MySQL latin1 to utf8 – The process .

MySQL :: Managing Hierarchical Data in MySQL

Mike Hillyer wrote a very good arti­cle on Man­ag­ing Hier­ar­chi­cal data in MySQL, defen­itely worth a read;
Most users at one time or another have dealt with hier­ar­chi­cal data in a SQL data­base and no doubt learned that the man­age­ment of hier­ar­chi­cal data is not what a rela­tional data­base is intended for. The tables […]

Migrating MySQL latin1 to utf8 – Character Set Options

Con­tin­u­ing on from prepa­ra­tion in our MySQL latin1 to utf8 migra­tion let us first under­stand where MySQL uses char­ac­ter sets. MySQL defines the char­ac­ter set at 4 dif­fer­ent lev­els for the struc­ture of data.
via Migrat­ing MySQL latin1 to utf8 – Char­ac­ter Set Options

Migrating MySQL latin1 to utf8 – Preparation

Before under­tak­ing such migra­tion the first step is a les­son in under­stand­ing more about how latin1 and utf8 work and inter­act in MySQL. latin1 in a com­mon and his­tor­i­cal char­ac­ter set used in MySQL. utf8 first avail­able in MySQL Ver­sion 4.1 is an encod­ing sup­port­ing mul­ti­ple bytes and is the sys­tem default in MySQL 5.0
via Migrating […]

Logging with Timestamps and Doctrine Event Listeners

Jon Leben­sold pub­lishes another screen cast on the Doc­trine topic;
This short video is going to be the last in my 2009–2010 series on Doc­trine 1.2. I’m wrap­ping it up with a lit­tle exam­ple of adding time­stamps, log­ging and using Doctrine’s event lis­tener archi­tec­ture.
Grab a copy of the project or browse the repos­i­tory.
view […]

Jayson Minard: Yes, I Crashed the Site!

Jayson Minard wrote a very good arti­cle on upgrad­ing a pro­duc­tion site and what can go wrong and what we can learn from it.
Yes­ter­day, I per­formed an upgrade to a third-party pack­age used with Zend Devel­oper Zone. It has an auto­mated schema update sys­tem which silently per­forms actions on the data­base that had a large impact […]

Getting Started with Zend_Test

Matthew Tur­land has writ­ten a very nice arti­cle on Unit Test­ing using Zend_Test, Zend_Test_PHPUnit_DatabaseTestCase, Zend_Test_PHPUnit_ControllerTestCase where he uses a few inter­est­ing solu­tions. Def­i­nitely worth a read.
“I worked on a project recently where we used Zend Frame­work. As part of that project, I was tasked with writ­ing unit tests. So, I went to the “tests” directory […]

InnoDB Performance Monitoring with innotop

Man­u­ally extract­ing rel­e­vant infor­ma­tion from repeated incan­ta­tions of SHOW ENGINE INNODB STATUS while try­ing to fig­ure out what Inn­oDB is doing is not only error prone, it’s just plain hard to do. And since MySQL doesn’t expose the data you really want in an INFORMATION_SCHEMA table (yet?), the option is use an exter­nal pro­gram to help: innotop.