Tag Archives: mysql

MySQL Replication for Offsite Backups

I'm cheap. I tend to run pet projects on shoe string budgets. For one, it's just a good habit. It's easier to increase spending when it's really necessary (after some growth and revenue) than it is to turn off a … Continue reading

Posted in Development | Tagged , , | Leave a comment

Dirty Rows and Audit Trails with Zend_Db_Table

There are various ways to update rows in a database table using the Zend_Db_Table components. You can use use Zend_Db_Table::update(), like so: $table = My_Table(); $table->update(array('age' => 22), 'id = 1'); or retrieve the row, and update it: $table = … Continue reading

Posted in Database, Development, PHP, Zend Framework | Tagged , , , , , , , , , , | 1 Comment

Zend_Db: Setting MySQL's timezone per connection

I have a Linux server with a system timezone of ET (US/Eastern). But I also have a web application that needs to run in a timezone of PT (US/Pacific). Of course that's not a problem at all. I just set … Continue reading

Posted in Development, PHP, Zend Framework | Tagged , , , , , , , | Leave a comment

Zend_DB_Select Woes

It's no secret, I'm a fan of the Zend Framework, which I've been using since version 0.15. A lot of components have been added since then, and many of the initial components have been refactored and enhanced, and have matured. … Continue reading

Posted in Database, Development, PHP, Zend Framework | Tagged , , , , , , , , | Leave a comment

Modified DBDesigner

Earlier today I modified DBDesigner to, above all, not delete columns automatically after renaming the destination column in a relationship. It also displays "AI" for auto_increment columns, so I don't have to guess anymore whether I forgot to check that … Continue reading

Posted in Software & Tools | Tagged , | Leave a comment