A database-abstraction package?

From: Thomas Weholt (2002_at_weholt.org)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 21:30:34 +0100

Hi,

I need to make my project work with SQLite, MySQL and Postgresql, but I
don't want to create and maintain a set of table-schemas for all of them.
I'd rather specify this information in a common format and then let some
piece of code generate and run the sql-statements to create the tables in
the database. When I insert, update or delete records I also want a common
interface. In my project I use alot of auto-increment primary keys so this
would have to be handled as well.

Does anybody know if there are any such module or package available already?
If not I've got to start working on one and it would be nice to have some
pointers or guidelines if somebody has any ideas or opionions. A system
capable of handling any database would be best, but as a minimum I need to
support SQLite and MySQL, on Linux and Windows.

Thomas

Relevant Pages

  • DBConvert for SQLite & MySQL 1.0.0
    ... DBConvert for SQLite & MySQL is a database migration tool which ... The tool is also applicable for MySQL database ... preverification of possible conversion errors, ...
    (comp.software.shareware.announce)
  • Re: OT PDO and sqlite
    ... server that does not have the PDO driver for MySQL, ... Personally, I have my own abstract database class (yes, yet another ... on a server) and subclasses for both MySQL and SQLite ...
    (comp.lang.php)
  • Re: how to migrate request-tracker database from sqlite3 to mysql
    ... I'm trying to migrate request-tracker3.6 database from sqlite to mysql ... some reason importing into mysql didn't work twice. ...
    (Debian-User)
  • Re: php5 sqlite 3 officially not here yet - looking for suggestions
    ... Ive often have had to move a site from one location to another and the thought of just making a copy and transfering the whole site to new location, with sqlite sounded easy .Opposed to dump mysql db to file. ... I have based all my work around sqlite 3 so far,however i have been having issues with ALTER TABLE ... If you want a real database, ...
    (comp.lang.php)
  • Re: DB without MYSQL?
    ... My provider doesn't give me the posebillety to use MYSQL or SQL. ... You can use SQLite. ... If you use PDO, it's even a pretty seamless transition from another database, as long as you're not relying on advanced features. ...
    (alt.php)