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-20250607.2.tar.gz (629.7 kB view details)

Uploaded Source

Built Distribution

pydal-20250607.2-py2.py3-none-any.whl (250.6 kB view details)

Uploaded Python 2Python 3

File details

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

File metadata

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

File hashes

Hashes for pydal-20250607.2.tar.gz
Algorithm Hash digest
SHA256 66bd5dea40b0032863795dad43e9fdcbdc7cd320ff02d6fa4c9abb027473f8f4
MD5 43c951c2e9fb9363796ecb4f568f133e
BLAKE2b-256 0782f2ec90d2b4214751d8a628537e556e3ca33e0170f774eb5247f5d632a775

See more details on using hashes here.

File details

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

File metadata

  • Download URL: pydal-20250607.2-py2.py3-none-any.whl
  • Upload date:
  • Size: 250.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-20250607.2-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 4605c82c07247ab3623cd865e6366a7dd445f84205c5883ddf28957dfb2ba19b
MD5 6fa6d2a1e5c23846d44b45c276f7412c
BLAKE2b-256 5ada9ca05bb4cc40f3a1bb59c8bf10f177f4c88af90fad175cf64420ddf47097

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