Simple Python Wrapper for postgres connection.

Table of Contents

• Table of Contents
• Overview
• Features
• Project Structure
  • Project Index
• Getting Started
  • Prerequisites
  • Installation
  • Usage
  • Testing
• Roadmap
• Contributing
• License
• Acknowledgments

Overview

dxpq is a simple and intuitive Python library designed to facilitate connection and interaction with PostgreSQL databases. It was created with the goal of providing an efficient way to perform common PostgreSQL operations, such as executing SQL queries, inserting and updating data, and managing transactions.

This library is lightweight and easy to use, allowing developers to quickly connect to the database without the complexity of setting up additional packages. With support for basic SQL commands and transactions, dxpq offers a clear and straightforward interface for working with PostgreSQL.

Ideal for those seeking a minimalist solution focused only on essential database operations, dxpq is perfect for projects that don't require large frameworks or heavy libraries but still need robust communication with PostgreSQL.

Features

• Database Connection: Easily establish a connection to a PostgreSQL database using a connection string.

• Cursor Management: Create and manage cursors for executing SQL queries. Fetch all results or a single row, with support for different result formats (e.g., dictionary-style results).

• SQL Execution: Execute SQL queries and commands with parameters for secure and dynamic query building.

• Context Manager Support: The library supports context manager functionality, allowing the use of connections and cursors in with blocks for automatic resource management.

• Cursor Types: Supports different cursor types, such as dictionary-style results, for easier access to columns by name.

• Clean Resource Management: Automatically close database connections and cursors when done, either through context management or explicit cleanup with close() and __del__ methods.

Project Structure

└── dxpq/
    ├── README.md
    ├── dxpq
    │   ├── __init__.py
    │   ├── connection.py
    │   └── cursor.py
    ├── pyproject.toml
    ├── requirements-dev.txt
    └── requirements.txt

Getting Started

Prerequisites

This project requires the following dependencies:

• Programming Language: Python
• Package Manager: Pip

Installation

Build dxpq from the source and intsall dependencies:

1. Clone the repository:

   ❯ git clone https://github.com/pedrohsbarbosa99/dxpq
   

2. Navigate to the project directory:

   ❯ cd dxpq
   

3. Install the dependencies: Using https://pypi.org/project/pip:

   ❯ pip install -r requirements.txt, requirements-dev.txt
   

Usage

Run the project with:

Using pip:

pip install dxpq

import dxpq

connection = dxpq.Connection("postgresql://postgres:postgres@localhost:5432/postgres")
with connection.cursor() as cursor:
    cursor.execute("select 1")
    cursor.fetchall()

Testing

Under development

Roadmap

• Transaction support: Implement support to SQL commands

Contributing

• 💬 Join the Discussions: Share your insights, provide feedback, or ask questions.
• 🐛 Report Issues: Submit bugs found or log feature requests for the dxpq project.
• 💡 Submit Pull Requests: Review open PRs, and submit your own PRs.

License

Dxpq is protected under the MIT License. For more details, refer to the LICENSE file.