1
dynek
PGSQL Support
  • 2005/3/7 8:07

  • dynek

  • Just popping in

  • Posts: 8

  • Since: 2005/2/2 8


Hi!

I read some stuff on these forums and on the net but can't figure out if there's a way to get XOOPS to work with PGSQL.

I downloaded XOOPS version 2.0.9.2 and only have MySQL in the database list. Is there a way to also have pgsql ?

If so please lemme know I'd really appreciate it. We need to be able to use PGSQL for many reasons (views, PL SQL, ...)

I read that some people got it working. If you are one of these people, could you please gimme a link where I could get the pgsql enabled version of xoops?

Thanks a lot for your work. It's a really great CMS!

2
Jurgen
Re: PGSQL Support
  • 2005/4/11 18:26

  • Jurgen

  • Just popping in

  • Posts: 13

  • Since: 2004/11/14


Is there a doctor in the room to answer this question ?

3
dasdan
Re: PGSQL Support
  • 2005/4/12 19:03

  • dasdan

  • Just popping in

  • Posts: 29

  • Since: 2005/1/22


I'm not an specialist and didn't do it myself, but I would do it like this

in the mainfile.php , you should change
define('XOOPS_DB_TYPE', 'mysql');

change it to : define('XOOPS_DB_TYPE', 'pgsql');

in the classes/database/databasefactory.php
you can see the getDatabase function, this will include
XOOPS_ROOT_PATH.'/classes/database/'.XOOPS_DB_TYPE.'database.php'; (don't change)

so the only thing you have to do, is to make a copy of the
mysqldatabase.php class, name it ie pgsqldatabase.php, and put it in the '/classes/database/ directory ,
make sure the prefix in your mainfile, corresponds with the filename of your pg class

so now you can start to re-implement the methods with the pg functions instead of mysql

good luck, and don't forget to post your sollution on the forum.

4
Jurgen
Re: PGSQL Support
  • 2005/4/13 12:20

  • Jurgen

  • Just popping in

  • Posts: 13

  • Since: 2004/11/14


"Ha, een landgenoot die me uit de knoei helpt"

Yes, we will try this out and study the code. the big question is ...stability. Some people have succeeded to run XOOPS on PostgreSQL but I see the lack of posted information.

5
dasdan
Re: PGSQL Support
  • 2005/4/13 16:44

  • dasdan

  • Just popping in

  • Posts: 29

  • Since: 2005/1/22


Oh what a small world

6
ackbarr
Re: PGSQL Support

at this point the only supported platform is mysql, those interested in having support for PGSQL are welcome to submit a core patch to the XOOPS SF.net project for approval.

7
Jurgen
Re: PGSQL Support
  • 2005/4/15 10:22

  • Jurgen

  • Just popping in

  • Posts: 13

  • Since: 2004/11/14


Ackar,

Can You create a section on XOOPS for PostgreSQL setup, development and Beta testing ? Some people did already created patches and a sql file and part of it are on the site, but it should be better to have a centralized section.

8
Herko
Re: PGSQL Support
  • 2005/4/15 10:47

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


If there is PostgreSQL support development, then the central place for this is what Ackbarr pointed out: the SF.net trackers. We will not create a 'fork' just for PostgreSQL, but add the database to the regular branch.

I suggest you focus on this for XOOPS 2.1, not the XOOPS 2.0.x branch.

Herko

9
Jurgen
Re: PGSQL Support
  • 2005/4/18 8:11

  • Jurgen

  • Just popping in

  • Posts: 13

  • Since: 2004/11/14


Yes, that is my intention anyway. It is useless to create another fork. With a section, I mean a section on the site, to discuss progress, findings.

Additionally, it should be usefull to provide 'flags' to every module to mention comptability with a sql base. A flag for Mysql, a flag for PostgreSQL...

In our projects, currently we focus on the stored procedures, to increase security issues. The new version of MySQL does have stored procedures, but it is less mature and proven as PgSQL right now. That's why we need this so badly.

10
lubisome
Re: PGSQL Support
  • 2005/10/31 18:34

  • lubisome

  • Just popping in

  • Posts: 1

  • Since: 2005/8/25


I did the tips, but got the error: atal error: Class 'XoopsPgsqlDatabaseProxy' not found in D:\www\xampp\htdocs\pghome\class\database\databasefactory.php on line 30.
What´s wrong?

Login

Who's Online

170 user(s) are online (98 user(s) are browsing Support Forums)


Members: 0


Guests: 170


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits