miguelgrinberg

New blog post: Fixing ALTER TABLE errors with Flask-Migrate and SQLite (Patreon)

Published:

2020-07-19 22:17:39

Imported:

2026-06

haven't archived this post yet. have a subscription? use the importer!

Content

In this article and video I show you how to fix the common upgrade and downgrade errors that occur with the SQLite database. I hope it is helpful!

Files

Previews only

Fixing ALTER TABLE errors with Flask-Migrate and SQLite

If you've done any work with SQLite databases you surely know that this database is very limited in terms of making changes to the database schema. When working with a migration framework such as Flask-Migrate, it is common to end up with migration scripts that fail to upgrade or downgrade just because they need to remove or modify a column in a table, something that SQLite does not support.