a small, expressive orm -- supports postgresql, mysql and sqlite
Alternatives To Peewee
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Strapi52,7292211139 hours ago281May 11, 2022352otherJavaScript
🚀 Strapi is the leading open-source headless CMS. It’s 100% JavaScript, fully customizable and developer-first.
Nocodb35,126310 hours ago110September 06, 2022416agpl-3.0TypeScript
🔥 🔥 🔥 Open Source Airtable Alternative
11 hours ago1,776apache-2.0Java
Free universal database tool and SQL client
Typeorm30,8611,9942,164a day ago650September 20, 20221,930mitTypeScript
ORM for TypeScript and JavaScript. Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Prisma30,12844212 hours ago4,993September 24, 20222,800apache-2.0TypeScript
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite, MongoDB and CockroachDB
Directus20,7755010 hours ago55September 22, 2022352gpl-3.0TypeScript
The Modern Data Stack 🐰 — Directus is an instant REST+GraphQL API and intuitive no-code data collaboration app for any SQL database.
Knex17,36818,0962,78813 hours ago248August 31, 2022811mitJavaScript
A query builder for PostgreSQL, MySQL, CockroachDB, SQL Server, SQLite3 and Oracle, designed to be flexible, portable, and fun to use.
Beekeeper Studio12,696
2 days ago489gpl-3.0Vue
Modern and easy to use SQL client for MySQL, Postgres, SQLite, SQL Server, and more. Linux, MacOS, and Windows.
Migrate11,0815944 days ago129March 17, 2022260otherGo
Database migrations. CLI and Golang library.
Diesel10,140823298a day ago60August 29, 2022122apache-2.0Rust
A safe, extensible ORM and Query Builder for Rust
Alternatives To Peewee
Select To Compare

Alternative Project Comparisons


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

  • a small, expressive ORM
  • python 2.7+ and 3.4+
  • supports sqlite, mysql, postgresql and cockroachdb
  • tons of extensions

New to peewee? These may help:


Defining models is similar to Django or SQLAlchemy:

from peewee import *
import datetime

db = SqliteDatabase('my_database.db')

class BaseModel(Model):
    class Meta:
        database = db

class User(BaseModel):
    username = CharField(unique=True)

class Tweet(BaseModel):
    user = ForeignKeyField(User, backref='tweets')
    message = TextField()
    created_date = DateTimeField(
    is_published = BooleanField(default=True)

Connect to the database and create tables:

db.create_tables([User, Tweet])

Create a few rows:

charlie = User.create(username='charlie')
huey = User(username='huey')

# No need to set `is_published` or `created_date` since they
# will just use the default values we specified.
Tweet.create(user=charlie, message='My first tweet')

Queries are expressive and composable:

# A simple query selecting a user.
User.get(User.username == 'charlie')

# Get tweets created by one of several users.
usernames = ['charlie', 'huey', 'mickey']
users =
tweets =

# We could accomplish the same using a JOIN:
tweets = (Tweet

# How many tweets were published today?
tweets_today = (Tweet
                    (Tweet.created_date >= &
                    (Tweet.is_published == True))

# Paginate the user table and show me page 3 (users 41-60)., 20)

# Order users by the number of tweets they've created:
tweet_ct = fn.Count(
users = (User
         .select(User, tweet_ct.alias('ct'))
         .join(Tweet, JOIN.LEFT_OUTER)

# Do an atomic update (for illustrative purposes only, imagine a simple
# table for tracking a "count" associated with each URL). We don't want to
# naively get the save in two separate steps since this is prone to race
# conditions.
Counter.update(count=Counter.count + 1).where(Counter.url == request.url)

Check out the example twitter app.

Learning more

Check the documentation for more examples.

Specific question? Come hang out in the #peewee channel on, or post to the mailing list, . If you would like to report a bug, create a new issue on GitHub.

Still want more info?

I've written a number of blog posts about building applications and web-services with peewee (and usually Flask). If you'd like to see some real-life applications that use peewee, the following resources may be useful:

Popular Sqlite Projects
Popular Mysql Projects
Popular Data Storage Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.