Skip to main content

A lightweight Pythonic interface for PostgreSQL

Project description

PyPQL

PyPQL is a lightweight, Pythonic interface for interacting with PostgreSQL databases. It allows developers to build readable, composable, and expressive queries in pure Python — no need to write raw SQL.

Features

  • Intuitive, fluent query syntax
  • Built-in support for PostgreSQL async operations via asyncpg
  • Easy integration with FastAPI and modern Python web frameworks
  • Designed for clarity, flexibility, and developer happiness

Installation

Install from PyPI:

pip install pypql

Or download the ZIP directly from the official website if preferred. GitHub repository coming soon.

Example

import asyncio
from pypql import tableobj

users = Table('user', 'password', 'database', 'host', 'table_name')
await users.connect()
await users.insert_single(['name'], ['Bobby']) # Inserts new row with value "Bobby" into name column of users table
await users.close()

License

MIT License — see LICENSE for details.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pypql-0.1.0.4.tar.gz (2.7 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

pypql-0.1.0.4-py3-none-any.whl (2.6 kB view details)

Uploaded Python 3

File details

Details for the file pypql-0.1.0.4.tar.gz.

File metadata

  • Download URL: pypql-0.1.0.4.tar.gz
  • Upload date:
  • Size: 2.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.0.1 CPython/3.12.5

File hashes

Hashes for pypql-0.1.0.4.tar.gz
Algorithm Hash digest
SHA256 498c9846bf26d5441f9c50ddede1b048c6c4214f00af201d5d524dd1497d912b
MD5 ca05e4a4937f4d26029f41666aa5a5ab
BLAKE2b-256 8482a52b294995ad04993fb45ff0a28f9afe13b788da9892de63402cc5cf0c5f

See more details on using hashes here.

File details

Details for the file pypql-0.1.0.4-py3-none-any.whl.

File metadata

  • Download URL: pypql-0.1.0.4-py3-none-any.whl
  • Upload date:
  • Size: 2.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.0.1 CPython/3.12.5

File hashes

Hashes for pypql-0.1.0.4-py3-none-any.whl
Algorithm Hash digest
SHA256 b83490d9901352989eb274c174ff486de9a02aa4e0e2b04523ed42cfc5d679ed
MD5 eb30e13806c0fdfb17a45edf73fe2164
BLAKE2b-256 0ecdca7e95230d4b99678ff7fe4e5f7d94d918f125eb39f5563c8b6f82d270aa

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Depot Continuous Integration Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page