If you use PEAR::MDB2, you can set a custom debug handler and collect all the queries you execute for debugging and performance tunning purposes, as shown before. But what if you’re using PEAR::DB? Well, since PEAR::DB doesn’t allow you such a functionality out of the box, you can hack it a bit to get similar […]

Through a trackback I found out that Walter Cruz has translated my DB-2-MDB2 article in a language I was led to believe is Brazilian Portuguese. the announcement the article Thanks very much Walter, this is very flattering! Thanks to my buddy Isidoro who enlightened me that the language was Portugeese!

This is a follow up to a question posted by Sam in my DB-2-MDB2 post. The question was if you can reuse an exisitng database connection you’ve already established and not have MDB2 creating a second connection.

This is a follow-up to Lars’ comment about the PEAR book. In the MDB2 chapter I showed an example how you can create custom debug handlers in MDB2 and then gave a suggestion about a useful application of this functionality for performance tuning. Basically the idea is that your custom debug handler collects all queries […]

Recently I had to move an existing project from using PEAR::DB to PEAR::MDB2 – the new database abstraction layer. I took notes on the parts of the code I needed to change, I hope they can benefit someone who’s doing the same.