XOOPS FAQ - The Database and Site Migration. - Which databases are supported by xoops?

At the time of writing, XOOPS only supports a MySQL database. Support for other databases is in the planning phase, but so far the need for this functionality has been limited and the XOOPS team believes that it is better to support one database 100% than supporting many more databases 70%.

6 Comment(s)

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

Creating one

chco2 Published 12/30/2014 19:19 Module Developer Joined 03/05/2004 Comments 374

Is there a whitepaper on creating support for other databases ?

Re: Creating one

Mamba Published 12/30/2014 20:28 Moderator Joined 04/23/2004 Comments 11409

In XOOPS 2.6.0 Richard implemented Doctrine, and with it you'll be able to use other databases by following the Doctrine implementation - just google for info about some tutorials, like this or this

current stable version

chco2 Published 12/31/2014 8:55 Module Developer Joined 03/05/2004 Comments 374

Thanks for the info Mamba!
Although I need to get this done in 2 weeks for the current stable version ;)
The person that did the Mysqli connector, did he write some documentation that you know of ?

Re: current stable version

Mamba Published 01/02/2015 8:47 Updated 01/02/2015 8:48 Moderator Joined 04/23/2004 Comments 11409

Unfortunately, I am not aware of any documentation, so you'll need to take a look at the code to see how it was done...

But try to follow the commits on GitHub, so you can see what was changed and how, and that should help you to focus only on these changed files...

Databases

redheadedrod Published 01/03/2015 18:47 Updated 01/06/2015 0:16 Home away from home Joined 02/26/2008 Comments 1296

I actually did both the MySQLi connector for 2.5.x and the Doctrine connector for 2.6.

I tried to make the MySQLi connector the same as the old connector. So whatever you did with the old connector should work fine. It is a drop in replacement. The new MySQLi connector can be run object orientated or procedurally based. To stay compatible I made it procedurally based but as I said, you access it the same way that you did the old MySQL connector.

I believe one of the status requests returns more information because it returns an object and if you are not expecting it then it can throw you a little but it is nothing major. I could have probably modified it more to return the status back better but it didn't seem to matter at the time.

As far as 2.6 it is relatively simple to use the new Doctrine connector. Although doctrine 2.5 is currently included I made the connector based on 2. It is very stock Doctrine with a couple Xoops helper functions added for the prefix stuff. Richard did test the connector with different databases and 2.6 and he said quite a few worked but some others needed more work. Doctrine version 2.5 should be more compatible with more databases.

I am currently working on some other projects which I hope to finish up soon. If you have any questions feel free to ask. You probably want to start a message thread so others can be helped as well since there really isn't much in the way of documentation written as of right now.

Rodney

thnx

chco2 Published 01/05/2015 9:51 Module Developer Joined 03/05/2004 Comments 374

Thanks guys!

Login

Username

Password

Remember me

Search

Advanced Search

Donat-O-Meter

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

Did you know ?

you can monitor all visitor activity through php-stats!

More details...

Random question

How do check my site for faults?

Answer here!

Which databases are supported by xoops?