Lightweight database abstract classes in PHP: ADODB Lite

Source: Internet
Author: User
Tags abstract pear sqlite sybase

In PHP project development, many architectures are: Smarty + ADODB to do, because the Smarty powerful, more than any template processing class, especially caching technology. ADODB is powerful, much more than pear::D B processing Class, so most people choose ADODB to do database abstract classes, but ADODB class libraries are very large and run very slowly, which is why some developers chose Pear db.

But, so far, the phenomenon is going to change because of a small version of the ADODB: ADODB Lite

According to the official website introduction:

Supports all popular databases that PHP can support. And it's said to be a lot faster than the old version.
Only the full version of the 1/6 memory, fully compatible with ADODB, according to the official, can not change the code at all in the case of porting to ADODB Lite.

Look at the official website saying:

ADOdb LiteWas a result of the a need for a very small, the fast ADOdb library for a browser based game we have been working in for over two Years called alien assault Traders.

We noticed that the ADODB package is consuming over 640k of RAM for each HTTP access. This is even greater than the amount used by the biggest PHP program file used in the game. In effect the ADODB library is consuming vastly more resources than the game itself. This is greatly restricts the number of players that can is online at the same time on respect to the amount of memory Ed by each client.

Currently, ADOdb Lite uses80-85kof system RAM for each HTTP access. This is about87% Smaller memoryFootprint. A side benefit is the increase in speed. The speed increase would vary depending upon the database. This is also a great replacement to extremely high traffic web sites.

We decided to create a ADO database library that is compatible with ADOdb and used far less when memory. This library has a very restricted command set and eliminates most of the esoteric commands, that won't be used by most Websites.

ADOdb Lite is a drop in replacement for ADOdb as long as to you are not using unsupported commands on your website.

The following databases are supported:
databasetype designator (Database Name)
FBSQ (Frontbase)
MaxDB (Max DB)
mSQL (Mini SQL)
MSSQL (Microsoft SQL)
MySQL (MySQL)
Mysqli (MYSQL improved)
MYSQLT (MYSQL w/transactions)
Postgres (Postgres)
POSTGRES64 (PostGres 6.4)
Postgres7 (PostGres 7)
SQLite (SQLite)
Sybase (Sybase)

The only databases that have been fully tested are the MYSQL databases. Drivers have been provided for the other databases and they should. I would appreciate it if users would the other database drivers function.

It's a .... Hehe, I think many PHP developers like it because the speed problem is solved.

ADODB Lite is currently the latest version: 0.0.6

Official website:http://adodblite.sourceforge.net/



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.