Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.60.0.2.21\))
Subject: Re: Database migrations
From: =?utf-8?Q?Alejandro_Rom=C3=A1n?= <alejandro@aroman.sh>
In-Reply-To: 
 <DZDT1SCFF7_nJRcZylu8tod4dlTmOX1hAuAlselavvkA4HJAFbOUPC_33W7IxDtMdbzQBPYGPN6p0N58SRHjP3D-JuI8CEyRn3xL1VF4t30=@protonmail.com>
Date: Sat, 13 Mar 2021 17:04:55 -0500
Cc: "pgsql-novice@lists.postgresql.org" <pgsql-novice@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <D7AAB6AC-FCCB-4C50-84F6-3E98FF29D35D@aroman.sh>
References: 
 <DZDT1SCFF7_nJRcZylu8tod4dlTmOX1hAuAlselavvkA4HJAFbOUPC_33W7IxDtMdbzQBPYGPN6p0N58SRHjP3D-JuI8CEyRn3xL1VF4t30=@protonmail.com>
To: Simon Connah <simon.n.connah@protonmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/D7AAB6AC-FCCB-4C50-84F6-3E98FF29D35D%40aroman.sh>
Precedence: bulk

Hello,

> 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?

It does. Actually, there is a known JS library that does exactly that: =
Knex.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 stores 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