Can I Add or Modify a Column in an Existing Table with SQLAlchemy?

Rachela
Jul 23, 2021

The answer is not easily. If you want to modify/add a column in a single, table, the best thing to do is modify your table within the database. For example, click here to see how to add a column in SQLite: https://stackoverflow.com/questions/4253804/insert-new-column-into-table-in-sqlite

The other way is to get into SQLAlchemy migration and not practical for small-scale table modifications: https://sqlalchemy-migrate.readthedocs.io/en/latest/index.html

--

--

Rachela

I am a librarian and new computer programmer creating an app with Python and Kivy to document the plants in my garden.