pyDAL
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.
Release files for pydal 20250622.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| pydal-20250622.1.tar.gz | 631.5 kB | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| pydal-20250622.1-py2.py3-none-any.whl | Python 2, Python 3 | none | any | Details |
Total release size: 883.1 kB
Release files / pydal-20250622.1.tar.gz
| Download URL | pydal-20250622.1.tar.gz |
|---|---|
| Size | 631.5 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
ea58f2b07f53d6b467c629261b3809148c549a3a3867708d668c5073e218d32c
|
|
BLAKE2b-256 checksum How to use checksums |
54045b0fb1c2ade18f049fda8426ef654b6c85ededc7b1e77c973410829a8da8
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.0
|
Release files / pydal-20250622.1-py2.py3-none-any.whl
| Download URL | pydal-20250622.1-py2.py3-none-any.whl |
|---|---|
| Size | 251.6 kB |
| Tags | Python 2 Python 3 |
|
SHA-256 checksum How to use checksums |
8dfdc1a94f615f0ed5c296b2465cd0761ba3dd0e82a8846e5628398d6266e156
|
|
BLAKE2b-256 checksum How to use checksums |
721d20712214a45e30b0c2be5a3701524d7ac36fd391c93fc40a733da21b6a11
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/6.1.0 CPython/3.12.0
|
