coleifer/peewee

★ 11,967PythonAudience · developerComplexity · 2/5Setup · easy

Mindmap

mindmap
  root((Peewee ORM))
    Databases
      SQLite built-in
      PostgreSQL MySQL
      MariaDB
    Core Features
      Model definitions
      Query chaining
      Joins and filters
      Atomic updates
    Extensions
      Full-text search
      Encrypted databases
      Connection pooling
    Integrations
      Flask FastAPI
      Pydantic async
    Setup
      pip install peewee
      No extra infra

mindmap root((Peewee ORM)) Databases SQLite built-in PostgreSQL MySQL MariaDB Core Features Model definitions Query chaining Joins and filters Atomic updates Extensions Full-text search Encrypted databases Connection pooling Integrations Flask FastAPI Pydantic async Setup pip install peewee No extra infra

Click or tap to explore — scroll the page freely

Things people build with this

USE CASE 1

Define database tables as Python classes and create, read, filter, sort, and update records without writing any SQL.

USE CASE 2

Add database storage to a Flask or FastAPI web app using Peewee's simple model definitions and connection pooling extension.

USE CASE 3

Use async database access in a high-concurrency Python application that handles many simultaneous requests.

USE CASE 4

Add full-text search or encrypted database support using Peewee's built-in extension modules.

Tech stack

PythonSQLitePostgreSQLMySQLMariaDBCython

Getting it running

Difficulty · easy Time to first run · 5min

In plain English

Peewee is a Python library that lets you work with databases without writing raw SQL. Instead of typing out database commands manually, you define your data as Python classes and Peewee translates your code into the right database instructions automatically. This approach is called an ORM, short for Object-Relational Mapper. The library supports four popular databases: SQLite (which requires no extra setup and is built into Python), MySQL, MariaDB, and PostgreSQL. You can also run Peewee in async mode if your application needs to handle many tasks at the same time. Once installed, it fits naturally alongside web frameworks like Flask and FastAPI, as well as data validation tools like Pydantic. Setting up a database table in Peewee means writing a short Python class. For example, a User table becomes a User class with fields like username. A Tweet table can reference User with a single line. After that, you call a connect step and a create tables step, and the database is ready to use. Creating, reading, filtering, and sorting records all use Python syntax rather than raw SQL strings, which reduces the chance of mistakes and makes the code easier to read. Queries can be chained and combined. You can filter records by one or more conditions, join tables together, count results, paginate through large sets, or perform atomic updates that are safe against race conditions. The README includes working code samples for all of these patterns, plus links to a full example app modeled after Twitter. Beyond the core library, Peewee ships with a wide set of extensions covering things like full-text search, encrypted databases via SQLCipher, and connection pooling. The author has also published blog posts showing Peewee used in real apps: note-taking tools, analytics services, password managers, and pastebins. Installation is a single pip command, and the documentation site covers every feature in depth.

Copy-paste prompts

Prompt 1

Using Peewee with SQLite, show me how to define User and Post models where a Post belongs to a User, then write queries to get all posts by a specific user ordered by date.

Prompt 2

I'm building a FastAPI app and want to use Peewee with PostgreSQL. Show me how to set up connection pooling and define a model for a tasks table with status filtering.

Prompt 3

How do I safely increment a counter column in Peewee without a race condition? Show me the atomic update pattern for a views field.

Prompt 4

I need to paginate through a large Peewee query result in a Flask endpoint. Show me how to use Peewee's paginate method and return JSON to the client.

Prompt 5

How do I use Peewee's full-text search extension with SQLite to search across a title and body column in a notes table?

Open on GitHub → Explain another repo

← coleifer on gitmyhub — every repo by this author, as a profile.

Verify against the repo before relying on details.