Deploying/Managing DDL

• migra

  25 2,861 0.0 Python

  Like diff but for PostgreSQL schemas

We use migra to generate migration DDL, manually modify it as needed (it tends to be overeager to drop and create tables), use migra again to ensure old DDL + migration DDL == new DDL, attach the migration DDL to the PR, and manually run it after the PR's been reviewed and merged. I wouldn't say I love our process, but I like the simplicity and it hasn't been a pain point.

• dbmate

  25 4,321 7.9 Go

  :rocket: A lightweight, framework-agnostic database migration tool.

We use dbmate to create and run migrations upon code deployment. Each migration file is saved with a timestamp, so it's not too difficult to go back in time and see what was changed when.

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

Suggest a related project