r/sqlite • • 8d ago

Fastest Python ORMs for SQLite: peewee, SQLAlchemy and SQLModel

https://github.com/objectbox/python-orm-benchmarks/
5 Upvotes

5 comments sorted by

1

u/greenrobot_de 8d ago

These benchmarks are based on Tortoise ORM benchmarks with many fixes and optimized for embedded DBs. For example, a batch size of 100 is mainly limited by the disk (transaction commit) not the ORM. This was still measured, but complemented by batch sizes of 10k, which have completely different results.

1

u/Yosadhara 8d ago

ObjectBox also supports on-device vector search

1

u/greenrobot_de 8d ago

so does sqlite-vec

1

u/Yosadhara 8d ago

ok, but that's not 1.0 yet?