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.
InstallationYou can install pyDAL using pip:
pip install pyDALUsage 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:
pyDAL supports the following databases:
pyDAL is released under the BSD-3c License. For further details, please check the LICENSE file.
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution Built Distribution File detailsDetails for the file pydal-20250629.2.tar.gz.
3fae6250b9dc61ab0deda8700fbe5ccc6970ba6f8de03d58d1609de97a415d29 MD5 9d6c7dcab8d109355b41befd4e00beea BLAKE2b-256 439ba4ec4f0970259b873ee6ea66cfd7681436aa3dff814aa1ad589315a6a4a6
See more details on using hashes here.
File detailsDetails for the file pydal-20250629.2-py2.py3-none-any.whl.
fd03865f467f0ee887c86478f27619f54e01adf058de02a64019ced352abc213 MD5 df32f082934b68cff67c5e6dfab127a0 BLAKE2b-256 ce1ab1d8a3735ae79826dffd6bb3b09fd08658e2f8fc0712201069aefbed7586
See more details on using hashes here.
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4