Question

Run Locally - See Database tables, change database

0

Hello! Which tool should I use to see were the data is stored in HSQL database when I do “Run locally”? In my app there is obviously some data stored, but when I open in SQL-Workbench (a free tool), I cannot see any databases in PUBLIC scheme. And second question, can I change the database e.g. to SQL Server, when I run Locally? Regards, Raimund

asked 2020-10-19

Raimund Neumüller

3 answers

Ronald Catersels · Answer 1 · 2020-10-19

For your first question use: http://hsqldb.org/

For your second question:

It is best to run Postgres locally. See documentation here: https://docs.mendix.com/howto/data-models/migrating-your-mendix-database#3-using-your-postgresql-database-in-studio-pro

Regards,

Ronald

Raimund Neumüller · Answer 2 · 2020-10-19

To question 1:

What is the username and password to open a Mendix HSQL db?
With the Mendix admin password it does not work (username MxAdmin, mendix)-

Michiel Arts · Answer 3 · 2020-10-20

Is there a specific need to access the database directly?

In Mendix it is reguilar practice to just add data grids or overview pages for any database table you want to view the contents of. Rightclick on an entity in the domain model and select “generate overview page”.