Tag Archives: pyyaml

SQL Version Control Implementation Choices I

The Andromeda “data dictionary” is organized as multiple hierarchies, e.g., modules, generic columns, and tables with columns. Here is a very simple example: module movies: description: Movies column id: type_id: int column title: type_id: vchar colprec: 32 column release_year: type_id: … Continue reading

Posted in PostgreSQL, Python, Version control | Tagged , , , , | 3 Comments

SQL Database Version Control – Pyrseas

Now that Pyrseas has been released, it’s time to see how the DBAs Carol and Dave would use it to manage the changes described in Version Control, Part 2: SQL Databases. Version 0.1 Carol starts by creating the film table in … Continue reading

Posted in PostgreSQL, Python, Version control | Tagged , , , , , | 2 Comments