py-postgresql

I recently had the opportunity to review py-postgresql, a versatile Python library that allows users to interface with various aspects of PostgreSQL. The library includes a pure-Python driver with C optimizations for easy querying of PostgreSQL databases.

One of the standout features of py-postgresql is its easy-to-use code, which allows users to quickly get started with the library. Sample PG-API code is readily available for testing and experimentation. For example, the following code initializes a connection to a PostgreSQL database, creates a new table, and inserts data into it:

```
import postgresql
db = postgresql.open('pq://user:password@host:port/database')
db.execute("CREATE TABLE emp (emp_first_name text, emp_last_name text, emp_salary numeric)")
make_emp = db.prepare("INSERT INTO emp VALUES ($1, $2, $3)")
make_emp("John", "Doe", "75,322")
with db.xact():
make_emp("Jane", "Doe", "75,322")
make_emp("Edward", "Johnson", "82,744")
```

py-postgresql also includes a DB-API 2.0 module, called postgresql.driver.dbapi20, though users are encouraged to use the PG-API instead as it provides greater utility.

Installation of the library is straightforward, and users are encouraged to try out the pg_python console script. With this script, a user can easily connect to a remote host and open a Python console with the database connection already bound to the `db` name. Simply run the following command:

```
$ pg_python -h localhost -p port -U theuser -d database_name
```

Overall, I found py-postgresql to be an excellent tool for working with PostgreSQL databases using Python. Its range of features and ease of use make it a valuable addition to any developer's toolbox.