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

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

--

--

--

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

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Adding VFX

Real-Time Exchange Payment System Design

Low-Level Caching in Ruby on Rails

Getting started with Computer Vision AI / ML — Tutorial Step 5 of 7: Set up Gravio Coordinator and…

Fluent UI for Bootstrap

How to Consume Any API Easily in Django

The 5 Habits Of Highly Successful Software Engineers

What’s The Difference Between Smoke Testing And Sanity Testing?

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rachela

Rachela

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

More from Medium

Timing Python code with custom with statements

How to Send SMS to Mobile Number using python

Installing Multiple Python Versions on Windows 10

Starting with the basics.