Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff
Poll
Which database do you use most of all with PHP-Nuke?
Access
0%
 0%  [ 0 ]
DB2
0%
 0%  [ 0 ]
MySQL
100%
 100%  [ 15 ]
Oracle
0%
 0%  [ 0 ]
Postgres
0%
 0%  [ 0 ]
SQLServer
0%
 0%  [ 0 ]
Other (please comment)
0%
 0%  [ 0 ]
Total Votes : 15


Author Message
kguske
Site Admin



Joined: Jun 04, 2004
Posts: 6433

PostPosted: Sun Nov 12, 2006 5:41 pm Reply with quote

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

_________________
I search, therefore I exist...
nukeSEO - nukeFEED - nukePIE - nukeSPAM - nukeWYSIWYG
 
View user's profile Send private message
fkelly
Former Moderator in Good Standing



Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Sun Nov 12, 2006 6:55 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website
Gremmie
Former Moderator in Good Standing



Joined: Apr 06, 2006
Posts: 2415
Location: Iowa, USA

PostPosted: Sun Nov 12, 2006 7:10 pm Reply with quote

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 
View user's profile Send private message
fkelly







PostPosted: Sun Nov 12, 2006 7:22 pm Reply with quote

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.
 
gregexp
The Mouse Is Extension Of Arm



Joined: Feb 21, 2006
Posts: 1497
Location: In front of a screen....HELP! lol

PostPosted: Mon Nov 13, 2006 3:47 am Reply with quote

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!! 
View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger ICQ Number
64bitguy
The Mouse Is Extension Of Arm



Joined: Mar 06, 2004
Posts: 1164

PostPosted: Mon Nov 13, 2006 10:14 am Reply with quote

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. 
View user's profile Send private message
kguske







PostPosted: Mon Nov 13, 2006 11:50 am Reply with quote

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...
 
technocrat
Life Cycles Becoming CPU Cycles



Joined: Jul 07, 2005
Posts: 511

PostPosted: Mon Nov 13, 2006 1:57 pm Reply with quote

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

_________________
Nuke-Evolution
phpBB-Evolution / phpBB-Evolution Blog 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> General/Other Stuff

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©