public inbox for [email protected]
help / color / mirror / Atom feedFrom: Simon Connah <[email protected]>
To: [email protected] <[email protected]>
Subject: Database migrations
Date: Fri, 28 Jun 2024 10:26:09 +0000
Message-ID: <fbpkeeZLFOGdtB9bbncwzbn-sAu-VEIoln2KStvcs7BgYCA3th1QZNffk0fFgaSEHAqSUPK8-Jl3pkqUQjvjcXQ9CRnJ4I2hrZWM9ykEvwY=@protonmail.com> (raw)
Hi,
I'm building a web app using the Python web framework Flask and I'm curious how I should handle database changes. At the moment I can just delete everything and load the SQL files but when I launch into production obviously I won't be able to do that. Currently all my database stuff is stored in a SQL file. One file for each table and includes stored procedures and 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 an expensive 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.
Attachments:
[application/pgp-signature] signature.asc (249B, ../fbpkeeZLFOGdtB9bbncwzbn-sAu-VEIoln2KStvcs7BgYCA3th1QZNffk0fFgaSEHAqSUPK8-Jl3pkqUQjvjcXQ9CRnJ4I2hrZWM9ykEvwY=@protonmail.com/2-signature.asc)
download
view thread (7+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Database migrations
In-Reply-To: <fbpkeeZLFOGdtB9bbncwzbn-sAu-VEIoln2KStvcs7BgYCA3th1QZNffk0fFgaSEHAqSUPK8-Jl3pkqUQjvjcXQ9CRnJ4I2hrZWM9ykEvwY=@protonmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox