MIME-Version: 1.0
References: 
 <DZDT1SCFF7_nJRcZylu8tod4dlTmOX1hAuAlselavvkA4HJAFbOUPC_33W7IxDtMdbzQBPYGPN6p0N58SRHjP3D-JuI8CEyRn3xL1VF4t30=@protonmail.com>
In-Reply-To: 
 <DZDT1SCFF7_nJRcZylu8tod4dlTmOX1hAuAlselavvkA4HJAFbOUPC_33W7IxDtMdbzQBPYGPN6p0N58SRHjP3D-JuI8CEyRn3xL1VF4t30=@protonmail.com>
From: Steve Baldwin <steve.baldwin@gmail.com>
Date: Sun, 14 Mar 2021 10:19:35 +1100
Message-ID: 
 <CAKE1Aiaugj0qJsx6rTaTiB67bWdgSvK5ZvsV9=7UHag61tJ1UQ@mail.gmail.com>
Subject: Re: Database migrations
To: Simon Connah <simon.n.connah@protonmail.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000db1a1905bd734057"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKE1Aiaugj0qJsx6rTaTiB67bWdgSvK5ZvsV9%3D7UHag61tJ1UQ%40mail.gmail.com>
Precedence: bulk

--000000000000db1a1905bd734057
Content-Type: text/plain; charset="UTF-8"

Hi Simon,

Another option (and the one we use) is a tool called flyway -
https://flywaydb.org/. There is a free community edition, and it is pretty
comprehensive. There are docker images you can use during ci.

Flyway supports versioned (run once) migrations, repeatable (run when
changed) migrations, and a bunch more.

Other than being a user of the community edition, I have no association
with flyway.

Cheers,

Steve

On Sun, Mar 14, 2021 at 8:40 AM Simon Connah <simon.n.connah@protonmail.com>
wrote:

> Hi,
>
> I'm sorry if this is a rather stupid question but I'm fairly new to
> databases and was wondering if anyone could offer some advice?
>
> I have an app I am developing using Node.js and PostgreSQL 13.2. I have
> the basic tables I want to start with but I know that as development
> progresses change is going to be required. Since this is an open-source
> project people are going to want to upgrade from one version to the next
> and that might require changes to the database structure. What is the best
> way to handle this?
>
> I was thinking about just having a bunch of SQL files with a version
> number and date and applying them to the database from oldest to newest
> (with a table storing information for files that have already been
> processed). Does this sound like a reasonable solution?
>
> If not could someone point me in the right direction, please?
>
> Thank you for your help.
>
> Simon.
>
>
>
>
>

--000000000000db1a1905bd734057
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi Simon,</div><div><br></div>Another option (and the=
 one we use) is a tool called flyway -=C2=A0<a href=3D"https://flywaydb.org=
/">https://flywaydb.org/</a>. There is a free community edition, and it is =
pretty comprehensive. There are docker images you can use during ci.<div><b=
r></div><div>Flyway supports versioned (run once) migrations, repeatable (r=
un when changed) migrations, and a bunch more.</div><div><br></div><div>Oth=
er than being a user of the community edition, I have no association with f=
lyway.</div><div><br></div><div>Cheers,</div><div><br></div><div>Steve</div=
></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr"=
>On Sun, Mar 14, 2021 at 8:40 AM Simon Connah &lt;<a href=3D"mailto:simon.n=
.connah@protonmail.com">simon.n.connah@protonmail.com</a>&gt; wrote:<br></d=
iv><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;bord=
er-left:1px solid rgb(204,204,204);padding-left:1ex">Hi,<br>
<br>
I&#39;m sorry if this is a rather stupid question but I&#39;m fairly new to=
 databases and was wondering if anyone could offer some advice?<br>
<br>
I have an app I am developing using Node.js and PostgreSQL 13.2. I have the=
 basic tables I want to start with but I know that as development progresse=
s change is going to be required. Since this is an open-source project peop=
le are going to want to upgrade from one version to the next and that might=
 require changes to the database structure. What is the best way to handle =
this?<br>
<br>
I was thinking about just having a bunch of SQL files with a version number=
 and date and applying them to the database from oldest to newest (with a t=
able storing information for files that have already been processed). Does =
this sound like a reasonable solution?<br>
<br>
If not could someone point me in the right direction, please?<br>
<br>
Thank you for your help.<br>
<br>
Simon.<br>
<br>
<br>
<br>
<br>
</blockquote></div>

--000000000000db1a1905bd734057--