Wednesday, 23 November 2005
blojsom Database Source Available
« OPML Editor | Main | Thanksmas »
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.
[Trackback URL for this entry]
