Prod setup [Jan 22]

:raising_hand_man: walls00000 asked

Hello, I’m currently using xmysql to proxy rest API requests to query my remote mysql database which gives me the ability to include database queries in Postman API tests. I’m looking at the documentation and I see the REST APIs section which looks like it will suit my needs. My question is about my use case with nocodb. When I search for a setup scenario that resembles my use case I see the “Production Setup”, but I don’t see an explanation of what “Production Setup” means. From what I gather the Production Setup is using a remote database for nocodb to do its job and not proxy requests to that database. Am I correct? I want to be sure that nocodb will not use my remote db for its own operation. This is the implementation I’m looking at in the “Production Setup”: ```docker run -d -p 8080:8080 \

-e NC_DB=“mysql2://host.docker.internal:3306?u=root&p=password&d=d1” \

-e NC_AUTH_JWT_SECRET=“569a1821-0a93-45e8-87ab-eb857f20a010” \

nocodb/nocodb:latest```

:person_tipping_hand: o1lab replied

Yes, that correct. The database in env variable is used for keeping metadata information about the database that you are gonna connect to from the GUI.

:raising_hand_man: walls00000 replied

Thanks for the quick response, does nocodb support my use case?

:person_tipping_hand: o1lab replied

Was not clear on the proxy request you to dB

:person_tipping_hand: o1lab replied

See getting started, it has the arch duagram

:person_tipping_hand: o1lab replied

Diagram

:person_tipping_hand: o1lab replied

NocoDB Documentation - NocoDB

:raising_hand_man: walls00000 replied

[TESTER]-rest_api_request->[LOCAL_NOCODB]->[MY_PRODUCTION_DB_THAT_I_DO_NOT_WISH_TO_CHANGE]

:raising_hand_man: walls00000 replied

I see NC_DB is different from external database. So it seems my use case is supported. I don’t see where to specify the env for the external db. Perhaps I missed something

:raising_hand_man: walls00000 replied

Is there an env variable to set the external database?

:person_tipping_hand: o1lab replied

For now it has to be done via GUI

:person_tipping_hand: o1lab replied

Nocodb is slightly different to xmysql

:person_tipping_hand: o1lab replied

Here we do provide a gui

:raising_hand_man: walls00000 replied

So I need to bring up the GUI in order to set the external database?

:raising_hand_man: walls00000 replied

That adds some steps for me to automate deployment for my use case

:raising_hand_man: walls00000 replied

I would be interested in running this without the GUI if that is possible

:person_tipping_hand: o1lab replied

Sorry that is not possible

:raising_hand_man: walls00000 replied

This claim is false: “Xmysql is now NocoDB”

:person_tipping_hand: o1lab replied

What is your usecase with APIs on the db

:person_tipping_hand: o1lab replied

Fair enough, see your point. I will update it