# Python : Database : Packages ## ORMs *Stats collected 2024-12-19.* | Package | GitHub Stats | Description | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ------------------------------------------------------------------:| ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | | [apgorm](https://pypi.org/project/apgorm/) [src](https://github.com/circuitsacul/apgorm/) [docs](https://github.com/circuitsacul/apgorm/wiki) | 17s, 8i, 4pr, 421c @ 2023-07-09<br>v1.0.0b14 @ 2022-11-22 | asyncpg-specific; beta; inactive | | [django](https://pypi.org/project/Django/) | **81772s,** -i, 291pr, 33,208c @ 2024-12-19<br>v5.1.4 @ 2024-12-04 | everyone knows | | [peewee](https://pypi.org/project/peewee/) [src](https://github.com/coleifer/peewee/) [docs](https://docs.peewee-orm.com/en/latest/) | **11272s**, 0i, 0pr, 4646c @ 2024-12-14<br>v3.17.8 @ 2024-12-12 | multi-database; sync-only; active & mature | | [peewee-async](https://pypi.org/project/peewee-async/) [src](https://github.com/05bit/peewee-async/) [docs](https://peewee-async-lib.readthedocs.io/en/latest/) | 736s, 24i, 1pr, 350c @ 2024-09-15<br>v1.0.0 @ 2024-09-18 | multi-database; uses `aiopg`, not `asyncpg`; [semi-retired](https://github.com/05bit/peewee-async/issues/135) | | [piccolo](https://pypi.org/project/piccolo/) [src](https://github.com/piccolo-orm/piccolo/) [site](https://piccolo-orm.com/) [docs](https://piccolo-orm.readthedocs.io/en/latest/) | **1505s,** 123i, 27p, 1853c @ 2024-12-19<br>v1.22.0 @ 2024-10-23 | PG and SQLite; uses `asyncpg`; very nice design<br>see also: [piccolo-admin](https://pypi.org/project/piccolo-admin/, [picolo-api](https://pypi.org/project/piccolo-api/) | | [pony](https://pypi.org/project/pony/) [src]() [docs](https://docs.ponyorm.org/) | **3666s**, 312i, 33pr, 4031c @ 2024-08-27<br>v0.7.19 @ 2024-08-27 | multi-database; sync-only; super-pythonic; semi-active | | [SQLAlchemy](https://pypi.org/project/SQLAlchemy/) [src](https://github.com/sqlalchemy/sqlalchemy/) [docs](https://docs.sqlalchemy.org/en/20/) | **9821s**, 222i, 15pr, 17266c @ 2024-12-18<br>v2.0.36 @ 2024-10-15 | supports everything, does everything, nightmare to learn; uses "Datamapper" pattern; uses type hints/pydantic to define models | | [sqlmodel](https://pypi.org/project/sqlmodel/) [src](https://github.com/fastapi/sqlmodel/) [docs](https://sqlmodel.tiangolo.com/) | **14996s,** 177i, 68pr, 604c @ 2024-12-19<br>v0.0.22 @ 2024-08-31 | uses Pydantic and SQLAlchemy, built by FastAPI team | | [SQLObject](https://pypi.org/project/SQLObject/) [src](https://github.com/sqlobject/sqlobject/) [docs](https://sqlobject.org/) | 147s, 2i, 0pr, 2734c @ 2024-12-19<br>v3.11.0 @ 2023-11-11 | multi-database; sync-only; small, old & semi-active | | [tortoise-orm](https://pypi.org/project/tortoise-orm/) [src](https://github.com/tortoise/tortoise-orm/) [docs](https://tortoise.github.io/) | **4733s**, 486i, 28pr, 1330c @ 2024-12-19<br>v0.22.2 @ 2024-12-09 | multi-database; async-only; uses `asyncpg` (or `psycopg`); inspired by Django; young & active; only ORM to use `pypika` | **By Popularity** ``` 81772 django 14996 sqlmodel 11272 peewee 9821 SQLAlchemy 4733 tortoise-orm 3666 pony 1505 piccolo ``` ## SQL Builders *Stats collected 2024-12-19.* | Package | GitHub Stats | Description | | ---------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------- | ------------------------------------- | | [pugsql](https://pypi.org/project/pugsql/) [src](https://github.com/mcfunley/pugsql/) [docs](https://pugsql.org/) | 711s, 18i, 5pr, 305c @ 2024-10-30<br>v0.3.1 @ 2024-07-29 | for using parameterized SQL, in files | | [PyPika](https://pypi.org/project/PyPika/) [src](https://github.com/kayak/pypika/) [docs](https://pypika.readthedocs.io/en/latest/) | **2566s**, 173i, 45pr, 1043c @ 2024-11-28<br>v0.48.9 @ 2022-03-15 | the best, but also inactive | | [python-sql](https://pypi.org/project/python-sql/) [src](https://code.tryton.org/python-sql/) [discuss](https://discuss.tryton.org/tag/python-sql) | foss.heptapod.net<br>v1.5.2 @ 2024-09-30 | | | [sqlpy](https://pypi.org/project/sqlpy/) [src](https://pypi.org/project/sqlpy/) [docs](https://sqlpy.readthedocs.io/en/latest/) | 9s, i8, 1pr, 111c @ 2019-11-24<br>v0.3.5 @ 2019-11-24 | write SQL in sql files; dead project |