-
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: Database
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
Indexes in PostgreSQL
One thing that most people don't have to worry about in MySQL is case-sensitivity. Unless you're trying to authenticate a user against a database password and don't use MD5 (like you should!), in which case the password is not case … Continue reading
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