Tag: sql
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. And that includes the Zend_Db_Select component, which has been evolving quite nicely, and even Zend_Db_Table_Abstract […]
Posted: July 25th, 2008 under Database, Development, PHP, Zend Framework.
Tags: mixin, mysql, PHP, select, sql, sqlite, tables, zend framework, zf
Comments: none
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 sensitive by default.
In PostgreSQL everything is case sensitive. That means that if you have a […]
Posted: November 2nd, 2005 under Database.
Tags: Database, index, postgresql, sql
Comments: none