News Feed
Sections




News Archive
feed this:

Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Richard Heyes' Blog:
PEARDB replacement class updated
June 20, 2007 @ 08:43:00

Richard Heyes has made some updates to his PEAR::DB replacement class today, including:

  • 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

You can find out more about the project here or just download this new version and check out the documentation to get you started.

1 comment voice your opinion now!
peardb class replacement pear database abstraction peardb class replacement pear database abstraction


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.

The class is posted for download here as a simple PHP source file with functions and values named similar to those in the PEAR::DB package.

0 comments voice your opinion now!
peardb package library replacement mysql small peardb package library replacement mysql small


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).

0 comments voice your opinion now!
pear package peardb performance tuning buffer connection reporting pear package peardb performance tuning buffer connection reporting


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.

0 comments voice your opinion now!
peardb pearmdb2 mdb2 package wrapper peardb pearmdb2 mdb2 package wrapper



Community Events





Don't see your event here?
Let us know!


release introduction tips framework code api deployment language laravel threedevsandamaybe bugfix series community symfony development zendserver conference interview list podcast

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework