Tag Archives: pyyaml

Testing Python and PostgreSQL on Windows, Part 2

In the previous post, I covered installation of Git, PostgreSQL and Python under Windows in order to set up a Pyrseas testing and development environment. Today, we’ll explore installation of the Python dependencies. The Hitchhiker’s Guide to Python recommends first … Continue reading

Posted in PostgreSQL, Python | Tagged , , , , , | 4 Comments

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