View H2 in-memory database

Hello, I’d like to ask if there is any way of viewing the company, contact & status databases from the vaadin course.
I mean, not just viewing the info via de webApp, but also through Intellij.

H2 also has a file mode

jdbc:h2:~/test

this will store the database in your user home directory

That way the data will be there even the app does not run

Checkout the docs: Features

nice - didn’t knew that!

h2 even has a server mode like a “real” database

Please don’t spread it, people gonna use it in production :grimacing:

ouch! won’t do that :smile:

Hello, I am trying to connect to “jdbc:h2:~/test” but I only managed to create an empty db. Could anyone please help me?