My very first adventure after starting using
PersonalBlog was to make this thing work with
PostgreSQL. It worked out of the box with
MySQL but at the time I did not have much knowledge about
MySQL, so I really wanted to make it work with
PostgreSQL.
That should have been easy, since
PersonalBlog uses
Hibernate for object persistence and I should only have had to change a couple of settings in the hibernate.properties file. However as life allways is, not so simple
So I had to get my fingers dirty and dig into the source of PersonalBlog to find why it was not working. The short story is that I found that using
PostgreSQL together with
Hibernate mandates the use of transactions when doing updates of the persisted objects - this is also the recommended way of using
Hibernate since version 2.
Then, why this story? Because reading the source made me aware of a couple of things that I would like to have changed in
PersonalBlog and since I had already a pretty good overview of the code why not make the changes my self?
I did make the changes and have introduced a setup "wizard" that will let the user choose which database to use and then create the hibernate configuration file and create tables in the database and some other stuff. The code is contributed back to the source tree and hopefully will be accepted into the next release of
PersonalBlog . And now
PersonalBlog supports the following databases:
HypersonicSQL,
MySQL and
PostgreSQL and it should be easy supporting others.
And the real reason for this post was to inform, that my own blog is now running on the latest development version of
PersonalBlog .
Opslag
