Welcome to Geeklog, Anonymous Tuesday, November 29 2022 @ 05:21 pm EST

Geeklog Forums

postgresql rather then mysql?


Status: offline

Nav

Forum User
Newbie
Registered: 04/08/04
Posts: 7
Hey everybody,

I was wondering if anyone has successfully modified geeklog to work with a postgresql db server rather then mysql? I was looking at the /system/databases directory and saw mysql.class.php and it seems that one would just need to create a new class? Right now, my site runs on mysql but i'd like to switch everything over to sybase or postgresql or something which is a bit funner to play with.

Thanks in advance,
Nav
 Quote

Status: offline

vinny

Site Admin
Admin
Registered: 06/24/02
Posts: 352
Location:Colorado, USA
There's a bit more involved than just changing the class to support postgresql. Geeklog (unfortuately) uses many MySQL specific SQL statements that aren't compatible with postgresql. Finding and fixing ALL of those is a big project. If you decide to do it, we'd love to see the results!

-Vinny
 Quote

DarcyB

Anonymous
I have a first round postgresql conversion done most features work, bit not exacly the way they should, I'll keey you all informed of progrss as it continues.
 Quote

openfly

Anonymous
blah
Can i get access to the semi functional postgresql port?
 Quote

Status: offline

Tony

Site Admin
Admin
Registered: 12/17/01
Posts: 405
Location:Urbandale, Iowa
There has been a lot of buzz lately about someone who has gotten Geeklog to work with MS SQL Server. The problems with our current code base that made that impossible is the same problems with Postgres. When (if) I get the code in question I am planning to update CVS and post a general announcement that implementing other database class files should work. Please see the mailing list archives for geeklog-devtalk for the history of those conversations.
The reason people blame things on previous generations is that there's only one other choice.
 Quote

All times are EST. The time is now 05:21 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content