Database targets?

[Migrated From Jforum.net]

What databases are targeted for JForum, including version? The reason I ask is I'm looking into what it would take to use Hibernate and at least the reverse engineering part of Hibernate really wants primary/foreign key contraints. In general I feel that this is the way to build a database anyway.

However, MySQL 3.x does not support this and I don't know about Hypersonic. Real databases do but I'm guessing that there are one or two users still on MySQL :lol:

So what databases are in use? How difficult would it be to have a different install script for MySQL 3.x vs. newer versions? Is this even desired?
[originally posted on jforum.net by stdunbar]

[Migrated From Jforum.net]

Hypersonic (SQLDB) does have Foreign keys and several other kind of constraints, and can be used successfully with Hibernate. I should know as I have a couple of projects running under that configuration ;).

Regarding the reengineering of JForum to use that, Rafael should have more knowledge about it but from what I saw, it would be a total rebuild of JForum internals so it should be done with him for a new and renovated version, that would take a while to do, or the result would be a fork that would drift quite apart from the original so they would not quite be able to benefit from each other advancements.

I'm in the process now, well when I come back from holidays, of developing another implementation of a forum, focused on private forums with more control and less "public forum" features like avatars, ranks, and the like, and I'm doing it with Hibernate + Oracle/HSQLDB, and yes, the internals are quite different so quite an extensive rewrite would be needed.

My 2ec
[originally posted on jforum.net by GreenEyed]