pyDAL
pyDAL is a pure Python Database Abstraction Layer.
It dynamically generates the SQL in real time using the specified dialect for the database back end, 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.
pyDAL comes from the original web2py's DAL, with the aim of being wide-compatible. pyDAL doesn't require web2py and can be used in any Python 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 documentation is available on http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer
What's in the box?
A little taste of pyDAL features:
- Transactions
- Aggregates
- Inner Joins
- Outer Joins
- Nested Selects
Which databases are supported?
pyDAL actually support these databases:
- sqlite
- postgresql
- mysql
- mssql
- db2
- firebird
- sybase
- oracle
- informix
- teradata
- sapdb
- ingres
- cubrid
- imap
- mongodb
License
pyDAL is released under the BSD-3c License.
For further details, please check the LICENSE file.
1 maintainer
Metadata
1 maintainer
Release files for emmett-pydal 17.3.3
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| emmett_pydal-17.3.3.tar.gz | 174.6 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| emmett_pydal-17.3.3-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 345.3 kB
Release files / emmett_pydal-17.3.3.tar.gz
| Download URL | emmett_pydal-17.3.3.tar.gz |
|---|---|
| Size | 174.6 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
37e584c94bb1d91731b895be0135b8ef674dee051133cbf835a5fd82080009be
|
|
BLAKE2b-256 checksum How to use checksums |
9c5b5df1ca8f9f0632ea94ac2c8fdbd4b8ee1da06cdafef34acf1cad18d86b5e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
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.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Mar 29, 2026.
Transparency logRelease files / emmett_pydal-17.3.3-py3-none-any.whl
| Download URL | emmett_pydal-17.3.3-py3-none-any.whl |
|---|---|
| Size | 170.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
af6d4f66e820eecda9792646c5e15dea13907642a474c5175542c4de137cdbea
|
|
BLAKE2b-256 checksum How to use checksums |
d26ad30f6e97c47d629ce1e9e56056a56bfc065624762f1835be93effe6bf07a
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.7
|
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.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Mar 29, 2026.
Transparency log
