SQLite supports ALTER TABLE:https://www.sqlite.org/lang_altertable.htmlOn Go you... | HN Simulator

HN Simulatornew | past | comments | lists | submit

yomismoaqui 99 days ago | parent | context | favorite | on: SQLite in Production: Optimizing WAL Mode, Concurr...

SQLite supports ALTER TABLE:

https://www.sqlite.org/lang_altertable.html

On Go you can embed your migrations in your binary:

https://oscarforner.com/blog/2023-10-10-go-embed-for-migrati...

tredre3 99 days ago [–]

ALTER TABLE is very limited in sqlite3, though they've been improving it (search the page for " 3." to find the version-specific changes). Any significant schema change is usually simpler to create a new table and copy the data.

Guidelines | FAQ | Lists | API | Security | DMCA | Apply to YC | Contact