Login   Register  
PHP Classes
elePHPant
Icontem

Class: Database conversion

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Ben Yacoub Hatem  >  Database conversion  >  Download .tar.gz .zip  >  Support forum Support forum (1)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: Database conversion
Support forum Support forum
Base name: dbconv
Description: Convert database specific SQL to neutral SQL code
Version: -
PHP version: -
License: The PHP License
All time users: 1235 users
All time rank: 2541
Week users: 0 users
Week rank: 2664
Picture of Ben Yacoub Hatem
Author: Ben Yacoub Hatem <e-mail contact>
Packages: 18 Browse this author's classes Browse this author's classes
Country: Tunisia Tunisia - PHP jobs in Tunisia
Age: 33
All time rank: 211 in Tunisia Tunisia
Week rank: 76 Down1 in Tunisia Tunisia
Innovation award
Innovation award
Nominee: 4x


  Detailed description  
This class is meant to process SQL code with syntax that is specific to certain databases and convert it to SQL code that is database neutral.

The goal of the class is to help avoiding the use of SQL code that is not compatible with all the supported databases.

Currently the class supports converting SQL code specific to Oracle, MySQL, Microsoft SQL Server, SQLite and ODBC.

 

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes
Group folder image Text processing Manipulating and validating text data View top rated classes

  Rate classes User ratings   Applications   Files Files  

  Innovation Award  
PHP Programming Innovation award nominee
January 2005
Number 3
 Sometimes it is convenient to write applications that can work with many different SQL based databases.

Some database abstraction packages can help writing applications that can work unchanged with different databases.

However, if you start using SQL code that uses features that are specific of certain databases, it will be harder to make the applications work with other databases later.

This class can help avoiding some SQL portability problems by converting the SQL code that you use into SQL code that does not use certain database specific features known by the class.

Manuel Lemos

  User ratings  
There are not enough user ratings to display for this class.

  Applications that use this class  
No application links were specified for this class.
Add link image If you know an application of this package, send a message to the author to add a link here.
  Files folder image Files  
File Role Description
Plain text file DBConv.php Class Main class
Plain text file sample-oraconv.php Example sample usage to convert an oracle DB

Download all files: dbconv.tar.gz dbconv.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.