penguin-dal

PyDAL-style database abstraction layer built on SQLAlchemy. One schema (reflected automatically), one query interface — no more defining tables twice.

Installation

pip install penguin-dal

# With database drivers:
pip install penguin-dal[postgresql]   # psycopg2
pip install penguin-dal[asyncpg]      # asyncpg for async
pip install penguin-dal[mysql]        # PyMySQL
pip install penguin-dal[all]          # all drivers

Quick Start

from penguin_dal import DB

db = DB("postgresql://user:pass@localhost/mydb")

users = db(db.users.active == True).select()
pk = db.users.insert(email="new@example.com", name="New User", active=True)
db(db.users.id == pk).update(name="Updated")
db(db.users.id == pk).delete()

Read/Write Splitting

from penguin_dal import DatabaseManager

manager = DatabaseManager(
    write_url="postgresql://primary/myapp",
    read_url="postgresql://replica/myapp",
)
rows = manager.read(manager.read.users).select()
manager.write.users.insert(name="Alice")
manager.close()

📚 Full documentation: docs/penguin-dal/

README — complete feature overview
API Reference — all classes and methods
Changelog
Migration Guide — migrating from PyDAL or upgrading to 0.2.x

License

MIT — Penguin Tech Inc

Download files

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

Source Distribution

penguin_dal-0.4.0.tar.gz (63.5 kB view details)

Uploaded Aug 5, 2026 Source

Built Distribution

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

The dropdown lists show the available interpreters, ABIs, and platforms. Enable javascript to be able to filter the list of wheel files.

penguin_dal-0.4.0-py3-none-any.whl (49.2 kB view details)

Uploaded Aug 5, 2026 Python 3

File details

Details for the file penguin_dal-0.4.0.tar.gz.

File metadata

Download URL: penguin_dal-0.4.0.tar.gz
Upload date: Aug 5, 2026
Size: 63.5 kB
Tags: Source
Uploaded using Trusted Publishing? Yes
Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for penguin_dal-0.4.0.tar.gz
Algorithm	Hash digest
SHA256	`98c08ec55649aaedb73f85b303c3de2860c0858fec04a381f026e3b361074351`
MD5	`6e86679913b8e5e695f02778ee3b39af`
BLAKE2b-256	`c26fbee1f120c2c55076cf8af19f5aeb1099efbd634a29507f6b180ee1570f3d`

See more details on using hashes here.

Provenance

The following attestation bundles were made for penguin_dal-0.4.0.tar.gz:

Publisher: publish.yml on penguintechinc/penguin-libs

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Statement:
- Statement type: https://in-toto.io/Statement/v1
- Predicate type: https://docs.pypi.org/attestations/publish/v1
- Subject name: penguin_dal-0.4.0.tar.gz
- Subject digest: 98c08ec55649aaedb73f85b303c3de2860c0858fec04a381f026e3b361074351
- Sigstore transparency entry: 2341998698
- Sigstore integration time: Aug 5, 2026
Source repository:
- Permalink: penguintechinc/penguin-libs@0ff788ba05a8d724b5b8da72518812114f198b70
- Branch / Tag: refs/tags/penguin-dal-v0.4.0
- Owner: https://github.com/penguintechinc
- Access: public
Publication detail:
- Token Issuer: https://token.actions.githubusercontent.com
- Runner Environment: github-hosted
- Publication workflow: publish.yml@0ff788ba05a8d724b5b8da72518812114f198b70
- Trigger Event: push