PyGreSQL An open source, highly scalable, SQL compliant, open source object-relational database management system
Download

PyGreSQL Ranking & Summary

PyGreSQL Tags

interface database database interface PostgreSQL python interface PostgreSQL interface

PyGreSQL Description

An open source, highly scalable, SQL compliant, open source object-relational database management system PyGreSQL is an open-source Python module that interfaces to a PostgreSQL database. PyGreSQL embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script.With more than 15 years of development history, it is quickly becoming the de facto database for enterprise level open source solutions. Best of all, PostgreSQL's source code is available under the most liberal open source license: the BSD license.Python is an interactive, interpreted, object-oriented programming language. It is often compared to Tcl, Scheme, Perl, or Java.Python combines remarkable power with very clear syntax. It has modules, classes, exceptions, very high level dynamic data types, and dynamic typing. There are interfaces to many system calls and libraries, as well as to various windowing systems (X11, Motif, Tk, Mac, MFC). New built-in modules are easily written in C or C++. Python is also usable as an extension language for applications that need a programmable interface. The Python implementation is copyrighted but freely usable and distributable, even for commercial use.PyGreSQL is a Python module that interfaces to a PostgreSQL database. It embeds the PostgreSQL query library to allow easy use of the powerful PostgreSQL features from a Python script. What's New in This Release: · Dropped support for Python below 2.3 and PostgreSQL below 7.4. · Improved performance of fetchall() for large result sets by speeding up the type casts (as suggested by Peter Schuller). · Exposed exceptions as attributes of the connection object. · Exposed connection as attribute of the cursor object. · Cursors now support the iteration protocol. · Added new method to get parameter settings. · Added customizable row_factory as suggested by Simon Pamies. · Separated between mandatory and additional type objects. · Added keyword args to insert, update and delete methods. · Added exception handling for direct copy. · Release the GIL while making a connection (as suggested by Peter Schuller). · If available, use decimal.Decimal for numeric types. · Allow DB wrapper to be used with DB-API 2 connections (as suggested by Chris Hilton). · Made private attributes of DB wrapper accessible. · Dropped dependence on mx.DateTime module. · Support for PQescapeStringConn() and PQescapeByteaConn(); these are now also used by the internal _quote() functions. · Added 'int8' to INTEGER types. New SMALLINT type. · Added a way to find the number of rows affected by a query() with the classic pg module by returning it as a string. For single inserts, query() still returns the oid as an integer. The pgdb module already provides the "rowcount" cursor attribute for the same purpose. · Improved getnotify() by calling PQconsumeInput() instead of submitting an empty command. · Removed compatibility code for old OID munging style. · The insert() and update() methods now use the "returning" clause if possible to get all changed values, and they also check in advance whether a subsequent select is possible, so that ongoing transactions won't break if there is no select privilege. · Added "protocol_version" and "server_version" attributes. · Revived the "user" attribute. · The pg module now works correctly with composite primary keys; these are represented as frozensets. · Removed the undocumented and actually unnecessary "view" parameter from the get() method. · get() raises a nicer ProgrammingError instead of a KeyError if no primary key was found. · delete() now also works based on the primary key if no oid available and returns whether the row existed or not.

PyGreSQL Related Software