Which database to choose for a home use web application (Java)?

Question

Java

I want to practice web development and do something useful at the same time. In the sociological survey among households, the cookbook was in the lead.
Keystones:

• work in the browser
  
• using Spring
  
• using a modern database
  
• minimizing user gestures to launch
  

The last two questions are related to the fact that previously you had to work only with unfashionable Access and cumbersome MySQL and Sybase ASE servers that you need to raise for the application to work - which is unacceptable in the current case.
Tell me, please, is it possible to implement the project in this form and which database to choose. So far, I'm looking towards SQLite.
Also I would be grateful for additional advice and comments.

Answer 1

You can also try H2 ( https://ru.wikipedia.org/wiki/H2 feature description)
1 +
2 +
3 +
4 +
It is extremely fast (in-memory mode), good for prototyping, easy to run, migrations can automatically roll over (those flexibility when changing the data schema).
True, if the project ceases to be "home" it will no longer work, but that's a completely different story.

Answer 2

God, what do people say. Use postgreSQL, lightweight and fast. Experience on it will be very useful. All other answers are almost never used in real projects except oracle, but it is very heavy for home use.

Answer 3

Well SQLite - basically norms. But what for in general in the culinary book of a DB? You can completely get by with some thread JSON-configs.

Answer 4

What about the built-in databases that spring supports: h2, hsql, derby? It is simple and unnecessary to raise your server. Embedded database support
Specify the following in the spin config file:

<jdbc:embedded-database id="dataSource" type="HSQL">
    <jdbc:script location="classpath:scheme.sql" /
</jdbc:embedded-database>

and you will get hsql subd and datasource to it.
scheme.sql - here is the sql that creates the database schema.

Answer 5

You can use Firebird embedded www.firebirdfaq.org/faq350

Answer 6

MySQL with a head would be enough, also for a cookbook. Servers with thousands of users are handled by MySQL, WoW server examples.

Answer 7

Try Oracle Express Edition 11g completely free version incl. for corporate use
www.oracle.com/technetwork/articles/sql/11g-xe-qui...
There are true limitations
Oracle Database XE can be installed on any size host machine with any number of CPUs (one database per machine), but XE will store up to 11GB of user data, use up to 1GB of memory, and use one CPU on the host machine.