Between using H2 and HSQLDB as a production DB, which is the better choice?

• sqlite-jdbc

  21 2,665 9.1 Java

  SQLite JDBC Driver

• maven-jpackage-template

  40 326 0.0 Java

  Sample project illustrating building nice, small cross-platform JavaFX or Swing desktop apps with native installers while still using the standard Maven dependency system.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• sqlitebrowser

  279 19,896 9.0 C++

  Official home of the DB Browser for SQLite (DB4S) project. Previously known as "SQLite Database Browser" and "Database Browser for SQLite". Website at:

  

I've used all H2, hsqldb and SQLite. For a desktop app you want SQLite, as it is explicitly designed for this scenario. One nice bonus is that there are a TON of apps and utilities that work with SQLite files directly, making it very easy to work with.

Suggest a related project