Help Testing PDO Database Support - Developer News - XOOPS News - XOOPS Web Application System

XOOPS

News

News World of XOOPS Developers Hacks Themes Archive Submit News

Developer News: Help Testing PDO Database Support

Posted by: wishcraftOn 2010/3/31 6:20:00 6167 reads

Have you ever wanted to run XOOPS on something apart from MySQL?

I have been doing some research since the start of this forum post and have fitted now the PDO to XOOPS 2.5 Beta.

This is right now just a research project for possible inclusion with 2.6 series, but I need some help with testing as a lot of these database systems are quiet expensive.. There is support for Postgres, Oracle, Sybase, ADO, ODBC, MS SQL, MSDE and many others like interbase and it GNU counterpart firebird.

This archive contains all the changed files for testing.. I need help testing this as much as possible.. There is no reason for it to not work unless there is some reserved word or microsoft problem with pivoting MySQL files to xoops.. Of course you can include the needed files as well, but it will attempt to pivot on mYql files if it can't find a SQL file for the selected database type..

Download 2.5.0 Beta with PDO from my Skydriver spot.

The Forum topic for XOOPS PDO is here..

The comments are owned by the author. We aren't responsible for their content.

user

Re: Help Testing PDO Database Support

sadistiko Published 03/31/2010 7:28 Friend of XOOPS Joined 12/13/2004 Comments 477

What are beneffits if I use PDO database against MySQL?
Actually I never heard for that one

user

Re: Help Testing PDO Database Support

wishcraft Published 03/31/2010 9:29 Updated 03/31/2010 11:20 Module Developer Joined 05/18/2007 Comments 3711

Well with the PDO you have support for multiple different mysql types,

ie:Support MySQL Connection Types with PDO

mysql
mysqli
mysqlpo
mysqlt
mysql via ADO or ODBC

ie:Support MySQL Connection Types without PDO

mysql

All these are different presents of the mysql binary which are different and used for more heavy duty environments.

I notice the PDO has performance enhancements, with the next release there will be a new query file cache as well on top of the smarty file template cache, this still needs to be discussed so it hasn't been included..

ie: Beyond Beta

 // Will file cache select query for 120 second in FULL PDO not Beta 
  $seconds_cache = 120; 
  $sql = "SELECT * FROM ".$GLOBALS['xoopsDB']->prefix('user'); 
  $result = $GLOBALS['xoopsDB']->queryF($sql, false, false, false, $second_cache);

I noticed in building this, this library seems to improve the performance of XOOPS even though it is more code, the pages seemed to load quicker with the system.

Remember the database engine was never completed, by importing this PDO into xoops, it increases it's scalability. Also allows a larger spectrum of extra users.. By Importing ADOdb, we get to complete this section of code from 1996, to a modern edge of 2010... The current database engine does not seem to perform as well as this one.

btw.. sadistiko PDO stands for Procedural Database Objects

user

Re: Help Testing PDO Database Support

ghia Published 03/31/2010 9:44 Updated 04/01/2010 7:21 Community Support Member Joined 07/03/2008 Comments 4953

Most benefits are for companies, that want to run a (intranet) site with XOOPS. They can then use their database of choice, eg MSSQL, Oracle, Interbase, ..., with all the advantages for regular backup, replication, maintenance, etc.

For local use, you can easy test with free databases as eg Firebird, which is also multi platform (OS).
For use on a hosters server, you depend on the offer of the hoster and/or the possibility to install extra database software.

For some database, as eg Oracle, exists free personal versions.

user

Re: PDO Database Support - Install Changes

wishcraft Published 03/31/2010 14:34 Updated 03/31/2010 15:04 Module Developer Joined 05/18/2007 Comments 3711

Resized Image

Theoretically XOOPS can run on all these platforms .. I Like also how it allows us a way to use store procedures with MySQL 5.0.. phppp?

Archive Date modified: 1/04/2010 12:32 AM

user

Re: Help Testing PDO Database Support

sadistiko Published 03/31/2010 14:58 Friend of XOOPS Joined 12/13/2004 Comments 477

I'm pretty sure I will never use any of these, but I'm sure this can bring more people to xoops. It will give some seriousness to Xoops.
Keep a good work

Re: Help Testing PDO Database Support

btesec Published 03/31/2010 16:40 Updated 03/31/2010 16:42 Friend of XOOPS Joined 02/20/2007 Comments 623

geeeee its like opening the doors from heaven. Its like providing a recipe for making cakes, choose your flavors. I don't like milk cake, but someone else does. It makes XOOPS more adaptable by more developers for many scenarios. Myself am interested in postgres db.
Kudos to Wishcraft on this most important initiative
btesec

