Changing project id [May 02]

[NocoDB]

[dummy title body text appended to avoid empty title body]

[NocoDB]

wkw replied

if NC_DB is defined, then your meta data will be stored the DB u defined. otherwise, we ll create a sqlite db for u

[NocoDB]

wkw replied

when u create a project, are u connecting to the same postgres database?

[NocoDB]

Shard replied

```

nocodb:

image: nocodb/nocodb:0.90.8

container_name: nocodb

environment:

- NC_DB=pg://postgres:${POSTGRES_PORT}?u=${POSTGRES_USER}&p=${POSTGRES_USER_PASSWORD}&d=nocod

- NC_PUBLIC_URL=https://data.${DOMAIN}

depends_on:

- postgres

labels:

- “traefik.enable=true”

- “traefik.http.routers.nocodb.entrypoints=websecure”

- “traefik.http.routers.nocodb.rule=Host(data.${DOMAIN})”

- “traefik.http.routers.nocodb.tls=true”

restart: always

```

[NocoDB]

Shard replied

This is my docker-compose for nocodb

[NocoDB]

wkw replied

ya this s fine. i wanna know where your data database is

[NocoDB]

Shard replied

Where is that configured?

[NocoDB]

wkw replied

when u create a project

[NocoDB]

wkw replied

which option u choose?

[NocoDB]

Shard replied

First option

[NocoDB]

Shard replied

should I be using the second?

[NocoDB]

wkw replied

if u r using first one, then your data will be stored in NC_DB

[NocoDB]

Shard replied

ok so that is why for example nocodb “system” tables and my own tables are in the same place?

[NocoDB]

wkw replied

oh i can reproduce your issue now

[NocoDB]

wkw replied

the prefix s added when u create a projecto n NC_DB

[NocoDB]

Shard replied

yeah seems so. As I just created a table on external database and that did not get the prefix

[NocoDB]

wkw replied

so it should be same behaviour - not related to migration

[NocoDB]

wkw replied

lemme check with the team n get back to u later

[NocoDB]

Shard replied

I guess that kind of makes sense. I think I will start using external database for user data anyways. Seems like a smarter choice.

[NocoDB]

wkw replied

ya better separate them