xoops forums

jmass

Friend of XOOPS
Posted on: 2003/12/19 2:16
jmass
jmass (Show more)
Friend of XOOPS
Posts: 524
Since: 2003/12/18
#1

Postgress or SAP-DB???

I see that currently there is only support for MySQL. I also notice a few interesting points.

1> There is a Database Abstraction Object

2> There is support in the install to install on different DBs(though not implemented)

What is the status on multiple database support? I would love to help. If there is others working on it, let me know what I can do. If not, I would like to start.

J-Mass

jsabater

Just popping in
Posted on: 2003/12/19 9:54
jsabater
jsabater (Show more)
Just popping in
Posts: 7
Since: 2003/11/11
#2

Re: Postgress or SAP-DB???

May I suggest Firebird (http://www.firebirdsql.org) as a good alternative? It's a complete, ANSI compliant database that supports triggers, stored procedures, and so on. Latest version is 1.5 rc7, which will probably be the last release candidate before 1.5. And it's GPL

jmass

Friend of XOOPS
Posted on: 2003/12/19 15:11
jmass
jmass (Show more)
Friend of XOOPS
Posts: 524
Since: 2003/12/18
#3

Re: Postgress or SAP-DB???

What is wrong with Postgres or SAP-DB?

Postgress is BSD and SAP-DB is GPL.

Having said that, I have nothing against firebird, I have just never worked with it.

My main concern is MySQL's lacking in data integrity features, such as commit and roll-back.

SAP-DB is great, and Postgres is the old standard. How does firebird rate?

Herko

XOOPS is my life!
Posted on: 2003/12/19 16:14
Herko
Herko (Show more)
XOOPS is my life!
Posts: 4238
Since: 2002/2/4 1
#4

Re: Postgress or SAP-DB???

I talked to Kazu about this and can tell you this:

We're having the current XOOPS version (2.0.5.1) tested to work with Postgress. This should work fine, but we're not 100% sure. At this moment, XOOPS can generate sql files for MS SQL server, postgresql, mysql, firebird, and interbase. These layers haven't all been implemented yet, but it's possible. We're also looking at ingres db integration.

The problem now, is that all SQL files need to be converted to the other database formats. For every module. This puts the brunt of the pressure on the module developers, and we can't expect them to know the db schema's of all the mentioned databases.

The next version of XOOPS (2.1) will make it a lot easier for module developers to support other db's: XOOPS will automatically generate the correct SQL files for the supported databases, based on an XML schema file provided by the module(developer) itself. Thus, it would be easy to add another db support to XOOPS, without changing all the modules

Herko

jmass

Friend of XOOPS
Posted on: 2003/12/23 2:18
jmass
jmass (Show more)
Friend of XOOPS
Posts: 524
Since: 2003/12/18
#5

Re: Postgress or SAP-DB???

That is great news!

One question...

There obviously needs to be these sql dump for each of these DBs. But won't there need to be some adjustment, or alternate versions of the DAO?

Jason

FastEddie

Just popping in
Posted on: 2004/2/3 18:24
FastEddie
FastEddie (Show more)
Just popping in
Posts: 9
Since: 2002/2/6 2
#6

Re: Postgress or SAP-DB???

What's the status of the PostgreSQL support?

Thanks,
-Ed

giba

Just can't stay away
Posted on: 2004/3/24 17:55
giba
giba (Show more)
Just can't stay away
Posts: 638
Since: 2003/4/26
#7

Re: Postgress or SAP-DB???

What's the status of the PostgreSQL support?

Thanks !!!