Using multiple ORMs? - And SQLalchemy vs Pony vs Peewee vs stdnet vs …


Alec Taylor

Investigating possible using multiple ORMs in my project.

Toy project, want to make it as generic as humanly possible; whilst
still exposing abstract pythonic interfaces.

E.g.: support most number of backends, including SQL ones like:
Postgres, SQLite, MySQL, … and NoSQL ones such as Redis (using

One way of doing this is to write generic Python libraries; with
different models, insert and query lines for each of the backend ORMs.

What are your thoughts on this?

Additionally, there are a variety of new ORMs popping up, what are
your thoughts on them; and is there something other than the 4
mentioned in the subject which I should look into?

Thanks for all suggestions,

Alec Taylor



Wolfgang Keller

Thanks for all suggestions,

Two essential criteria:

If an ORM only allows 1:1 mapping between classes and tables à la
"active record", then it's entirely pointless.

And if an ORM allows only surrogate keys, then its developers don't
have a clue of databases or they don't give a darn. Or both.



Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question