Archive for the 'Database' Category

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 […]

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 […]