Skip to main content

pyDAL

pip version master-test Coverage Status API Docs Status

pyDAL is a pure Python Database Abstraction Layer.

It dynamically generates the SQL/noSQL in realtime using the specified dialect for the database backend, so that you do not have to write SQL code or learn different SQL dialects (the term SQL is used generically), and your code will be portable among different types of databases. What makes pyDAL different from most of the other DALs is the syntax: it maps records to python dictionaries, which is simpler and closer to SQL. Other famous frameworks instead strictly rely on an Object Relational Mapping (ORM) like the Django ORM or the SQL Alchemy ORM, that maps tables to Python classes and rows to Objects.

Historically pyDAL comes from the original web2py's DAL, with the aim of being compatible with any Python program. However, pyDAL nowadays is an indipendent package that can be used in any Python 3.7+ context.

Installation

You can install pyDAL using pip:

pip install pyDAL

Usage and Documentation

Here is a quick example:

>>> from pydal import DAL, Field
>>> db = DAL('sqlite://storage.db')
>>> db.define_table('thing', Field('name'))
>>> db.thing.insert(name='Chair')
>>> query = db.thing.name.startswith('C')
>>> rows = db(query).select()
>>> print rows[0].name
Chair
>>> db.commit()

The complete updated documentation is available on the py4web manual

What's in the box?

A little taste of pyDAL features:

  • Transactions
  • Aggregates
  • Inner Joins
  • Outer Joins
  • Nested Selects

Which databases are supported?

pyDAL supports the following databases:

  • SQLite
  • MySQL
  • PostgreSQL
  • MSSQL
  • FireBird
  • Oracle
  • DB2
  • Ingres
  • Sybase
  • Informix
  • Teradata
  • Cubrid
  • SAPDB
  • IMAP
  • MongoDB
  • Google Firestore

License

pyDAL is released under the BSD-3c License. For further details, please check the LICENSE file.

Metadata

Release files for pydal 20250922.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pydal 20250922.1
File Size Uploaded Provenance Actions
pydal-20250922.1.tar.gz 632.5 kB Without provenance Details for pydal-20250922.1.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for pydal 20250922.1
File Interpreter ABI Platform Actions
pydal-20250922.1-py2.py3-none-any.whl Python 3, Python 2 none any Details for pydal-20250922.1-py2.py3-none-any.whl

Total release size: 884.6 kB

Release files / pydal-20250922.1.tar.gz

Download URL pydal-20250922.1.tar.gz
Size 632.5 kB
Tags Source
SHA-256 checksum
How to use checksums
b88a0fad430ff62f840d32576e819d692541bd9edaaa05578b134bb2cd251727
BLAKE2b-256 checksum
How to use checksums
f994bf35afe3eaf94e2c411be204b8421b3abb34a24a260513fd9bc0e45c05e4
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.12.0

Release files / pydal-20250922.1-py2.py3-none-any.whl

Download URL pydal-20250922.1-py2.py3-none-any.whl
Size 252.1 kB
Tags Python 2 Python 3
SHA-256 checksum
How to use checksums
c4c7e46fa6c7fa68371dd1a061dd011084095c54643393ae7c91e1225435def1
BLAKE2b-256 checksum
How to use checksums
5588f521b8067bc70c0363a134b1b036912618603b2348e1fbf7265285e6ac34
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/6.2.0 CPython/3.12.0

Security for pydal 20250922.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

20250922.1 This release

2 release files No provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page