Hi everyone,
I keep running into situations where I'd like to manage migrations of a Postgres database in my Node-RED projects but existing tooling is centered around files in a filesystem. This node applies database migrations in the same manner as sql
files but with the SQL defined in msg.migrations
. That way the migrations are stored and versioned with the Node-RED flow and self contained.
For disclosure, I used Gemini to get the ball rolling and to make useful documentation.
Seeing as this is my first (public) node, please be gentle with any feedback.