Clickhouse DB Migration Framework

github.com

29 pointsarvindkumarc5 comments

BTW, does anyone know a good migration library for nodejs/typescript?

I was looking for one some months ago and kind of settled with Typeorm migrations but I don't like them that much. It feels clunky and doesn't seem to provide tooling for saving the schema. Little things that annoy me are the timestamp names for the migrations and the needless "extend this base class for your migration" Java cargo-culting which feels so weird in JS/TS.

Knex

We've used Knex and it works well provided you don't need features such as repeatable migrations.

Imo you should actually differentiate your migrations between schema changes and data mutations. That allows you to use a more powerful tool like liquibase/flyway for schema yet use your preferred language (JS/TS) for data mutations which might need other libraries.

I'm curious if people have tried this approach before.

Random: just don't use Bookshelf (ORM, based on Knex) unless you evaluate it well: when we used it, it did individual SELECTs for any included, related rows...

Prisma is really great . I’ve used it for a year or so with resounding success.

Reply on news.ycombinator.com