CI/CD for database - 2 devops tools for DB versioning and migration | liquibase and flyway

Поделиться
HTML-код
  • Опубликовано: 1 дек 2024

Комментарии • 14

  • @Jubel357
    @Jubel357 6 месяцев назад +3

    Explained very well for a quick difference between the two and how they are used. Thank you.

  • @gatorpika
    @gatorpika 2 месяца назад

    Really well done videos. Went looking for this one, but also watched the Gitlab one and learned a ton.

    • @kanezi
      @kanezi  2 месяца назад

      thanks! I'm glad you found multiple things helpful

  • @rowland_kanu
    @rowland_kanu Год назад +1

    Wow. I discovered this channel today. I'm yet to take my first app to production but im learning a lot already.

    • @kanezi
      @kanezi  Год назад +1

      Welcome aboard! It so fulfilling to help someone! By creating these videos, I learned a lot too!

  • @yormanaguirre8509
    @yormanaguirre8509 Год назад +1

    Really well explained!

  • @skh551
    @skh551 Год назад +2

    Excellent explanation

  • @juanalfonso60
    @juanalfonso60 Год назад +1

    Very good video, can you make a video of your liquibase installation? I had problems installing on my ubuntu 22.04

    • @kanezi
      @kanezi  Год назад

      did you go with steps in their official installation guide?
      docs.liquibase.com/start/install/liquibase-linux.html
      they have Troubleshooting part as well:
      docs.liquibase.com/start/install/liquibase-installation-troubleshooting.html

    • @juanalfonso60
      @juanalfonso60 Год назад

      @@kanezi yes the same but I get an error that it can't find the postgresql jar in the temporary folder

    • @kanezi
      @kanezi  Год назад

      liquibase installation should come with postgresql.jar driver in liquibase/internal/lib
      if it's not there, try to download postgres driver from:
      jdbc.postgresql.org/download/
      and put it into liquibase/lib folder.
      Also check your liquibase.properties file in your project.
      You can set "classpath" key to point to database jar - maybe it points to non existing temporary folder?

  • @rafaeel731
    @rafaeel731 2 месяца назад

    A view in Postgres can be difficult to change if it is used in other views, so is it always deemed "repeatable"?

    • @kanezi
      @kanezi  2 месяца назад

      "repeatable" in context of migration tools refers to soft database objects that can be created multiple times, like views, triggers and procedures. if you have complex dependency graph between database objects, scripts for views are still repeatable, but you'll have to be careful that you order your scripts correctly so that migration leaves db in valid state. When you change view specification, you'll have to change scripts for all dependent objects too