Geeklog Forums

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

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

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?

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.