Date: Sun, 14 Mar 2021 09:47:53 +0000
To: =?utf-8?Q?Alejandro_Rom=C3=A1n?= <alejandro@aroman.sh>
From: Simon Connah <simon.n.connah@protonmail.com>
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Reply-To: Simon Connah <simon.n.connah@protonmail.com>
Subject: Re: Database migrations
Message-ID: 
 <iby1tc2lwHM4X4beq2drQsuRckTwVhESXmQOJAUXbfVyGi3TiHc0QdWM6drJ1fS0mtmFe5UtjslMOECkfBnyoqXLTW7aMHy07tBnFGrol1w=@protonmail.com>
In-Reply-To: <D7AAB6AC-FCCB-4C50-84F6-3E98FF29D35D@aroman.sh>
References: 
 <DZDT1SCFF7_nJRcZylu8tod4dlTmOX1hAuAlselavvkA4HJAFbOUPC_33W7IxDtMdbzQBPYGPN6p0N58SRHjP3D-JuI8CEyRn3xL1VF4t30=@protonmail.com>
 <D7AAB6AC-FCCB-4C50-84F6-3E98FF29D35D@aroman.sh>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/iby1tc2lwHM4X4beq2drQsuRckTwVhESXmQOJAUXbfVyGi3TiHc0QdWM6drJ1fS0mtmFe5UtjslMOECkfBnyoqXLTW7aMHy07tBnFGrol1w%3D%40protonmail.com>
Precedence: bulk

=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90 Original Me=
ssage =E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90=E2=80=90

On Saturday, March 13th, 2021 at 22:04, Alejandro Rom=C3=A1n <alejandro@aro=
man.sh> wrote:

> Hello,
>
> > I was thinking about just having a bunch of SQL files with a version nu=
mber and date and applying them to the database from oldest to newest (with=
 a table storing information for files that have already been processed). D=
oes this sound like a reasonable solution?
>
> It does. Actually, there is a known JS library that does exactly that: Kn=
ex.js (1). It allows you to define your SQL in plain JS (e.g. `knex.schema.=
createTable(=E2=80=98users=E2=80=99, =E2=80=A6)`). It will then keep track =
of which migrations (JS files) have been ran and which need to be run. It s=
tores this metadata in a table called =E2=80=9Cmigrations=E2=80=9D (you can=
 configure the exact name).
>
> (1) http://knexjs.org/#Migrations
>
> Best wishes,
>
> Alejandro

Hi Alejandro,

Thank you for the information. I'll read through the documentation for that=
 as well. Having everything in JavaScript would be quite helpful in the lon=
g run I think but I do like the idea of extensions as well. I'll do some te=
sting and see which option works out best.

Simon.