Menu

New class in development

I'm still working on new classes, so please don't think this project is dead.
Right now I'm working on a database-class, which is supposed to make migration from one DBMS to another easier, meaning that you don't have to rewrite all your queries.
At the moment I'm implementing this for MySQL, PostgreSQL and MSSQL. So far this is limited to rewrite the indicators for field- and table-names (for example `` in MySQL) to the selected DBMS's indicators (for example [] in MSSQL).
I want to try to add some emulation for LIMIT, which does not exist in MSSQL and does not accept the offset parameter in PostgreSQL (there you have to use OFFSET to specify it, but at least this is also supported by MySQL), and maybe some other functions if I can find something which could be useful to emulate.
For testing I changed my website (still not online) to use the class, and I can easily switch from MySQL to PostgreSQL (MSSQL would propably work too if I wouldn't use LIMIT from time to time) just by editing my config-file.

Posted by Dennis Wronka 2006-09-23

Log in to post a comment.

Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.