Category Archives: Python

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

Tuples in the Pythonic, TTM-inspired interface to PostgreSQL

Posted on 26 March, 2013 by

The Third Manifesto formally describes tuple types (RM prescription 6), tuple values (prescription 9), tuple variables (prescription 12) as well as other tuple-related elements. As mentioned in the previous post, a tuple value is a set of ordered triples each … Continue reading →

Posted in PostgreSQL, Python, User interfaces | Tagged , , , | Leave a comment

Attributes in the Pythonic, TTM-inspired interface to PostgreSQL

Posted on 21 March, 2013 by

The Third Manifesto‘s Relational Model (RM) prescription 9 defines a relation heading as “a set of ordered pairs or attributes of the form <A,T>,” where A is the name of the attribute and T is the name of the declared … Continue reading →

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

A Pythonic, TTM-inspired interface to PostgreSQL – Requirements

Posted on 7 March, 2013 by

Several moons ago, I started a series of posts about “designing and implementing a generic end user interface for PostgreSQL.” After a while, the series got sidetracked by other issues. More recently, I have returned to the original endeavor. Partly … Continue reading →

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

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

Testing Python and PostgreSQL on Windows, Part 6

Posted on 23 October, 2012 by

Alliterative locales, languages, collations. A tox on all your houses (test combinations). The last item to fix in the Pyrseas unit tests so that they run on Windows is related to the PostgreSQL 9.1 COLLATION feature. When creating the tests, … Continue reading →

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

Testing Python and PostgreSQL on Windows, Part 5

Posted on 17 October, 2012 by

I’ve got the Perl on Windows blues … Aside from PL/pgSQL, the base distribution of PostgreSQL supports three procedural languages: Perl, Python and Tcl. When creating Pyrseas unit tests for languages (before they became EXTENSIONs), PL/Perl seemed like the “natural” … Continue reading →

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

Testing Python and PostgreSQL on Windows, Part 4

Posted on 3 October, 2012 by

At the end of Part 2, I suggested those who were anxious to start testing could try python tests\dbobject\test_schema.py right after installing psycopg2, and implied everything would work just fine by showing the output of a successful run. That was … Continue reading →

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

Testing Python and PostgreSQL on Windows, Part 3

Posted on 28 September, 2012 by

As a commenter mentioned in response to Part 2, an alternative to using pip install psycopg2, which requires that you first install VC++ 2008 Express, is to download and install the Windows port, aka win-psycopg. Jason Erickson makes these builds … Continue reading →

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

Testing Python and PostgreSQL on Windows, Part 2

Posted on 25 September, 2012 by

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