{"repo":"aws-samples/rds-db-schema-migrations-cicd","free":true,"listed":false,"github":"https://github.com/aws-samples/rds-db-schema-migrations-cicd","clone":"git clone https://github.com/aws-samples/rds-db-schema-migrations-cicd.git","description":"Integrating RDS databases' schema migrations in the CI/CD pipeline.","language":"TypeScript","stars":32,"topics":["aws-codepipeline","aws-lambda","rds-aurora","postgresql","knexjs","cdk"],"license":"MIT-0","category":"databases-storage","readme_excerpt":"Integrating Database Schema changes in the CI/CD pipeline. Continous delivery strategies are commonly used to increase speed of development and to manage application code changes. However, database changes are often left out of this process and maintained separately, which can become a bottleneck to automated validations as step within CI/CD Pipelines. This project provides an example of how to automate schema changes using AWS Lambda and integrate this step in a CI/CD Pipeline. The solution contains the AWS CDK code for building the infrastructure and the cross-account CI/CD Pipeline. In this example we're deploying an Amazon Aurora PostgreSQL-compatible Serverless edition database. However, the same concept can be applied to other supported RDS Engines. ​ Solution overview The CI/CD pipeline is built using the CDK Pipelines module. The pipeline's source is retrieved from an AWS CodeCommit repository and is triggered upon a push to the default branch. The pipeline contains two stages, the development stage and the production stage. The development stage is configured to deploy resources in the account where the pipeline is deployed. The production stage deployed the resources in another AWS Account. After the resources are deployed / updated, an AWS CodeBuild project is configured to trigger the AWS Lambda function, which runs the schema migrations. ​ ​ ​ Prerequisites ​ Two AWS accounts. AWS CDK installed. Docker installed for the initial deploy. ​ Setup Create a new AWS Co","default_branch":null,"files":null,"tree":[],"storefront":"/r/aws-samples","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/aws-samples/rds-db-schema-migrations-cicd/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}