pyDAL alternatives and similar packages
Based on the "Relational Databases" category.
Alternatively, view pyDAL alternatives based on common mentions on social networks and blogs.
Peewee9.1 8.0 L2 pyDAL VS Peeweea small, expressive orm -- supports postgresql, mysql and sqlite
SQLAlchemy8.6 9.8 pyDAL VS SQLAlchemyThe Database Toolkit for Python
PonyORM7.0 0.0 L2 pyDAL VS PonyORMPony Object Relational Mapper
GINO6.5 0.0 pyDAL VS GINOGINO Is Not ORM - a Python asyncio ORM on SQLAlchemy core.
orm5.6 3.3 pyDAL VS ormAn async ORM. 🗃
Prisma Client Python4.6 6.4 pyDAL VS Prisma Client PythonPrisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
python-sqlWrite SQL queries pythonically.
Django ModelsA part of Django.
Write Clean Python Code. Always.
* Code Quality Rankings and insights are calculated and provided by Lumnify.
They vary from L1 to L5 with "L5" being the highest.
Do you think we are missing an alternative of pyDAL or a related project?
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.
pyDAL comes from the original web2py's DAL, with the aim of being compatible with any Python program. pyDAL doesn't require web2py and can be used in any Python context.
You can install pyDAL using
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.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:
- Inner Joins
- Outer Joins
- Nested Selects
Which databases are supported?
pyDAL supports the following databases:
pyDAL is released under the BSD-3c License. For further details, please check the
*Note that all licence references and agreements mentioned in the pyDAL README section above are relevant to that project's source code only.