Ask HN: How do you version control your database schema changes?

by iio7on 1/21/2023, 1:49:10 AM with 5 comments
  • by hardwaresoftonon 1/21/2023, 2:38:33 AM

    As part of code that runs when the application runs.

    Always write migrations that can be adopted gradually, and always use transactions where possible.

    RIP to those not using Postgres who can’t use DDL in transactions.

  • by sargstuffon 1/21/2023, 2:32:03 AM

    command line script method:

    1) Get/select the structre/definition for table(s) in given schema/database via comand line script. Exact way to do this varies by database (mysql, pgsql, informix, oracle, etc)

    2) upload/check in info from #1 to version control system.

    edit per hardwaresofton note about DDL in transactions (way noted below is still a RIP, just less so than 'manual' DDL extraction):

    Always old school script(s) to extract/display relevant schema/database DDL changes from transactional log in source control format.

    This does assume that full/complete transaction log is available to parse.

  • by amalgamated_incon 1/21/2023, 2:06:50 AM

    Check in the migrations

  • by Minor49eron 1/21/2023, 3:05:57 AM

    Migrations, typically via Phinx for PHP

  • by johngon 1/21/2023, 1:50:22 AM

    Mysqldump and rdiff-backup