I can't recommend it for production use though. We deployed H2 in a small-scale project and had some horrible data corruption issues. As far as I understand, H2 is maintained by a single developer.
On 18.09.2011, at 12:59, Pascal Robert wrote: +1 for H2. Not having to install a RDBMS and create a database in it is cool, especially for demos/tutorials. Hi Dan,
If you're going embedded, I would recommend H2 simply based on my experience with it. At home, I'll frequently use H2 to develop with the intention to deploy on Postgres. I figure I keep my database options open this way, because it prevents any stupid temptations to build dependency on a single database. Anyway, I've had no migration problems with H2. I just wish it did deferred FK constraints (^_^)
If you want your H2 db in your resources directory, you can find an example in the ERMoviesLogic framework.
Ramsey
On Sep 17, 2011, at 9:07 PM, Dan Beatty wrote:
Greetings gentlemen, David’s, and members of the Chuck Wagon gang,
I thought I would pick your brains for amount to find out from your experience which of the “stand-alone” databases like Apache Derby, H2, etc play well with Project Wonder’s migration frameworks. I have noticed that Apple’s plugin for MySQL plays poorly, but Ramsey says that Wonder’s MySQL plugin fixes that. Thus, what embedded databases play well with ERMigration and what plugins do I need to make them work? What special URL augmentation is necessary for WO to find such an embedded database in say the Resources directory of a WO application?
Any ideas?
Thank you,
Daniel Beatty
Computer Scientist, Detonation Sciences Branch
Code 474300D
1 Administration Circle M/S 1109
China Lake, CA 93555
email@hidden
(LandLine) (760)939-7097
(iPhone) (806)438-6620
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
|