Re:I’m done with the web
by npsimons on Thursday March 21, 2013 @12:54PM
(#5416678)
I noticed that the fully native Java was a big selling point on H2. Admittedly, I'm not doing much Java these days (slight understatement), but I was under the impression that the Java interfaces to SQLite were fairly mature? Top two links in Google go to a very informative SO answer with lots of options and SQLJet. Bad sign though that "apt-cache search sqlite | grep -i java" gives no results on Debian stable. I'll grant that fully native Java is a compelling reason in some use cases ;) I'm now curious what they use for SQLite on Android, as I know fairly well that it's used all over the place there.
[ Parent
| on HN ]
H2, more than anything else, is great for testing. It can emulate oracle and DB2 syntax, among others, to allow us to reasonably approximate a running system on our own machines, then test against the big database (which is much slower) at a later stage.
Fully native java and an in-memory implementation mean that we can very quickly implement it in our systems.
Re:I’m done with the web
by markokrajnc on Thursday March 21, 2013 @02:34PM
(#5417695)
I second this. We use H2 in our JUnit test cases a lot, because it is the fastest open-source in memory Java DB (tests are finished very fast).