Liquibase JFall 2011

Introduction to Liquibase at JFall 2011

Transcript

1. Liquibase change databases fluently Daan van Berkel
2. Agenda •Agenda •Introduction •Anecdote •Antidote •Conclusion
3. Introduction •Daan van Berkel ◦ Married ◦ Child •Experience ◦ Luminis ◦ Topicus ◦ Sogyo ◦ Ratio http://www.linkedin.com/pub/daan-van-berkel/b/850/573
4. Anecdote
5. Anecdote Test Production •Testing Environment ◦ Java ◦ Oracle •Production Environment ◦ Java ◦ Oracle
6. Anecdote Test Production Update procedure •Software ◦Version Control ◦Continous Build ◦War •Database ◦Manually Change Test ◦Record in Script ◦Sent Script
7. Anecdote Test Production "Common" Problems •Incomplete Script •Incomplete Installation •Ambiguous State
8. Anecdote
9. Anecdote Test Production It gets worse!
10. Anecdote Test Production Developers work on Test Directly
11. Anecdote Test Production "Common" Problems •Incomplete Script •Incomplete Installation •Ambiguous State •Premature Installation
12. Anecdote Test Production Start using local environment •Common problems ◦Incomplete scripts ◦Incomplete installation •Different DB flavour
13. Antidote
14. Antidote Liquibase an open source, database-independent library for tracking, managing and applying database changes www.liquibase.org
15. Antidote: introduction Liquibase •Changelog •Changeset •Log tables
16. Antidote: introduction Liquibase •Changelog ◦XML ◦Version control •Changeset •Log tables <databaseChangeLog> ... </databaseChangeLog>
17. Antidote: introduction Liquibase •Changelog •Changeset ◦unique (author, id) ◦Semantics •Log tables <changeSet id="1" author="dvberkel"> <createTable tableName="message"> <column name="id" type="bigint"> <constraints primaryKey="true"/> </column> <column name="content" type="varchar"/> </createTable> </changeSet>
18. Antidote: introduction Liquibase •Changelog •Changeset •Log tables ◦databasechangelog ◦databasechangeloglock
19. Antidote: Exploration Supported Databases •Popular Database •Run on JDBC •Extensible http://wordle.net
20. Antidote: Exploration Supported changes •Structure •Quality •Integrity •Transformation
21. Antidote: Exploration Supported changes •Structure •Quality •Integrity •Transformation Structural Refactoring • Add column • Rename column • Modify column • Drop column • Alter sequence • Create table • Rename table • Drop table • Create view • Rename view • Drop view • Merge columns • Stored procedure
22. Antidote: Exploration Supported changes •Structure •Quality •Integrity •Transformation Data quality •Add lookup table •Add/remove constraint ◦not-null ◦unique •Create sequence •Drop sequence •Add auto-increment •Add default value •Drop default value
23. Antidote: Exploration Supported changes •Structure •Quality •Integrity •Transformation Referential Integrity •Add / drop constraint ◦Foreign key ◦Primary
24. Antidote: Exploration Supported changes •Structure •Quality •Integrity •Transformation Transformation •CRUD •Custom
25. Antidote: Demonstration Liquibase
26. Antidote: Evalutation •Database independent •Rich feature set •Process
27. Antidote: Evalutation •Database independent •Rich feature set •Process It was easy to change the underlying database Wide variety in databases is supported
28. Antidote: Evalutation •Database indepent •Rich feature set •Process Great number of possible changes Multiple options if your change is not present
29. Antidote: Evalutation •Database independent •Rich feature set •Process ◦Verifiable ◦Repeatable ◦Reversable Liquibase offers an ubiquitous language for developers and database administrators
30. Antidote: Advanced use-cases •Legacy Database •Keeping DBA's Happy •Integration •Extending Liquibase
31. Antidote: Advanced use-cases •Legacy Database •Keeping DBA's Happy •Integration •Extending Liquibase Liquibase can generate a changelog from an existing database
32. Antidote: Advanced use-cases •Legacy Database •Keeping DBA's Happy •Integration •Extending Liquibase
33. Antidote: Advanced use-cases •Legacy Database •Keeping DBA's Happy •Integration •Extending Liquibase Various integration options •Commandline •Ant •Maven •Spring •Servlet Listener
34. Antidote: Advanced use-cases •Legacy Database •Keeping DBA's Happy •Integration •Extending Liquibase
35. Conclusion Liquibase •Solves Problems •Introducible •Maintainable •Extensible •Mature
36. Questions Daan van Berkel daan.vanberkel@luminis.nl @daan.v.berkel.1980 github.com/dvberkel Slides available at http://goo.gl/AuT4s Code available at github dvberkel/jfall2011-liquibase