Working with Select Options [Mar 04]

:raising_hand_man: ofir asked

why i cant add option for select ?

:man_bald: dstala replied

ofir@discord Could you help us with more information on the issue observed?

Also help us with information about your environment. You can open your project, on right top, you will find user icon. Under that menu, click Copy project info

:raising_hand_man: ofir replied

Node: v12.22.6

Arch: x64

Platform: linux

Docker: false

Database: sqlite3

ProjectOnRootDB: true

RootDB: sqlite3

PackageVersion: 0.84.14

:man_bald: dstala replied

On RootDB: sqlite3, single select & multi select column type options can be configured only during creation time.

If you wish to reconfigure them, we recommend to move to a productions setup environment with either MySQL or Postgres configured as RootDB.

GitHub - nocodb/nocodb: 🔥 🔥 🔥 Open Source Airtable Alternative

You can also connect to existing database - if you have one created over MySQL/ Postgres

:raising_hand_man: ofir replied

where option for mysql database?

:man_bald: dstala replied

If you wish to connect to an existing MySQL database,

https://docs.nocodb.com/setup-and-usages/dashboard#connecting-to-external-database

To store its meta-data (configuration and other working parameters), NocoDB uses a root-DB, mapped to SQLite by default. If you wish to change this to MySQL/Postgres, refer details here

https://docs.nocodb.com/getting-started/installation#docker

:man_bald: dstala replied

You setting up nocodb as a node-js project?

:raising_hand_man: ofir replied

yes

:man_bald: dstala replied

ok. to use mysql as your backend instead of sqlite, you can append :mysql to npm command for backend as shown below

cd packages/nocodb

npm install

npm run watch:run:mysql

GitHub - nocodb/nocodb: 🔥 🔥 🔥 Open Source Airtable Alternative

:raising_hand_man: ofir replied

i can do it on current nocodb?

or i need new install?

:man_bald: dstala replied

You can do it with current nocodb installation

Autogenerated from discord


Join NocoDB’s community

DiscordTwitterRedditDocs