Skip to main content

pyDAL is a Database Abstraction Layer. It generates queries for SQlite, PotsgreSQL, MySQL, and other backends. It was originally part of the web2py frameworks but it is now an independent project. Example: db.define_table("thing",Field("name")) and db.thing.insert(name="Pizza")

Project description

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.

Project details


Release history Release notifications | RSS feed

Download files

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

Source Distribution

pydal-20250629.2.tar.gz (631.5 kB view details)

Uploaded Source

Built Distribution

pydal-20250629.2-py2.py3-none-any.whl (251.6 kB view details)

Uploaded Python 2Python 3

File details

Details for the file pydal-20250629.2.tar.gz.

File metadata

  • Download URL: pydal-20250629.2.tar.gz
  • Upload date:
  • Size: 631.5 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.0

File hashes

Hashes for pydal-20250629.2.tar.gz
Algorithm Hash digest
SHA256 3fae6250b9dc61ab0deda8700fbe5ccc6970ba6f8de03d58d1609de97a415d29
MD5 9d6c7dcab8d109355b41befd4e00beea
BLAKE2b-256 439ba4ec4f0970259b873ee6ea66cfd7681436aa3dff814aa1ad589315a6a4a6

See more details on using hashes here.

File details

Details for the file pydal-20250629.2-py2.py3-none-any.whl.

File metadata

  • Download URL: pydal-20250629.2-py2.py3-none-any.whl
  • Upload date:
  • Size: 251.6 kB
  • Tags: Python 2, Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/6.1.0 CPython/3.12.0

File hashes

Hashes for pydal-20250629.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 fd03865f467f0ee887c86478f27619f54e01adf058de02a64019ced352abc213
MD5 df32f082934b68cff67c5e6dfab127a0
BLAKE2b-256 ce1ab1d8a3735ae79826dffd6bb3b09fd08658e2f8fc0712201069aefbed7586

See more details on using hashes here.

Supported by

AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Pingdom Monitoring Sentry Error logging StatusPage Status page