---
id: pgdb
version: "0.0.11"
license: Apache v2.0
license_treatment: permissive
maintenance: abandoned
---

# pgdb — PostgreSQL wrapper

License: permissive · Maintenance: abandoned · Downloads: 269.3K/mo

## 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 above — 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

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

- License: Apache v2.0 (permissive)
- Python support: unspecified
- Install friction: high
- Maintenance: abandoned
- Downloads: 269.3K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

postgresql wrapper python, postgres dictionary results, simple postgres client, psql query wrapper, postgres connection helper, abandoned, postgres-wrapper

[View on SkillFed](https://skillfed.io/packages/pgdb) · [View on PyPI](https://pypi.org/project/pgdb/)