The source shall set you free

Wednesday February 26, 2003 @ 08:29 PM (PST)

After receiving numerous requests for the source behind the site, I've tossed together an official release. I'm calling it Poseidon, because I've never named anything Poseidon and I thought it might be fun. You can read more, and download the code, at Poseidon's very own page.

Comments

Ok I installed it fine, but now I can't figure out how to post articles or anything, I can log into my site, but nothing else.

Once you're logged in as the administrator, click "Post Content" under the "User Tools" menu.

So how about us poor fools who still swear allegiance to PostGreSQL and categorically refuse to install MySQL?

Well, since the driving concept behind Poseidon is simplicity, it's targeted for MySQL. MySQL is simple and fast and I like it so there. I have no plans to implement PostgreSQL support, but it wouldn't be too difficult at all to do. You'd just need to make a few minor modifications to the database class and a few of the functions; you'd only need to modify two files. The only hard part will be replicating MySQL 4's full text search capabilities.

Now, there's a project I will save for a rainy day when I don't have to work on something else - should such a day ever occur...

Eh, I think it'd take all of fifteen minutes.

Perhaps, for someone as skilled at PHP as you. :o) Bear in mind that I'm still a total newbie in that respect...

There would be very little PHP involved. All you'd need to do is edit /lib/db.class.php and change the five or so MySQL function calls to PostgreSQL calls (they're pretty much a one-to-one mapping, but prefixed with pg_ instead of mysql_). Then you'd need to browse through the database functions in /lib/functions.php and just modify the SQL queries wherever necessary (which shouldn't be more than three or four places).

The main improvement I would like to see here is to be able to edit a post and content. Is that a possibily? Thanks.

Click on the title of a post to edit it while logged in as the administrator. Voila.

Copyright © 2002-2012 Ryan Grove. All rights reserved.
Powered by Thoth.