ezSQL : Easy database manupulation

ezSQL is a database layer that makes it extremely easy to use mySQL, Oracle, SQLite (PHP), within your PHP script. It’s just great! It allows db caching, excellent debuging option, you can get your results in object /array/associative array form etc. moreover, ezSQL is featherweight, so will not add very much overhead to your website. Better than Pear:DB class for sure (IMO). Download it and read the examples included. Great documentation & simple API making it very is to understood.

WordPress uses ezSQL for its database operations. You can use it for your own works to facilitate rapid development.

click here to download ezSQL.

Features:

* ezSQL is a widget that makes it ridiculously easy for you to use mySQL, Oracle8, InterBase/FireBird, PostgreSQL, SQLite (PHP), SQLite (C++) or MS-SQL database(s) within your PHP/C++ scripts (more db’s coming soon)

* It is one php file that you include at the top of your script. Then, instead of using standard php database functions listed in the php manual, you use a much smaller (and easier) set of ezSQL functions.

* It automatically caches query results and allows you to use easy to understand functions to manipulate and extract them without causing extra server overhead

* It has excellent debug functions making it lightning-fast to see what’s going on in your SQL code

* Most ezSQL functions can return results as Objects, Associative Arrays, or Numerical Arrays

* It can dramatically decrease development time and in most cases will streamline your code and make things run faster as well as making it very easy to debug and optimise your database queries.

* Works with Smarty templating language

* It is a small class and will not add very much overhead to your website.