Welcome to Geeklog, Anonymous Monday, April 15 2024 @ 09:39 am EDT

Geeklog Forums

postgresql rather then mysql?

Status: offline


Forum User
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,

Status: offline


Site 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!



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.


Can i get access to the semi functional postgresql port?

Status: offline


Site 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.

All times are EDT. The time is now 09:39 am.

  • 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