emsu asked
dstala replied
emsu@discord Can you share more details about your project environment?
https://www.youtube.com/watch?v=AUSNN-RCwhE
There are 3 ways to create project over NocoDB.
https://docs.nocodb.com/setup-and-usages/dashboard#initialize-your-first-project
(1.) Creating empty project
(2.) Connecting to external database
(3.) Creating project from Excel
(1) and (3) use a local SQLite for creating tables (NC_DB). For tables created here- NocoDB adds prefix to help differentiate between tables created across different NocoDB projects. This can’t be chopped off.
If you create a new project using option (2), any new tables added to the project will be stored using same name without any explicit prefix in the external database specified.
Hope this helps!
I created a second database to connect as an external database on Heroku and provided the correct credentials, but even though I made it SSL Required, I’m getting an error: Connection Failure:no pg_hba.conf entry for host “3.91.7.219”, user “uvqrgmzayrfxwj”, database “dc7hl10mhflk22”, SSL off
This helps though. I guess I want to use the 2nd option. Although with option 1 with heroku it created it in postgres instead of a sqlite db
Open app on Heroku. Open any project that you have created on NocoDB. On right top corner, you will find “User icon”. It has “Copy Project Info” as one of sub-menu options.
On Heroku, yes- you are right. It uses PG as RootDB [NC_DB]
o1lab replied