Tag Archive

AIR Ajax Bootstrap Cloud CSS Doctrine Documentation Dojo JQuery JSON Migration Models MySQL Namespacing PHP phpUnit plugin poedit Proposal REST Security sqllite Tool Tutorial UTF-8 webservice Windows WSDL xml ZendAMF Zend Framework Zend_Acl Zend_Amf_Server Zend_Auth Zend_Db Zend_Form Zend_Form_Decorators Zend_Locale Zend_Mail Zend_Registry Zend_Session Zend_Test Zend_Tool Zend_Translate Zend_View

Akrabat_Db_Schema_Manager: table prefix support

Published on 20 June, 2010 By Danny Froberg

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…

Published on 10 May, 2010 By Danny Froberg

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

Published on 8 March, 2010 By Danny Froberg
This entry is part 3 of 4 in the series Migrat­ing MySQL latin1 to utf8

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

Published on 4 March, 2010 By Danny Froberg

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 of a […]

Migrating MySQL latin1 to utf8 – Character Set Options

Published on 3 March, 2010 By Danny Froberg
This entry is part 2 of 4 in the series Migrat­ing MySQL latin1 to utf8

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

Published on 3 March, 2010 By Danny Froberg
This entry is part 1 of 4 in the series Migrat­ing MySQL latin1 to utf8

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 […]

Logging with Timestamps and Doctrine Event Listeners

Published on 17 February, 2010 By Danny Froberg

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 screencast; […]

Jayson Minard: Yes, I Crashed the Site!

Published on 12 February, 2010 By Danny Froberg

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 […]

Getting Started with Zend_Test

Published on 14 January, 2010 By Danny Froberg

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

Published on 13 December, 2009 By Danny Froberg

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.

Get Adobe Flash playerPlugin by wpburn.com wordpress themes