jwp / py-postgresql

PostgreSQL interfaces library. Driver, protocol tools, and command interfaces for Python 3

This URL has Read+Write access

Use set not setenv.
jwp (author)
Mon Jan 04 01:41:15 -0800 2010
commit  ec0d028ce423cc223bcb5732098690c1ffd741d6
tree    8f8762221853df2cc8215567b63b4cc2e3d326f5
parent  324c49bb4b56af47bf73fd0122cc2164d324da40
name age
history
message
file .gitignore Sat May 16 14:10:42 -0700 2009 Implement Categories and Query Libraries. post... [jwp]
file AUTHORS Sun Nov 01 15:35:21 -0800 2009 Note AppCove Network's donation. [jwp]
file LICENSE Thu Jan 15 08:15:19 -0800 2009 Add README data, AUTHORS, and LICENSE file. s/... [jwp]
file MANIFEST.in Fri Dec 11 19:42:45 -0800 2009 Use *.rst now. [jwp]
file README Thu Jun 11 15:13:01 -0700 2009 Remove references to python3.x [jwp]
directory postgresql/ Mon Jan 04 01:41:15 -0800 2010 Use set not setenv. Also, reference python3.1 ... [jwp]
file setup.py Mon Mar 16 01:35:15 -0700 2009 Don't build extensions if PY_BUILD_EXTENSIONS=0. [jwp]
directory sphinx-src/ Fri Dec 11 23:16:33 -0800 2009 Add warnings and notes about the pending deprec... [jwp]
README
About py-postgresql
===================

py-postgresql is a Python 3 package providing modules to work with PostgreSQL.
This includes a high-level driver, and many other tools that support a developer
working with PostgreSQL databases.

The goal of this project is to provide substantial convenience to Python
developers working with PostgreSQL.


Installation
------------

Installation *should* be as simple as::

  $ python3 ./setup.py install


More information about installation is available via::

  python -m postgresql.documentation.admin


Basic Driver Usage
------------------

Using PG-API is recommended as it provides more utility for the user::

  >>> import postgresql
  >>> db = postgresql.open('pq://user:password@host:port/database')
  >>> get_table = db.prepare("select * from information_schema.tables where table_name = $1")
  >>> for x in get_table("tables"):
  >>>  print(x)
  >>> print(get_table.first("tables"))

However, a DB-API 2.0 driver is provided: `postgresql.driver.dbapi20`.


Further Information
-------------------

The documentation package, `postgresql.documentation.index`, contains more
detailed information on the modules herein, and HTML versions of the
documentation can be found at:

  http://python.projects.postgresql.org

Or, you can read them in your pager: python -m postgresql.documentation.index