Category Archives: Version control

Pyrseas contributions solicited

Posted on 17 May, 2013 by

Do you use PostgreSQL and truly believe it’s “the world’s most advanced open source database” and that its upcoming 9.3 release will make it even more awesome? Do you also use Python and believe it’s “an easy to learn, powerful … Continue reading →

Posted in PostgreSQL, Python, Version control | Tagged , , | 1 Comment

A couple of Pyrseas enhancements

Posted on 21 January, 2013 by

Based on feedback from users and contributors, Pyrseas now sports two enhancements. Multi-line String Formatting Up to Pyrseas 0.6, long textual elements such as view definitions, function source text and long object comments, would usually be shown in the YAML … Continue reading →

Posted in PostgreSQL, Python, Version control | Tagged , , , | Leave a comment

PostgreSQL Indexes on Expressions

Posted on 13 June, 2012 by

Pyrseas had its first release a little over a year ago and we now have our first backward compatibility issue. The first release included basic support for traditional indexes, i.e., one or more key columns. For example, given a table … Continue reading →

Posted in PostgreSQL, Version control | Tagged , , | Leave a comment

PostgreSQL Extensions and Pyrseas

Posted on 18 May, 2012 by

Prompted by Peter Eisentraut’s blog post, I’ve finished adding support for PG 9.1 EXTENSIONs to the Pyrseas dbtoyaml and yamltodb utilities. For now, this is only available on GitHub. In order to deal with procedural languages, which are now created … Continue reading →

Posted in PostgreSQL, Version control | Tagged , | Leave a comment

Pyrseas PostgreSQL features: feedback requested

Posted on 10 April, 2012 by

I’ve been considering the missing features of dbtoyaml/yamltodb.  Two of those are PG 9.1 features:  COLLATIONs and EXTENSIONs.  I plan to cover them eventually, but I think I ought to deal first with the remaining pre-9.1 features. ROLEs (as well … Continue reading →

Posted in PostgreSQL, Version control | Tagged , | Leave a comment

Pyrseas/PostgreSQL Feature Matrix

Posted on 7 March, 2012 by

In my last post, I wrote—referring to the state of Pyrseas after version 0.5 is released: The only gaps left are TABLESPACE, GROUP/ROLE and the EXTENSIONs added in PG 9.1. I’m afraid I should’ve double checked the list of 9.1 … Continue reading →

Posted in Database tools, PostgreSQL, Version control | Tagged , , | 1 Comment

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

The Phantom of the Database – Part 1

Posted on 7 November, 2011 by

Scenario: A row with “Seven  Samurai” (notice two spaces between the words) as the movie title and 1956 as the release year, in the film table. Plot: User Alice updates the row to remove the extra space. In the meantime, … Continue reading →

Posted in PostgreSQL, Python, User interfaces, Version control | Tagged , , , | 4 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