Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python

Posted by Y B
Y B
14,136 Points

Suitable Python ORM in production

I'm currently working through the new python peewee course, but was curios to know if this was a suitable ORM for use in production?

(Hmm so not much use without mentioning what sort of production - let's say for working with financial data for a PFM type product as an example - so fairly high level of well structured data).

Would SQL alchemy be the best/only solution? Or would PonyORM also be useful (or peewee)?

Thanks.

3 Answers

Charles Leifer
Charles Leifer
152 Points

Author of peewee here, and yes, it has been deployed in production environments. SQLAlchemy has a bigger community and a lot more features, so if you're concerned you could always use that instead. PonyORM I would stay away from, but that's personal opinion. It uses a lot of very deep magic and has some strange licensing rules.

Kenneth Love
STAFF
Kenneth Love
Treehouse Guest Teacher
Kenneth Love
Kenneth Love
Treehouse Guest Teacher

Unless there's some specific shortcoming or feature of a particular ORM, they should all be fine.

Y B
Y B
14,136 Points
Y B
Y B
14,136 Points

That's great thanks for the feedback (particularly on PonyORM as I was considering that at one point). And thanks for all the your work on peewee!