Tag Archives: postgresql

Testing Python and PostgreSQL on Windows – Basics

Posted on 20 September, 2012 by

In my previous post, I wrote: Although I have not yet personally run the [Pyrseas] unit tests on Windows …, I believe the tox setup should be quite portable …, since the tests only depend on Python and psycopg2 being … Continue reading →

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

Testing Python and PostgreSQL on Multiple Platforms

Posted on 6 September, 2012 by

I’m working on making the Pyrseas functional tests portable enough so that they can be submitted to the repository. Until now, these tests —which exercise dbtoyaml and yamltodb directly— existed as Linux shell scripts. Briefly, each test runs both dbtoyaml … Continue reading →

Posted in PostgreSQL, Python | Tagged , , , | 1 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

Database User Interfaces – Pagination

Posted on 6 April, 2012 by

Since it’s been a while from my last post on this subject, let me recap what we’ve covered: Defined a minimal command line interface as a means of exercising the basic Python-PostgreSQL interface. Following Toon Koppelaars’ Helsinki (IT) Declaration, split … Continue reading →

Posted in PostgreSQL, Python, User interfaces | 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

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

The Phantom of the Database – Part 4

Posted on 13 January, 2012 by

At the end of November, I finished the third episode with mild suspense: I suggested that the problem of optimistic “locking” could perhaps be solved in PostgreSQL with something other than extra qualifications, row version numbers or timestamps. Let’s start … Continue reading →

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