ajwerner / fe Goto Github PK

About
=====

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

For a high performance async interface, MagicStack's asyncpg
http://github.com/MagicStack/asyncpg should be considered.

py-postgresql, currently, does not have direct support for high-level async
interfaces provided by recent versions of Python. Future versions may change this.

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::

	>>> 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 as well: `postgresql.driver.dbapi20`.

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

Online documentation can be retrieved from:

	http://py-postgresql.readthedocs.io

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

For information about PostgreSQL:

	http://postgresql.org

For information about Python:

	http://python.org