TOtosh·Sep 15, 2024Submission
Peewee: A small, expressive ORM (PostgreSQL, MySQL, SQLite, CockroachDB)
2 points · Open discussioncoleifer
peewee
Python2012–2024
coleifer / peewee
peewee
a small, expressive orm -- supports postgresql, mysql, sqlite, now with asyncio
17Distinct people
21Mentions
1Explicit recommenders
12KGitHub stars
What to know before exploring
What it is
a small, expressive orm -- supports postgresql, mysql, sqlite, now with asyncio
GitHub
Where it is used
No documented product use was verified in the last source check.
What people are saying
SQLAlchemy is great, but for those who are looking for something lighter, I highly recommend Peewee (https://github.com/coleifer/peewee). It's a very well maintained alternative.
csytan used a recommendation phrase. One indexed comment matches. This is a phrase match, not a verdict.
No classified warning is attached to this page. Read the discussions before treating silence as approval.
Also in these discussions
- coleifer/huey · linked in 2 of the same discussions
Mentioned in the same Hacker News threads. That is not proof they are substitutes.
This week on Hacker News
Nov 7–Nov 14 UTC · Direct repository links and separately labeled related project stories. Indexed through 11/14/2026, 3:56:07 PM UTC.
No direct repository links were found in the indexed HN discussions over the past seven days. Older discussions are available below.
Mentions over time
HN mentions by year21 dated mentions
Observed mentions: 2012-01-30 02:07:48 UTC to 2024-09-15 16:37:10 UTC.
Counts come from the repository’s dated source evidence. Index cutoff: 2026-11-02 08:16:59 UTC.
View mention counts and date ranges
| Period | Start (UTC) | End (exclusive, UTC) | Mentions | Submissions | Comments |
|---|---|---|---|---|---|
| 2012 | 2012-01-01 00:00:00 UTC | 2013-01-01 00:00:00 UTC | 2 | 0 | 2 |
| 2013 | 2013-01-01 00:00:00 UTC | 2014-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2014 | 2014-01-01 00:00:00 UTC | 2015-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2015 | 2015-01-01 00:00:00 UTC | 2016-01-01 00:00:00 UTC | 4 | 0 | 4 |
| 2016 | 2016-01-01 00:00:00 UTC | 2017-01-01 00:00:00 UTC | 3 | 0 | 3 |
| 2017 | 2017-01-01 00:00:00 UTC | 2018-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2018 | 2018-01-01 00:00:00 UTC | 2019-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2019 | 2019-01-01 00:00:00 UTC | 2020-01-01 00:00:00 UTC | 4 | 0 | 4 |
| 2020 | 2020-01-01 00:00:00 UTC | 2021-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2021 | 2021-01-01 00:00:00 UTC | 2022-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2022 | 2022-01-01 00:00:00 UTC | 2023-01-01 00:00:00 UTC | 0 | 0 | 0 |
| 2023 | 2023-01-01 00:00:00 UTC | 2024-01-01 00:00:00 UTC | 1 | 0 | 1 |
| 2024 | 2024-01-01 00:00:00 UTC | 2025-01-01 00:00:00 UTC | 2 | 1 | 1 |
What Hacker News says
21 sourcesAs opposed to? FWIW the author has many Python tools, including a popular ORM (https://github.com/coleifer/peewee)
In SQLite-Web: Web-based SQLite database browser written in PythonHave a look to peewee: https://github.com/coleifer/peewee
In Any Python ORMs worthy of production?Recutils is really handy when coupled with command-line tools that return structured data.
`guix search`[^] outputs data in recutils format, so if you are searching for a database driver for Python, but want to filter out "python2" variants, and ignore uninteresting fields such as versions or dependencies, you can do:
$ guix search python mysql | recsel -q 'python-' -p name,synopsis,homepage
name: python-mysqlclient
synopsis: MySQLdb is an interface to the popular MySQL database server for Python
homepage: https://github.com/PyMySQL/mysqlclient-python
name: python-pymysql
synopsis: Pure-Python MySQL driver
homepage: https://github.com/PyMySQL/PyMySQL/
name: python-peewee
synopsis: Small object-relational mapping utility
homepage: https://github.com/coleifer/peewee/
Without recsel, the output is 100 lines long, with
Read the rest
lots of duplication between the Python 2 and 3 variants.
[^] GNU Guix is a package manager that works on top of any GNU/Linux distribution.
Very interesting. I myself was dealing with a Java project I need to maintain for legacy reasons on MySql 5.1. I Just spoon up a Django project aside, and used Peewee[0] to access without changes the DB. Works like a charm and easily integrated in Django midleware.
[0]: https://github.com/coleifer/peewee/issues/1995
In Django 3Ha! Glad to see Peewee mentioned. In two bullet points: predictable apis, compostable pieces...or, learn once, apply anywhere. Or jOOQ but python. Take your pick!
If code is your thing, Peewee has quite a few examples:
https://github.com/coleifer/peewee/tree/master/examples
In To ORM or Not to ORM"peewee" - https://github.com/coleifer/peewee
In SQL databases come up with algorithms you’d never have dreamed of (2017) [video]Here is the list of closed issues/PRs said CTO made in case anyone was curious: https://github.com/coleifer/peewee/issues?q=author%3Akeredso...
In Matz: We are mere mortals> These kinds of dismissive comments make me wonder if the writer ever created anything of substance in their life.
Ad hominem [0].
And he has. I use the things he has built in production. He has contributed to Python community (and SQLite) to a great extent. Some of the amazing things he built [1], [2], [3].
[0] - https://yourlogicalfallacyis.com/ad-hominem
[1] - https://github.com/coleifer/peewee
[2] - https://github.com/coleifer/huey
[3] - https://github.com/coleifer/sqlite-web
In Abricotine – WYSIWYM Markdown editor – open source and cross platformWhy, my own of course! Peewee[1] is a lightweight ORM, and Huey[2] is a task queue.
[1]: https://github.com/coleifer/peewee
[2]: https://github.com/coleifer/huey
In Ask HN: What are some examples of good code?It's apparently been fixed by not building the C versions under pypy:
https://github.com/coleifer/peewee/issues/1118
In PyPy2.7 v5.6 released – stdlib 2.7.12 support, C-API improvements, and morePeewee [1] is my tool of choice because of its convenience and flexibility combined. I can create pretty complex queries using its Query API, but also execute arbitrary queries when I know I need something a little more nonstandard. Plus the maintainer (Charles Leifer) is an awesome dude who has always been really helpful to his users.
[1] Peewee: https://github.com/coleifer/peewee
In Records: Python library for making raw SQL queries to Postgres databasesI see this pattern all the time on GitHub. A promising project starts to catch a lot of stars. Issues start piling up, and the developer no longer looks forward to working on the project because of they have a boatload of issues to deal with first.
An issue is much like an email. Closing an issue requires communicating with (sometimes unreasonable) people. Furthermore, when issues start piling up, critical issues are hidden alongside less important ones making it even more difficult to prioritize.
One way of dealing with things is to maintain inbox zero. Take action right away - delegate, archive or save for a later date. This won't work forever though as your project's userbase grows.
Two high quality libraries with benevolent dictators handle issues very differently:
Peewee (coleifer): https://github.com/coleifer/peewee/issues
Tornado (
Read the rest
bdarnell): https://github.com/tornadoweb/tornado/issues
I haven't tried it, but the choice to include the entire application in one file is ... interesting.
https://github.com/coleifer/peewee/blob/master/peewee.py
In Reasons to love SQLAlchemySQLAlchemy is great, but for those who are looking for something lighter, I highly recommend Peewee (https://github.com/coleifer/peewee). It's a very well maintained alternative.
In Reasons to love SQLAlchemyShowing the 15 most recent of 21 sources. Enable JavaScript to search and browse every indexed mention.