user

Re: Help Testing PDO Database Support

ghia Published 04/01/2010 7:29 Updated 04/01/2010 7:30 Community Support Member Joined 07/03/2008 Comments 4953

Quote:

Theoretically XOOPS can run on all these platforms

(dbf platforms)

In practise there may some pitfalls.

I know there are several modules, who apply the MySQL functions of the PHP library directly and do not call the generic functions of the XOOPS database library. This is for example the case for some loose integrated modules as some wiki's, that are derived from an existing stand alone software package.

I don't know, but I assume there are no such shortcuts to MySQL in the core and standard modules.

user

Re: Help Testing PDO Database Support

redheadedrod Published 04/01/2010 13:21 Home away from home Joined 02/26/2008 Comments 1296

Quote:

I know there are several modules, who apply the MySQL functions of the PHP library directly and do not call the generic functions of the XOOPS database library. This is for example the case for some loose integrated modules as some wiki's, that are derived from an existing stand alone software package.

The pluses far outweigh the negatives here. There is nothing to say that those modules that do access MySql directly would not work with this if still using MySQL but that if someone uses a Db other then MySQL then some modules may break. However any broken modules SHOULD be relatively simple to fix. This is just an example of why module writers should make sure they use XOOPS API functions whenever possible.

With 2.5 we are no longer supporting PHP versions less then 5 so it would be a good time to support something such as this. And potentially the whole "blue" module movement should also heavily push using the API functions for the database access so regardless of what system is used or not used the modules will still work regardless.

The sooner we incorporate something like this the sooner the modules will be upgraded to work with multiple databases. It is a drastic change but is one that has been needed for a long time. With the recent attempt of Oracle trying to obtain MySQL it is a perfect example of WHY we need something like this sooner rather then later. Just should let users know if they use databases other then MySQL then some modules may not work.. Then again I knew going to 2.3.3 that some modules didn't work that worked with 2.0.18, then again when I went to 2.4.4 of XOOPS I knew more modules would break.. And I assume more modules will break when I upgrade to 2.5 from 2.4.4...

And maybe someone could come up with a base module similar to the blank module that could be used by people porting over code to work as a module. Or maybe just a "porting" FAQ that could help someone fuddling trying to port something over about the things to look for.

Rodney

user

Re: Help Testing PDO Database Support

wishcraft Published 04/02/2010 22:20 Module Developer Joined 05/18/2007 Comments 3711

Hi all, there was a couple of MySQL direct command calls in the install that will eventually have to be reviewed and adjusted, for the moment, I have removed these so you can install the application.

The Archive has just been update again on :: 3/04/2010 7:54 AM

The install will eventually to have to be changed for the official release so the database fields reflect the naming convention for example Server Host can be for example DNS, File, IP, Hostname. The file database don't have a database name..

user

Re: Help Testing PDO Database Support

wishcraft Published 04/13/2010 4:34 Updated 04/13/2010 4:42 Module Developer Joined 05/18/2007 Comments 3711

Well Mamba it got the governments of the world excited about XOOPS and MSSQL, Oracle and others in the database platforms -- I see no bug comments -- it would seem.. What an interesting group of people.

See XOOPS was always designed to have this form of database implementation, it is written in a controller fashion for later compatibilities.

Quote:

I know there are several modules, who apply the MySQL functions of the PHP library directly and do not call the generic functions of the XOOPS database library. This is for example the case for some loose integrated modules as some wiki's, that are derived from an existing stand alone software package.

This may also be because of the limited database functions, I have cut the cache ones mainly from the engine at the moment, it is another file cache on the xoops_cache folder for cache of store procedures and questions to the database.

In the new PDO functions you have a group of special functions that extend the ability of modules to access functions like store proceedures and other systems of database functions.

Login

Username

Password

Remember me

Register now! | Lost Password?

Search

Advanced Search

Recent Comments

Re: New Admin Theme for XOOPS (Beta)

Publisher liomj 10/28/2024 23:33
Sanford Pharmacy: Exceptional Pharmacy Services Tailored to You

Publisher donaldjohn 10/16/2024 9:53
Re: New Admin Theme for XOOPS (Beta)

Publisher walkero 10/15/2024 18:30
Re: XOOPS 2.5.12 Beta-2 available for Testing

Publisher cadch 08/30/2024 6:33
Re: XOOPS 2.5.12 Beta-2 available for Testing

Publisher cadch 08/30/2024 6:30

Who's Online

195 user(s) are online (29 user(s) are browsing XOOPS News)

Members: 0

Guests: 195

Donat-O-Meter

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}

{{ record.commit.author.name }} {{ record.commit.author.date | formatDate }}

Archives

News archives