-
Archives
- September 2010
- August 2010
- June 2010
- May 2010
- March 2010
- February 2010
- January 2010
- December 2009
- October 2009
- August 2009
- July 2009
- May 2009
- April 2009
- March 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- April 2008
- February 2008
- December 2007
- August 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- March 2006
- January 2006
- December 2005
- November 2005
- October 2005
- September 2005
- June 2005
- March 2005
- February 2005
- December 2004
- November 2004
- September 2004
- August 2004
- July 2004
- March 2004
- August 2002
- July 2002
- June 2002
- May 2002
-
Meta
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
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
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 date, dates, db, framework, mysql, PHP, timezone, zend
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 mixin, mysql, PHP, select, sql, sqlite, tables, zend framework, zf
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