3 ms·
SQLite supports ALTER TABLE: https://www.sqlite.org/lang_altertable.html https://www.sqlite.org/lang_altertable.html On Go you can embed your migrations in y
by yomismoaqui 3mo ago
SQLite supports ALTER TABLE:
https://www.sqlite.org/lang_altertable.html 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-migrations/ https://oscarforner.com/blog/2023-10-10-go-embed-for-migrati...
- tredre3 3mo agoALTER 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.