1 / 17

Agile Database Development

Agile Database Development. Nathan Voxland. You Plan For Your Code To Change. Why Do You Act Like Your Database Doesn’t?. Knee Jerk Reactions:. Plan your Database Up Front Database can only be touched by the anointed DBA ORM/Mapping configuration work- arounds

issac
Download Presentation

Agile Database Development

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Agile Database Development Nathan Voxland

  2. You Plan For Your Code To Change Why Do You Act Like Your Database Doesn’t?

  3. Knee Jerk Reactions: • Plan your Database Up Front • Database can only be touched by the anointed DBA • ORM/Mapping configuration work-arounds • All database access through views and stored procs

  4. Treat Your Database Like Your Code • Build the simplest thing that can possibly work • Refactor • Test changes • Version Control • Branches • Maintainable

  5. The Key to Agile Database Development: Source Control

  6. RedgateSql Compare Compares and Synchronizes SQL Schemas

  7. ActiveRecord::Migration Tracks the current version of the database in the database

  8. LiquiBase The Perfect Solution 

  9. Store All Changes in VCS

  10. What Kind of Changes? • All Changes • New Tables • Modifications to Tables • Reference Data

  11. Database Tracks Executed Changes

  12. Lots of Execution Tricks • Update • UpdateSQL • UpdateCount • Rollback • FutureRollbackSQL • GenerateChangeLog • Tag • DBDoc • Diff

  13. Lots of Changelog Flexibility • Database Independence • Modular Changelogs • Contexts • Parameters • Preconditions • Complex Refactorings • Custom Changes

  14. Questions? http://liquibase.org

More Related