Meta db & data db [Mar 25]

[NocoDB]

dpg asked

and does hitting “create project” (as opposed to “create by connecting to an external database”) create a database on that backing postgres?

[NocoDB]

wkw replied

pls check this out

Welcome | NocoDB

[NocoDB]

dpg replied

ahhh missed that somehow thanks

[NocoDB]

wkw replied

it is possible to use the same db to store your metadata and data.

[NocoDB]

wkw replied

however, normally people would put them into separate dbs

[NocoDB]

dpg replied

Yeah I can understand why that would be

[NocoDB]

dpg replied

I am wondering, is there a way once I’ve set it up to see what database nocodb is using for the meta?

[NocoDB]

wkw replied

you can check your project info

[NocoDB]

wkw replied

See FAQs | NocoDB

[NocoDB]

dpg replied

because deploying via fly just not sure if it has received the connection details or not. OK thanks will do

[NocoDB]

wkw replied

Node: v16.14.0

Arch: arm64

Platform: darwin

Docker: false

Database: pg

ProjectOnRootDB: false

RootDB: mysql2

PackageVersion: 0.84.15

you should see sth like this. RootDB is the meta db while Database is the data db

[NocoDB]

wkw replied

if you haven’t specified your meta db (i.e. NC_DB), then sqlite will be used.

[NocoDB]

dpg replied

Node: v12.22.10

Arch: x64

Platform: linux

Docker: false

Database: pg

ProjectOnRootDB: true

RootDB: pg

PackageVersion: 0.84.15

[NocoDB]

dpg replied

wow ok, impressive. fly.io deployment is pretty straightforward then

[NocoDB]

dpg replied

I just deployed the image and it recognised to create a postgres database. then populated DATABASE_URL env for me, and apparently its all hooked up already!

[NocoDB]

o1lab replied

[NocoDB]

wkw replied

cool

[NocoDB]

o1lab replied

do they 've a 1-click button to deploy ?

[NocoDB]

o1lab replied

like heroku

[NocoDB]

dpg replied

1 command ? almost