CMS Made Simple Forums

Why CMS doesn't use pure MySQL instead ADODB ?

I don't know someone, who's using CMS and Postgres. In german forum there are some users, which make a try to rewrite CMS to MySQL. And what should I say - CMS speeds up to 400%. And the work isn't completely done ...

I get bug reports all the time from people who have issues with postgres.  Plus, part of my plam is to support SQLite so that people with PHP5 don't have to setup a database at all!

I think people should be spending their time trying to figure out why ADODB is so slow.  I know it's not the driver area, since I've looked at the code and it's pretty minimal.

I'd rather look forward, instead of locking it into one database driver.  What happens when the mysql driver goes and mysqli is the only one left?  Rewrite the whole thing?

I'm sorry, but I can't see going foward with that.  I'd rather fix the problem instead.

I didn't know adodb lite existed.  Very cool.  I'd be willing to give it a shot and see how well it works...

http://adodblite.sourceforge.net

Any results ?

Sorry.  It's been a little crazy last week or so.

I tried it, but it didn't support some major things.  Of course, I can't remember what they are at the moment, but it would've required me to do some serious additions to the drivers or a lot of work to CMSMS for it to work.  I just don't have the time now to pursue anything that extensive at the moment.

Thx.