Full Stack Development with JHipster

Choosing a database option

JHipster provides support for many kinds of databases, ranging from SQL to NoSQL. The following are some considerations when choosing a DB:

• For most cases, a SQL DB would be more than sufficient, hence if you do not see any reason to go with other NoSQL solutions, stick to SQL and choose from MySQL, Postgres, Oracle, MariaDB, and MS SQL:
  • If you are on an enterprise with Oracle or MS SQL subscriptions, then it would make sense to choose them as you would benefit from the support and enterprise features provided
  • If you need to store and query a lot of JSON data, then Postgres offers the best JSON support with full-text search capabilities
  • For most simple use cases, MySQL or MariaDB will suffice
  • Always choose a second-level ...