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

Richard Heyes' Blog:
PEAR::DB replacement class updated
Jun 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.

tagged: peardb class replacement pear database abstraction peardb class replacement pear database abstraction

Link:

Richard Heyes' Blog:
PEAR::DB replacement class updated
Jun 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.

tagged: peardb class replacement pear database abstraction peardb class replacement pear database abstraction

Link:

Richard Heyes' Blog:
PEAR::DB database class(es) replacement
Jun 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.

tagged: peardb package library replacement mysql small peardb package library replacement mysql small

Link:

Richard Heyes' Blog:
PEAR::DB database class(es) replacement
Jun 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.

tagged: peardb package library replacement mysql small peardb package library replacement mysql small

Link:

Stoyan Stefanov's Blog:
Performance tunning with PEAR::DB
Jan 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).

tagged: pear package peardb performance tuning buffer connection reporting pear package peardb performance tuning buffer connection reporting

Link:

Stoyan Stefanov's Blog:
Performance tunning with PEAR::DB
Jan 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).

tagged: pear package peardb performance tuning buffer connection reporting pear package peardb performance tuning buffer connection reporting

Link:

Jacques Marneweck's Blog:
PEAR::DB alike wrapper for PEAR::MDB2
Jan 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.

tagged: peardb pearmdb2 mdb2 package wrapper peardb pearmdb2 mdb2 package wrapper

Link:

Jacques Marneweck's Blog:
PEAR::DB alike wrapper for PEAR::MDB2
Jan 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.

tagged: peardb pearmdb2 mdb2 package wrapper peardb pearmdb2 mdb2 package wrapper

Link: