Which database do you use most of all with PHP-Nuke?

Site Admin Joined: Jun 04, 2004 Posts: 6433

Several modules use MySQL-specific syntax, but Nuke supports many databases. Which database is the primary database for your Nuke installation(s)?

Posted: Sun Nov 12, 2006 6:55 pm

I would buy anyone lunch if they can show another database (besides MYSQL) that works "out of the box" without any modifications to the abstraction layer or to the database definitions that come standard. I'm becoming convinced that the database abstraction layer is another of FB's ... well the acronynm is w.d.'s, that while conceptually appealing, is missing the technical underpinning to make it work in reality.
Plus my guessestimate is that it adds 20 to 40 percent overhead to the system but it could be worse than that.

Posted: Sun Nov 12, 2006 7:10 pm

I thought the database abstraction layer came from phpBB. It certainly looks like something that is over FB's head anyway (especially the object oriented part). It looks like a pretty thin wrapper.

Posted: Sun Nov 12, 2006 7:22 pm

Yes, it came from PHPBB, that's even in the code. It is over FB's head too I'm sure. But that doesn't mean it works. There have been postings about problems with the mysql4.php file for instance. And recently another thread about problems with DB2 although the author couldn't even get the database to load because of field discrepancies.

I used to be involved in data processing management and the notion that you'd just swap back and forth between databases is quite frankly absurd. I recently (just as an experiment) converted an entire Ravennuke test site over to native SQL calls and entirely removed the database abstraction layer (so db.php and mysql.php were never even included) and it worked like a charm. Took about 4 hours total and most of that was because I had to figure out how to make the connection properly in mainfile. Once RN 2.10 is out the door I will post some more on this in the Making Nuke Efficient area.

Posted: Mon Nov 13, 2006 3:47 am

To call that an abstraction layer is almost obsurd. Ive made a few, and the reason isnt for cross database, But in order to impliment checks ONCE and once only, forget the whole idea that you need to check it within the script.

thats going off topic, truth is the query syntax in itself is different. There is a way to make a proper abstraction layer but it would take any decent coder about a month to develope one that can cross db types of this manner and even the ones offered buy people who charge is ussually limited to a few types of databases, So yeah, Thats a lofty project to get into and if coders knew how to make an abstraction layer properly, there really wouldnt be a need for all this security but thats Just my opinion.

Posted: Mon Nov 13, 2006 10:14 am

I can't imagine using anything BUT MySQL for any CMS.

Frankly, I don't think anyone else comes close to MySQL, espcially when we start talking about cost/performance ratios. Sorry, but free is the best kind of enterprise ready licensing that I can think of.

Given the reliability factors and the overwhelmingly large user base and improving features and support (much faster than the commerical software curve ... think Oracle, DB2, etc...) I'd certainly never go back to solutions where you spend full time fixing and patching the DB, instead of worrying about your own software. Sorry, I just can't go backwards again.

As for the other solutions, I know they are there, I just choose to continue to ignore them when I fly along happily with MySQL.

Just my 2 Cents.
Steph

Posted: Mon Nov 13, 2006 11:50 am

I definitely agree, but find it interesting that the people who use SQLServer and other commercial software would love to switch to MySQL once it has important features like triggers and stored procedures. Yes, Postgres has this and MySQL is introducing these features. But when people are accustomed to Beta testing a GA release, it's tough to convince them that other vendors won't do the same...

Posted: Mon Nov 13, 2006 1:57 pm

I think only mysqli is the only other one I see from time to time.