Re:SQLite in Production: Optimizing WAL Mode, Concurrency, a...
by tredre3 on Wednesday July 29, 2026 @01:51PM
(#49100724)
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.
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...