all-things-risingwave
What are the options/recommendations to track migrations?
Gabriele Cacchioni is looking for recommendations on tools to track migrations, preferably a declarative tool or something similar to Liquibase. Rick Otten mentions various tools he has used or looked at for database migrations, including Python-based, Elixir, Javascript, Ruby, Java, and Perl tools. He also mentions the use of sqitch and custom shell scripts for migrations. Additionally, there is a mention of other tools like yoyo, DBT with the risingwave-dbt plugin, and a golang-based tool from RisingWave.
Ga
Gabriele Cacchioni
Asked on Mar 29, 2024
- Various tools for tracking migrations include:
- Python based:
- Django ORM
- SqlAlchemy with Alembic
- Elixir:
- Ecto
- Javascript:
- Prisma
- Sequelize
- Ruby:
- Active Records
- Java:
- Liquibase
- Flyway
- Perl:
- sqitch
- Python based:
- Other tools mentioned in the discussion:
- yoyo
- DBT with the risingwave-dbt plugin
- Golang-based tool from RisingWave
- Sqitch is recommended for general use cases without an ORM or commercial solution, but it requires Perl expertise for extending functionalities.
Mar 29, 2024Edited by