Database migrations - Mailing list pgsql-novice

From Simon Connah
Subject Database migrations
Date
Msg-id fbpkeeZLFOGdtB9bbncwzbn-sAu-VEIoln2KStvcs7BgYCA3th1QZNffk0fFgaSEHAqSUPK8-Jl3pkqUQjvjcXQ9CRnJ4I2hrZWM9ykEvwY=@protonmail.com
Whole thread Raw
List pgsql-novice
Hi,

I'm building a web app using the Python web framework Flask and I'm curious how I should handle database changes. At
themoment I can just delete everything and load the SQL files but when I launch into production obviously I won't be
ableto do that. Currently all my database stuff is stored in a SQL file. One file for each table and includes stored
proceduresand function definitions. 

I know there are libraries like Alembic but that seems to be for SQLAlchemy and not raw SQL and Flyway seems to require
anexpensive license to allow migration rollback so I'm wondering if anyone can offer some advice? 

If you need more information then please let me know.

Simon.
Attachment

pgsql-novice by date:

Previous
From: Roxanne Reid-Bennett
Date:
Subject: Re: How to create a View of geometry type equals point?
Next
From: Michael Wallach
Date:
Subject: Vacuum Analyze