Database in Mendix

0
Am new to Mendix and working on some POCs. I find that accessing the database(within Mendix) is quite difficult where I can only access it after starting the process and query and adding values to it manually is almost impossible.    Is this true or am I making some mistake?
asked
3 answers
1

Hi Gokul, You're not wrong — it can feel a bit tricky at first. In Mendix, you can't directly access the database like in traditional setups (e.g. writing SQL manually). The data gets stored in Mendix's internal DB, and the usual way to add or view data is through pages or microflows you've built in the app.

Also yeah, the DB is only "active" when the app is running. If you're trying to test something, you'll usually need to:

  • Start the app locally

  • Use a form or microflow to create some test data

  • Or, if it's really needed, you can open the built-in database viewer from the console (only works locally) to look at the data tables

Once you get the hang of it, it becomes more manageable. For POCs, I usually just build a quick page with a simple data grid and a form to create and edit objects — helps a lot when you're trying to test things quickly.

Hope that helps!

answered
0

Check out some learning paths instead of figuring everything out from scratch.

Also, you can right click an entity in the domain model and generate overview pages to quickly get started on creating and editing records.

answered
0

For development you dont need to use the internal database. You can also configure your app to use another database like postgres, sql-server or oracle. Yo can do this in your project settings. Using a database server like this will allow you to also connect to it using other tools like dbeaver or datagrip.

answered