Has anyone used Terraform for provisioning database schema?

• Flyway

  80 7,763 7.2 Java

  Flyway by Redgate • Database Migrations Made Easy.

  

I'm not sure Terraform is the right tool, but there are other tools to work somewhat the same. I've heard good things about https://flywaydb.org/ but haven't used it myself.

• terraform-provider-postgresql

  2 102 10.0 Go

  Discontinued As part of our introduction to self-service publishing in the Terraform Registry, this copy of the provider has been archived, and ownership has been transferred to active maintainers in the community. Please see the new location on the Terraform Registry: https://registry.terraform.io/providers/cyrilgdn/postgresql

  

While HashiCorp did stop working on it and transferred the ownership in November, I can see it's still actively being maintained which is a relief.

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

  

• atlas

  67 4,945 9.8 Go

  Manage your database schema as code (by ariga)

  

There's much better way right now. Atlas is amazing and fills the gap in excellent way. Just learned about it 3 weeks ago and implementing all over the place. This is a devops way to do such stuff https://atlasgo.io/

• bytebase.com

  84 27 9.9 TypeScript

  Source for bytebase.com

  

You can take a look at https://bytebase.com, it has terraform provider for you to manage database connection info and roles (For PG): https://registry.terraform.io/providers/bytebase/bytebase/latest/docs

Suggest a related project