5 ms·

Embedded databases where the db is a single file are the bomb. We build several products in Java using H2 as our database. What a pleasure. Full SQL support, z

• xrendan 6y ago
  This is my first time hearing about H2, what's the benefit of H2 over sqlite?
  • mmcdermott 6y ago
    I think the big one is that it's written in Java so it runs seamlessly on the JVM. While JNI allows you to wrap native libraries for the JVM, it tends to mix poorly with the common artifact management and deployment pipelines. The main use I've put it to over the years is as an in-memory database for integration tests.
  • mbreese 6y ago
    Derby is/was the other alternative for an in JVM database. For a long time, it was possible/practical to use SQLite from Java. Now, it is, but not if you want to keep things as pure Java (and another commenter mentioned). But really, in my mind, that’s the only real benefit for H2, the fact that’s it’s pure Java. So if you need that, you’re good. But otherwise, I try to stick to SQLite.
    • bobthebuilders 6y ago
      I mean H2 is only really useful in Java, but the perf compared to sqlite in Java is equal or better due to better JDBC integration and not having to deal with JNI.
  • OOPMan 6y ago
    It integrates better with JVM