Andy Todd
Andy Todd
Andy has been using commercial and open source databases professionally for nearly twenty years and has broken almost every one he has built. In a vain attempt to manage the chaos that is database schema change he has been tinkering with a bunch of Python scripts for over five years. He has been using Python since 2000 but isn't averse to working with different languages and technologies as the need arises. By day he is an IT consultant and therefore spends far too much time talking about technology and not nearly enough time wrangling it.
"Change Bad!" - Change in database schemas and source code
Full Paper (html), Slides
"Change Bad!" a journey through identifying, understanding and managing change in database schemas and source code.
The presentation will focus on how to manage changing database schemas in a software development project. It will include references to popular open source relational databases such as MySQL, PostgreSQL, SQLite and Ingres. A rough outline of topics is:
- why and what database objects change in various open source databases
- what files to create and put under source control when schemas change
- why a schema is not the same as the DDL scripts you use to create it - there is data involved
- how to migrate application and database objects in a co-ordinated fashion (to include a discussion of techniques such as Rails migrations)
- how to integrate schema changes from multiple developers - and how it relates to application code branching and merging
- what to do when it all goes bad (and it will)
Published Oct 24, 2009.
0 responses to Andy Todd
There are no comments for this page yet. Be the first!
Leave a Reply