wonko.com

The eclectic musings of a bitter software engineer.

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.

Thursday February 27, 2003 @ 05:04 PM (PST) Posted by Gonzo

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

Thursday February 27, 2003 @ 05:46 PM (PST) Posted by Ryan Grove

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

Thursday February 27, 2003 @ 07:46 PM (PST) Posted by GreyStork

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.

Thursday February 27, 2003 @ 08:01 PM (PST) Posted by Ryan Grove

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

Thursday February 27, 2003 @ 08:14 PM (PST) Posted by GreyStork

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

Thursday February 27, 2003 @ 08:59 PM (PST) Posted by Ryan Grove

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

Friday February 28, 2003 @ 09:39 AM (PST) Posted by GreyStork

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

Friday February 28, 2003 @ 10:08 AM (PST) Posted by Ryan Grove

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

Friday February 28, 2003 @ 02:21 PM (PST) Posted by Gonzo

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

Friday February 28, 2003 @ 02:24 PM (PST) Posted by Ryan Grove

Wow, easy as pie

Friday February 28, 2003 @ 03:41 PM (PST) Posted by Gonzo
Post a comment

Basic XHTML (including links) is allowed, just don't try anything fishy. Your comment will be auto-formatted unless you use your own <p> tags for formatting. You're also welcome to use Textile or Markdown.

Don't type anything here unless you're an evil robot:


And especially don't type anything here:

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