postgres

What it is and what it does

postgres is a thin wrapper around psycopg2 that aims to reduce boilerplate when working with PostgreSQL databases in Python. It sits between your application and psycopg2-binary and psycopg2-pool, providing convenience methods for common database operations. The package is marked as Production/Stable in its classifiers and supports Python 3.6 through 3.9, though it has not been actively maintained since 2021-09-20.

Because the package is abandoned with no commits since 2023-06-14, it may not work reliably with current versions of psycopg2-binary, psycopg2-pool, or modern PostgreSQL server versions. Using it in new projects carries the risk of encountering unfixed bugs or compatibility issues.

Use it for:

• Maintaining existing codebases already using postgres that need to remain on stable, tested versions.
• Educational projects exploring database abstraction patterns without committing to a full ORM.
• Legacy applications where replacing the database layer would be costly and the current version works.
• Quick prototyping when you want less boilerplate than raw psycopg2 and accept maintenance risk.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a lightweight abstraction layer over psycopg2 for PostgreSQL database access, simplifying common query patterns and connection management.

No, not for new projects. The package is abandoned with no updates since 2021-09-20 and no commits since 2023-06-14. While it has low install friction and a permissive MIT license, the lack of maintenance means you will not receive security patches or bug fixes. For new PostgreSQL work, use psycopg2-binary directly or choose an actively maintained abstraction. Only consider it if maintaining existing code already using it.

Install

postgres on PyPI

pip install postgres

uv add postgres

poetry add postgres

Installing postgres

Before you install

Installation is straightforward with low friction, but the package is abandoned with no commits since 2023-06-14. The last release was 2021-09-20, meaning security patches and compatibility updates are unlikely.

License in practice

Licensed under MIT (permissive), so you can use, modify, and distribute this package freely with minimal restrictions.

Quickstart

pip install postgres
import postgres
db = postgres.connect('postgresql://user:password@localhost/dbname')
result = db.query('SELECT * FROM table')

Verify before relying

• Whether the abstraction layer's API remains compatible with current psycopg2-binary and psycopg2-pool versions.
• What specific high-value abstractions this package provides beyond psycopg2's native interface.
• Compatibility with Python versions beyond 3.9 given the abandoned maintenance status.

Package facts

Evidence: postgres-4.0-py2.py3-none-any.whl

Keywords: sql, postgresql, psycopg2

Tags

More Python Modules packages