Update columns in sqlite [Apr 01]

Discord-Discussions
1

:raising_hand_man: nosada asked

Is there a way to add new choices to a MultiSelect column after it has been created? Clicking Edit for the said column shows the screenshot. The link leads to GitHub - nocodb/nocodb: 🔥 🔥 🔥 Open Source Airtable Alternative; does this mean adding new choices requires an external database? If so, why are we able to create choices initially without one?

image0

2

:raising_hand_man: wkw replied

column update in sqlite is complicated hence we don’t support alter column. (We have to recreate entire table with a temporary table)

3

:raising_hand_man: wkw replied

nevertheless, we provide some docker-compose sample files for you to hv a quick start.

https://github.com/nocodb/nocodb/tree/develop/docker-compose

4

:raising_hand_man: nosada replied

Thanks. Does that mean I can switch to MariaDB and have column updating work?

5

:raising_hand_man: wkw replied

yep. as long as not sqlite.

6

:raising_hand_man: nosada replied

Alright, thank you

7

Autogenerated from discord

Join NocoDB’s community

Discord • Twitter • Reddit • Docs