Available JHipster database types for JDL

You want to generate an application via JHipster, but you require to understand what database types are possible

Sample jdl with database type definition

application {
config {
...
clientFramework angular
      databaseType sql
devDatabaseType h2disk
prodDatabaseType postgresql
      ...
}
}

You can find all current supported database types in github in the typescript file database-types.ts

For what are the 3 configurations used?

the both devDatabaseType and prodDatabaseType are more or less obvious. Dev is used during you are using the build profile development (dev), which is ment to use in your IDE or locally on your development environment. Prod is ment to be used on production, where your software will be used on the live environment/production environment.

Available database types

Depending of what type of persistency you require, you have full support in JHipster for following databases. As of end of 2022 we are having:

• no
  no database at all required, e.g. for a pure calculation and statesless service
• sql
  any other SQL database, which is not listed below, try to avoid this, since you will very probably face SQL dialect issues!
• h2Memory
  the embedded SQL database H2database without persistency (only in memory) and all data will be lost after stopping your application
• h2Disk
  the embedded SQL database H2database with disk persistency, so no data will be lost after ending your application
• mysql
  using a external standalone SQL database MySQL
• mariadb
  using a external standalone SQL database MariaDB
• postgresql
  using a external standalone SQL database PostgreSQL, if you are unsure which SQL database to use, this is a good starting
• mssql
  using a external standalone SQL database Microsoft SQL Server
• oracle
  using a external standalone SQL database Oracle DB
• mongodb
  using a external standalone noSQL database MongoDB
• cassandra
  using as a external standalone or embedded noSQL database Apache Cassandra written in Java
• couchbase
  using a external standalone noSQL database Apache Couchbase written in Erlang
• neo4j
  using a external standalone graph database neo4j

Related articles

Available JHipster build tool types for JDL
Available JHipster authentication types for JDL
Available JHipster application types for JDL
Available JHipster client framework types for JDL
Available JHipster cache provider types for JDL