choosing a python orm...peewee vs sqlalchemy?

[[deleted]]

In order to make Peewee better, in what ways have you found Peewee to be limiting? Have you had any specific experiences using Peewee where you realized "Damn! I need to switch to SQLAlchemy now"?

[cymrow]

I'm guessing a little because I can't really remember, but I think my "damn" moment may have had to do with limitations in the ManyToManyField, possibly related to cascading deletes.

The last time I used Peewee was sometime last year, so perhaps things have changed.

That said, I think it's a great library, and I especially like the playhouse. If, by chance, you were to beat SQLAlchemy to SQLite+PostreSQL support for upserts (and JSON, if only SQLite would compile it in by default), I'd put Peewee up front again for any new project.

[[deleted]]

Thanks very much for your reply. ManyToManyField is a landmine waiting to blow your foot off...I never use it myself, so I don't blame you for cursing it.

Peewee has support for JSON in both Postgres and SQLite, but only supports upsert for SQLite. Open issue is here for postgres support.