Date: Fri, 28 Jun 2024 10:26:09 +0000
To: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.org>
From: Simon Connah <simon.n.connah@protonmail.com>
Subject: Database migrations
Message-ID: 
 <fbpkeeZLFOGdtB9bbncwzbn-sAu-VEIoln2KStvcs7BgYCA3th1QZNffk0fFgaSEHAqSUPK8-Jl3pkqUQjvjcXQ9CRnJ4I2hrZWM9ykEvwY=@protonmail.com>
Feedback-ID: 24074989:user:proton
MIME-Version: 1.0
Content-Type: multipart/signed; protocol="application/pgp-signature";
 micalg=pgp-sha512;
 boundary="------2b758f0942f1ed4b95295e83ca6b76c6008bd55513da1776784e1e5e448cb09f";
 charset=utf-8
Archived-At: 
 <https://www.postgresql.org/message-id/fbpkeeZLFOGdtB9bbncwzbn-sAu-VEIoln2KStvcs7BgYCA3th1QZNffk0fFgaSEHAqSUPK8-Jl3pkqUQjvjcXQ9CRnJ4I2hrZWM9ykEvwY%3D%40protonmail.com>
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--------2b758f0942f1ed4b95295e83ca6b76c6008bd55513da1776784e1e5e448cb09f
Content-Type: multipart/mixed;boundary=---------------------30a0ae55532813e02a90d4c0b34cfd60

-----------------------30a0ae55532813e02a90d4c0b34cfd60
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;charset=utf-8

Hi,

I'm building a web app using the Python web framework Flask and I'm curiou=
s how I should handle database changes. At the moment I can just delete ev=
erything and load the SQL files but when I launch into production obviousl=
y 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 fu=
nction definitions.

I know there are libraries like Alembic but that seems to be for SQLAlchem=
y and not raw SQL and Flyway seems to require an expensive license to allo=
w migration rollback so I'm wondering if anyone can offer some advice?

If you need more information then please let me know.

Simon.
-----------------------30a0ae55532813e02a90d4c0b34cfd60--

--------2b758f0942f1ed4b95295e83ca6b76c6008bd55513da1776784e1e5e448cb09f
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: ProtonMail

wnUEARYKACcFgmZ+j7QJkFrvKC74ta6lFiEEXOYF9uqFRn4815bYWu8oLvi1
rqUAABR0AP9M53CSx61vQtnRB2df7k/KVUdBaMH/l/yhmI8D36rCGQEAr+Yd
Odvq7TMoAs1/ivc5W77bqCoXUL+O6NNU0yNzXgc=
=bz6H
-----END PGP SIGNATURE-----


--------2b758f0942f1ed4b95295e83ca6b76c6008bd55513da1776784e1e5e448cb09f--