An easy-to-use, zero-downtime schema migration tool for Postgres
Great article! For anybody interested in this topic, I've been working on a schema migration tool which automates zero-downtime migrations using many of the techniques mentioned: https://github.com/fabianlindfors/reshape. It also uses some other incredible Postgres features, like updatable views and schemas.
It was discussed here on HN about a week back: https://news.ycombinator.com/item?id=29825520
Catch unsafe migrations in development
I would suggest taking a look at strong migrations. It's a rails project, but the readme does a great job explaining what it checks for and what safe alternative to use instead. I still link to their explanations in PRs for non-rails projects.
Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
In Node projects, in general I don't recommend using knex.js for data access, but their migrations facility is great.
By default it runs all of your DDL within a transaction, but in some cases where you can't run in a transaction (like adding a value to an enum type) it makes it easy to disable it: https://knexjs.org/#Migrations-API-transactions
When Postgres blocks: tips for dealing with locks
3 projects | news.ycombinator.com | 12 Feb 2022
Closest library/setup/configuration to JOOQ?
5 projects | reddit.com/r/node | 22 Apr 2022
Node.js Database migrations
2 projects | reddit.com/r/learnprogramming | 27 Mar 2022
Type safety problem of Knex query builder
3 projects | reddit.com/r/node | 24 Mar 2022
What database should i use with node.
2 projects | reddit.com/r/node | 26 Nov 2021