I want to have my DB server opensource and capable of saving hystory of record changing. Meaning I do not want it to be way 2 complicated , I'd love to operate with it like with JDOs but with some kind of revision extention... or SQL like DB with extended sintax and search capabiletis... So is out there any such?
views:
47answers:
2
A:
You can look for DBDeploy.
Maintain your sql in versioned on SVN and just use DBDeploy.
org.life.java
2010-10-11 13:29:18
+3
A:
Well, there is a solution backed by Hibernate providing history, it's called Envers, but from what I remember, there are some minor drawbacks.
There also is another solution : JCR. A Java Content Repository is a non-relationnal DB, that is far more compatible with your history needs (as it can use, as an example, a SVN repository as storage back-end). You can take a look at modeshape, as an example.
Riduidel
2010-10-11 13:32:36
Envers is pretty solid these days, and is now part of the main Hibernate project. Definitely worth trying, especially if you're already using Hibernate for persistence.
GaryF
2010-10-11 13:38:46
I'm impressed that you interpreted his question :)
karianna
2010-10-11 13:42:55