- Added numCols() function to the DB_result object
- Added seek() method to the DB_result object
- Enabled you to specify the fetchmode for getRow() and getAll()
- Made the test script easier to navigate
- Added reset() method to the DB_result object
Richard Heyes' Blog:
PEARDB replacement class updated
June 20, 2007 @ 08:43:00
Richard Heyes' Blog:
PEARDB database class(es) replacement
June 06, 2007 @ 12:39:00
In a new post Richard Heyes links to a replacement for the popular PEAR::DB package:
PEAR::DB is all well and good if you want to connect to multiple databases (I assume, I've never actually used it with anything other than mysql) but it is somewhat hefty on the bad side of 60k. Not a good thing if you're not using some sort of accelerator and have a high traffic site. Here's a class which replicates the PEAR::DB API (the bits that I use anyhoo) and weighs in at a much nicer ~11k. Sweet.
Stoyan Stefanov's Blog:
Performance tunning with PEARDB
January 17, 2007 @ 09:35:00
Stoyan Stefanov has posted some of his tips to his blog today. Specifically, they deal with the PEAR::DB class, demonstrating some of the optimization of the package he's discovered in his coding experience.
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 results.
He creates a simple app to help with the illustration - a number of select queries to grab zipcode information from the database. As it stands, the PEAR::DB package doesn't handle the debugging well, so he adds in a few more lines to buffer the connection and some reporting code to check the resulting output (as well as some of his sample reports).
Jacques Marneweck's Blog:
PEARDB alike wrapper for PEARMDB2
January 08, 2007 @ 09:02:00
Users of the PEAR::DB module now have another easy choice for upgrading their code to work with another database package - MDB2. According to this post from Jacques Marneweck, there's a wrapper Lukas Smith created to help ease the transition.
The wrapper functionality has been included in the MDB2 package for a while now, and is designed to make things simple when switching from one package to another (as seamless as possible).
You can download the latest version of MDB2 from its page on the PEAR site.
Don't see your event here?
Let us know!
phpfig series framework conference api language laravel symfony2 community database component configure example phpunit install introduction podcast application release composer
|All content copyright, 2013 PHPDeveloper.org :: firstname.lastname@example.org - Powered by the Solar PHP Framework|