Live data from Hacker News

Clickhouse DB Migration Framework

github.com

1–7 of 7 posts

Re: Clickhouse DB Migration Framework

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

Re: Clickhouse DB Migration Framework

#4

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 fee…

Knex

Re: Clickhouse DB Migration Framework

#5
post #4

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 fee…

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.

Re: Clickhouse DB Migration Framework

#6

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 fee…

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

Re: Clickhouse DB Migration Framework

#7
post #4

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 fee…

Knex

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