bedeviled mojo slop

I took a few hours last night and banged out some code for blojsom to use a relational database for data storage. You can find this under the Experimental | Database download area. Note the release area. This code is experimental. Let me spell that out for you, E-X-P-E-R-I-M ... ahhh, screw it ... if you can't spell I don't want you downloading the source code But, in all seriousness, the source isn't a "hack" in as much as it was identifying threads of execution and seeing where things broke and needed to be changed. That's why the source has a smattering of // XXX: Hibernate comments.

My test setup is as follows: OS X, Java 1.4.2_09, Tomcat 5.0.28, MySQL 5.0.15-standard, Hibernate 3.0.5. To the extent your setup matches what I've got ... great. Otherwise, your mileage may vary. If you're not familiar with setting up any of the above software, don't download the source and try working with it. I'm not worried as it's all Write Once, Run Anywhere. If you want to build the system, you'll need Ant.

If you unpack the source bundle, you'll find a blojsom.sql script that you can use from a tool like YourSQL to create the database structure. Also, make sure your MySQL connector JAR file is installed. I put it in /TOMCAT_HOME/common/lib/.

The good news is that I got much of the system working. Login to the administration console, create a category, add a few entries, lather, rinse, repeat.

The bad news is that there's probably a lot that doesn't work. Indices and key relationships need to be put in place. Various methods are stubbed out. There is more work that needs to be done on the fetcher itself and probably needs to evolve to have all the persistence methods there instead of on the objects themselves.

I'll be posting semi-regular source bundles to this area as the discussion and code evolves.

If you'd like to be involved in any discussions about blojsom and its use of a database or other such blojsom nerdery, go subscribe to the blojsom-developers mailing list.

Technorati Tags: blojsom database

This is being edited in the OPML Editor.

Is this going to be another paragraph?

Let's see if this is another paragraph as well, and maybe some bold or other styled text.

I want to know if this is going to be another paragraph since it's another level indented. Hmmm, doesn't seem to work without the p tag wrappers.

And just in case other nerds out there wanted to try this with blojsom, the only change I had to make to get things to work was to change the user.metaWeblog.blogid preference to a String, not an int, and to use the category I wanted to post to as the value for that preference. Change that in opml.root. blojsom's MetaWeblog API implementation is based on the MetaWeblog API RFC where it says:

metaWeblog.newPost (blogid, username, password, struct, publish) returns string. The blogid, username, password and publish params are as in the Blogger API.