peewee

a little orm

peewee License unclear Active ★ 11,984 v4.3.0 released 2026-07-31

Install

peewee on PyPI

pip

pip install peewee

uv

uv add peewee

poetry

poetry add peewee

Package facts

License	not declared (unclear)
Python support	supports the current Python release (>=3.8)
Install friction	low — pure-Python wheel
Runtime dependencies	none
Maintenance	actively maintained — 13 days since the last release
Last repo commit	2026-08-13
First released	2010-10-18
Popularity	one of the top 1,000 most-downloaded packages on PyPI (30-day window, as of 2026-08-13)
Known vulnerabilities	none known (OSV.dev, checked 2026-08-13)

Evidence: peewee-4.3.0-py3-none-any.whl

Development Status :: 5 - Production/StableIntended Audience :: DevelopersOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: Python :: Implementation :: CPythonProgramming Language :: Python :: Implementation :: PyPyTopic :: DatabaseTopic :: Database :: Front-EndsTopic :: Software Development :: Libraries :: Python Modules

About peewee

from the package's own PyPI description — quoted content, verbatim

.. image:: https://media.charlesleifer.com/blog/photos/peewee4-logo.png

peewee

Peewee is a simple and small ORM. It has few (but expressive) concepts, making it easy to learn and intuitive to use.

Peewee is a single module with no required dependencies and has been running production workloads of all sizes since 2010.

a small, expressive ORM
flexible query-builder that exposes full power of SQL
supports sqlite, mysql, mariadb, postgresql
asyncio support <https://docs.peewee-orm.com/en/latest/peewee/asyncio.html>__ built on the standard async drivers (aiosqlite, asyncpg, aiomysql)
tons of extensions
use with flask <https://docs.peewee-orm.com/en/latest/peewee/framework_integration.html#flask>, fastapi <https://docs.peewee-orm.com/en/latest/peewee/framework_integration.html#fastapi>, pydantic <https://docs.peewee-orm.com/en/latest/peewee/orm_utils.html#module-playhouse.pydantic_utils>, and more <https://docs.peewee-orm.com/en/latest/peewee/framework_integration.html>.

New to peewee? These may help:

Quickstart <https://docs.peewee-orm.com/en/latest/peewee/quickstart.html#quickstart>_
`Example twitter app...

Read as markdown · JSON record · Source repository · Docs

AI interpretation — verify before relying

AI-generated interpretation of the package facts above; every digit, version, license, or vulnerability id it cites is grounded in the facts already shown on this page

Peewee is a lightweight ORM that maps Python classes to database tables, supporting SQLite, MySQL, MariaDB, and PostgreSQL with optional asyncio support through standard async drivers.

Installation is frictionless—peewee is a pure-Python wheel with zero runtime dependencies and has maintained active development since 2010, with a recent release 13 days ago.

License treatment is unclear; the fact sheet does not specify a license identifier, so you should verify the actual license terms before adopting peewee in a commercial or restricted context.

Usage

pip install peewee

from peewee import *
db = SqliteDatabase('my_database.db')
class User(Model):
    username = CharField()
    class Meta:
        database = db
db.create_tables([User])
user = User.create(username='alice')

Python 3.8 or later required; asyncio features require additional optional dependencies (aiosqlite, asyncpg, or aiomysql).

Verdict: Peewee is a mature, actively maintained ORM with no dependencies and broad database support, making it a low-friction choice for projects needing a simple query layer. However, verify the license terms before use, as the fact sheet does not clarify the license under which it is distributed.

Needs verification

What is the actual license under which peewee is distributed (MIT, Apache, GPL, or other)?
Are there any known security advisories or CVEs not yet indexed in OSV?

lightweight orm pythonsql object relational mappingsqlite mysql postgres ormasync database ormsimple python database layerquery builder ormflask fastapi database orm