Author |
Message |
kguske
Site Admin
![](modules/Forums/images/avatars/41f0b40a419280935f3a0.gif)
Joined: Jun 04, 2004
Posts: 6433
|
Posted:
Sun Nov 12, 2006 5:41 pm |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
fkelly
Former Moderator in Good Standing
![](modules/Forums/images/avatars/gallery/blank.gif)
Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY
|
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. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
Gremmie
Former Moderator in Good Standing
![](modules/Forums/images/avatars/0cd76dcf45da5de2cf864.jpg)
Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA
|
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. |
_________________ GCalendar - An Event Calendar for PHP-Nuke
Member_Map - A Google Maps Nuke Module |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
fkelly
![](modules/Forums/images/avatars/gallery/blank.gif)
|
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. |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
gregexp
The Mouse Is Extension Of Arm
![](modules/Forums/images/avatars/458c161744a70db912a6e.jpg)
Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol
|
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. |
_________________ For those who stand shall NEVER fall and those who fall shall RISE once more!! |
|
![ICQ Number ICQ Number](themes/RavenIce/forums/images/lang_english/icon_icq_add.gif) |
![](themes/RavenIce/forums/images/spacer.gif) |
64bitguy
The Mouse Is Extension Of Arm
![](modules/Forums/images/avatars/183ecd6a404a3683445de.gif)
Joined: Mar 06, 2004
Posts: 1164
|
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 |
_________________ Steph Benoit
100% Section 508 and W3C HTML5 and CSS Compliant (Truly) Code, because I love compliance. |
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
kguske
![](modules/Forums/images/avatars/gallery/blank.gif)
|
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... |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
technocrat
Life Cycles Becoming CPU Cycles
![](modules/Forums/images/avatars/d867b24b43a1b71491557.jpg)
Joined: Jul 07, 2005
Posts: 511
|
Posted:
Mon Nov 13, 2006 1:57 pm |
|
|
|
![](themes/RavenIce/forums/images/spacer.gif) |
|