Clickhouse DB Migration Framework

https://github.com/delium/clickhouse-migrator

by arvindkumarc • 6 years ago

29 5 6 years ago

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.

k0t0n0• 6 years ago

Knex

slow_donkey• 6 years ago

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.

CoffeeDregs• 6 years ago

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

hokumguru• 6 years ago

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

Clickhouse DB Migration Framework

Related Stories