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

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

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

Posted in Database | 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