Update columns in sqlite [Apr 01]

: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?


: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)

:raising_hand_man: wkw replied

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

nocodb/docker-compose at develop Β· nocodb/nocodb Β· GitHub

:raising_hand_man: nosada replied

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

:raising_hand_man: wkw replied

yep. as long as not sqlite.

:raising_hand_man: nosada replied

Alright, thank you

Autogenerated from discord

Join NocoDB’s community

Discord β€’ Twitter β€’ Reddit β€’ Docs