Database Mongo Performance

Excluding fields in the mongodb/mongodb library

I am using the mongodb/mongodb library for a project of mine.  The API seems fairly different from the old PECL library and it also came with some other, albeit unexpected, baggage. My understanding of the library is that it is intended to be a replacement for the existing PECL library and that it intends to strike aContinue Reading “Excluding fields in the mongodb/mongodb library”

Database

The server requested authentication method unknown to the client [mysql_old_password]

I updated my server this morning, moving from Zend Server PHP 5.3 to 5.6 but when I did I got a really weird error. The server requested authentication method unknown to the client [mysql_old_password] I spent way too much time debugging it but it turns out that this is an incompatibility between MySQLnd and MySQLContinue Reading “The server requested authentication method unknown to the client [mysql_old_password]”

Database Security

How to use PHP with MySQL (without SQL Injection vulnerabilities)

Chris Dale recently posted a horrifying article on his blog.  It is called “Why it’s easy being a hacker – A SQL injection case study“.  The most horrifying part of the post was that when you type in the Google search “How to use PHP with MySQL” a significant number of the results come backContinue Reading “How to use PHP with MySQL (without SQL Injection vulnerabilities)”