orm alternatives and similar packages
Based on the "Relational Databases" category.
Alternatively, view orm alternatives based on common mentions on social networks and blogs.
-
Prisma Client Python
Prisma Client Python is an auto-generated and fully type-safe database client designed for ease of use
Access the most powerful time series database as a service
* 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 orm or a related project?
Popular Comparisons
README
ORM
The orm
package is an async ORM for Python, with support for Postgres,
MySQL, and SQLite. ORM is built with:
- SQLAlchemy core for query building.
databases
for cross-database async support.typesystem
for data validation.
Because ORM is built on SQLAlchemy core, you can use Alembic to provide database migrations.
Documentation: https://www.encode.io/orm
Installation
$ pip install orm
You can install the required database drivers with:
$ pip install orm[postgresql]
$ pip install orm[mysql]
$ pip install orm[sqlite]
Driver support is provided using one of asyncpg, aiomysql, or aiosqlite.
Quickstart
Note: Use ipython
to try this from the console, since it supports await
.
import databases
import orm
database = databases.Database("sqlite:///db.sqlite")
models = orm.ModelRegistry(database=database)
class Note(orm.Model):
tablename = "notes"
registry = models
fields = {
"id": orm.Integer(primary_key=True),
"text": orm.String(max_length=100),
"completed": orm.Boolean(default=False),
}
# Create the tables
await models.create_all()
await Note.objects.create(text="Buy the groceries.", completed=False)
note = await Note.objects.get(id=1)
print(note)
# Note(id=1)
— ๐ — ORM is BSD licensed code. Designed & built in Brighton, England.
*Note that all licence references and agreements mentioned in the orm README section above
are relevant to that project's source code only.