Tag Archives: andromeda

More Database Tools?

Posted on 5 March, 2012 by

It’s been over year since I started blogging on these pages about Pyrseas and version control. In a month it will also be the first anniversary of the initial commit to GitHub. Much code and many words have flown under … Continue reading →

Posted in Database tools, PostgreSQL, Python, User interfaces, Version control | Tagged , , , , | 4 Comments

Automated Database Augmentation

Posted on 5 February, 2012 by

Suppose you have a PostgreSQL database like the Pagila sample with 14 tables, each with a last_update timestamp column to record the date and time each row was modified, and it is now a requirement to capture which user effected … Continue reading →

Posted in Database tools, PostgreSQL, Python | Tagged , , , , , , , | 6 Comments

Quo vadis, Pyrseas?

Posted on 4 October, 2011 by

When I found Andromeda, over a year ago, I was searching for a tool that would help me maintain PostgreSQL tables supporting web sites, somewhat like a Django admin app, but without Django itself since that was not part of … Continue reading →

Posted in PostgreSQL, Python, User interfaces, Version control | Tagged , , , , , , , | 8 Comments

Version Control for PostGIS

Posted on 19 September, 2011 by

A year ago, I was only trying to “rescue” Andromeda … When I started the Pyrseas project, I was mainly interested in improving on the basic table/column version control of Andromeda. I never thought I’d be adding support for “exotic” … Continue reading →

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

User Interfaces for Databases

Posted on 23 May, 2011 by

Pyrseas was started to improve on Andromeda. In addition to the schema version control I’ve been discussing in these posts, Andromeda provides two other capabilities: automations and web application programming. Andromeda’s web programming allows you to generate a database application … Continue reading →

Posted in PostgreSQL, User interfaces | Tagged , , , , , , , | 10 Comments

SQL Version Control Implementation Choices I

Posted on 3 May, 2011 by

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 – Andromeda

Posted on 15 March, 2011 by

In my first review of database VC tools, I mentioned Kenneth Down’s article where he recommended storing a single metadata file in a VCS and using a difference engine to do database upgrades. In a subsequent post, Kenneth expanded on … Continue reading →

Posted in PostgreSQL, Version control | Tagged , , , | 4 Comments