pgdb

What it is and what it does

pgdb is a lightweight wrapper around PostgreSQL connections that converts query results from tuples into dictionaries keyed by column name. It provides a simplified API with methods like query(), get(), execute(), and executemany() to reduce boilerplate when working with PostgreSQL from Python.

The package has been abandoned since mid-2021 with no maintenance activity since then. It declares support for Python 3.5 and carries no runtime dependencies, but exhibits high install friction. While it is licensed permissively under Apache v2.0, the lack of active maintenance means it will not receive security updates, compatibility fixes, or support for modern Python or PostgreSQL versions.

Use it for:

• Quick prototyping of Python scripts that query PostgreSQL without writing raw tuple-unpacking boilerplate.
• Legacy applications that depend on dictionary-based result handling from an older codebase.
• Educational projects where simplified PostgreSQL access is more important than production robustness.

Worth the install?

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

Wraps PostgreSQL connections to return query results as dictionaries keyed by column name instead of tuples, and provides simplified methods for common database operations.

No. The package is abandoned (last update 2021) with no maintenance activity for over three years. High install friction, unclear Python version support, and lack of security updates make it unsuitable for new projects. Use a maintained alternative like psycopg2 or sqlalchemy instead.

Install

pgdb on PyPI

pip install pgdb

uv add pgdb

poetry add pgdb

Installing pgdb

Before you install

High install friction and abandoned maintenance status since 2021. Last commit was over three years ago; the package receives no active updates or security reviews.

License in practice

Licensed under Apache v2.0 (permissive), so you may use and modify it freely, but the lack of active maintenance means security patches or compatibility fixes will not be forthcoming.

Quickstart

from pgdb import Connection

connection = Connection(user='postgres', database='main', host='localhost')
results = connection.query("select * from main")
connection.close()

Requires a running PostgreSQL server and valid connection credentials; no external Python dependencies are listed, but the package itself has high install friction.

Verify before relying

• Whether the package works with modern PostgreSQL versions or recent Python releases beyond 3.5.
• What causes the high install friction (compiled extension, missing wheels, or other build requirements).
• Whether the dictionary-wrapping behavior handles NULL values, type conversions, or edge cases correctly.

Package facts

Evidence: pgdb-0.0.11.tar.gz

Keywords: psql, postgres, postgresql, sql, wrapper

Tags

More Database packages