Queries is a BSD licensed opinionated wrapper of the psycopg2 library for interacting with PostgreSQL.
The popular psycopg2 package is a full-featured python client. Unfortunately as a developer, you're often repeating the same steps to get started with your applications that use it. Queries aims to reduce the complexity of psycopg2 while adding additional features to make writing PostgreSQL client applications both fast and easy.
Key features include:
- Simplified API
- Support of Python 2.7+ and 3.4+
- PyPy support via psycopg2cffi
- Asynchronous support for Tornado
- Connection information provided by URI
- Query results delivered as a generator based iterators
- Automatically registered data-type support for UUIDs, Unicode and Unicode Arrays
- Ability to directly access psycopg2 :py:class:`~psycopg2.extensions.connection` and :py:class:`~psycopg2.extensions.cursor` objects
- Internal connection pooling
Queries can be installed via the Python Package Index and can be installed by running :command:`easy_install queries` or :command:`pip install queries`
When installing Queries, pip
or easy_install
will automatically install the proper
dependencies for your platform.
.. toctree:: :maxdepth: 1 usage session results tornado_session pool examples/index.rst history
Please report any issues to the Github repo at https://github.com/gmr/queries/issues
Queries source is available on Github at https://github.com/gmr/queries
Queries is inspired by Kenneth Reitz's awesome work on requests.