Questions and answers
- Should we automate the manual steps of creating the database?
Yes. This is an important part of DevOps, where we developers are responsible for getting the code into production and keeping it running there. The key technique is Infrastructure as Code (IaC), which means automating manual steps as code that we check in to the main repository.
- What tools can help with automating database creation?
Popular tools are Flyway and Liquibase. Both allow us to write scripts that are run at application startup and will migrate the database schema from one version to the next. They assist in migrating data across schema changes where that is required. These are outside the scope of this book.
- What tools can help with installing the database?
Access to a running database server is part of platform engineering. For cloud-native designs that run on Amazon Web Service, Microsoft Azure, or Google Cloud Platform, use configuration scripting...