In the past i've written wrappers (and released free on my web site) for various database engines ... sqlite2, sqlite3, mysql, mssql. I am considering unifying them into one generic wrapper. This would be similar to the PDO library in PHP.
For example, when you initialize the engine, you can specify (via constant) which engine(s) you will be using and when you connect to the database, you specify what kind of database engine you're talking to. For example.
unidbInit %UNIDB_SQLITE3 or %UNIDB_MYSQL
hDB = unidbConnect(%UNIDB_MYSQL, "hostname", port, user, password)
'- do some sql stuff here
unidbDisconnect hDB
unidbUninit
This allows the same code (save the first parameter of the unidbConnect function) to be the same regardless of the database engine.
Anyway, i was thinking of open-sourcing the project (hosted on my subversion server), opening it up to community development after i have the base framework in place, and making it public domain.
Anyone interested in something like this - either using or contributing or?
I might seek help in adding support for sqlLightning and ODBC at some point down the road. I have a wrapper for odbc that i have not released to the general public, but it needs work. i haven't used sqllightning, but it looks darn cool (thanks fred/paul/etc).
best regards,
don
For example, when you initialize the engine, you can specify (via constant) which engine(s) you will be using and when you connect to the database, you specify what kind of database engine you're talking to. For example.
unidbInit %UNIDB_SQLITE3 or %UNIDB_MYSQL
hDB = unidbConnect(%UNIDB_MYSQL, "hostname", port, user, password)
'- do some sql stuff here
unidbDisconnect hDB
unidbUninit
This allows the same code (save the first parameter of the unidbConnect function) to be the same regardless of the database engine.
Anyway, i was thinking of open-sourcing the project (hosted on my subversion server), opening it up to community development after i have the base framework in place, and making it public domain.
Anyone interested in something like this - either using or contributing or?
I might seek help in adding support for sqlLightning and ODBC at some point down the road. I have a wrapper for odbc that i have not released to the general public, but it needs work. i haven't used sqllightning, but it looks darn cool (thanks fred/paul/etc).
best regards,
don
Comment