Connection to the local database during development

0
Hello all,  is it possible to connect to the local database of the app (with an appropriate client) to examine the data in the database? It's about the database that is used when you start the app via "Run local". Or is there another way to examine the data, besides having to create corresponding pages in the app itself?  Thanks for the answers! Many greetings
asked
5 answers
4

Hi,

You can use a local database (you create yourself) for storing your data f.e. postgress or MSSQL instead of the built-in db. This will make it easier to query the db.

Does answer your question?

Kind regards,

Bob

answered
4

In the console pane, you can find a database viewer under Advanced → Show built-in database viewer.

Or you can run another DBMS like SQL server and use their standard tooling.

answered
2

Hi

If you’re looking to get that real PostgreSQL-db (or any kind of database you’d like) feeling in Mendix where you can have dedicated software to actually dive into the database, try following this path: https://docs.mendix.com/howto/data-models/migrating-your-mendix-database

The topic is on migrating your Mendix database, but really it offers you the possibility to set up your own database locally in the configuration. In my case for example: I run pgAdmin v4 and my PostgreSQL db on my local device and I simply put back-ups locally, so I can work with the Acceptance or even Production data to visualize it in my local development environment.

I hope this helps.

Kind regards,

Leander

answered
1

If you choose to use the built-in database, the app must be running locally.  

Then, you can select “Start built-in database viewer” from the Advanced menu on the Console tab (1st screenshot below).  

And the HSQL Database Manager window (2nd screenshot below) will open.  

 

answered
0

The best way to do this is to install postgresql on your laptop. Configure your app to connect to the local postgres in the setting window.

I find the easiest way to run postgres is by using docker compose. You can use the following docker-compose.yml configuration file to start postgres:

version: '3.2'
services:
  db:
    image: postgres
    ports:
      - "5432:5432"
    environment:
      POSTGRES_PASSWORD: mendix
      POSTGRES_USER: mendix
      POSTGRES_DB: pgdev
      

     

 

answered