Based on the "Relational Databases" category.
Alternatively, view orm alternatives based on common mentions on social networks and blogs.
* 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?
The orm package is an async ORM for Python, with support for Postgres,
MySQL, and SQLite. ORM is built with:
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
$ 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.
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.
Do not miss the trending, packages, news and articles with our weekly report.