Fast, thread safe Python ORM?

Question

Can you recommend a high-performance, thread-safe, and stable ORM for Python? The data I need to work with is not complicated, so SQLAlchemy is probably redundant.

Answer 1

If you are looking for something high, and based on one of your comments, "something that can handle> 5k requests per second." You should keep in mind that ORM is not built specifically for speed and performance; it is built for usability. If the data is so basic that even SqlAlchemy can be excessive, and you mostly write, it might be easier to just do direct inserts and skip ORM altogether.

Answer 2

peewee orm is fast and extremely lightweight, can be a good option if SQA is too heavy.

Answer 3

SqlAlchemy SqlSoup SqlAlchemy . "" , .

Answer 4

You can use a more declarative layer on top of SQLAlchemy, like Elixir , or look at Storm , which is also a bit more declerative than SQLAlchemy.

The latter was designed for and used by sites such as the Ubuntu / Canonical launchpad , so it should scale well.