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 isn't complex, so SQLAlchemy is probably an overkill.

score 7 · Accepted Answer · answered Aug 31 '10 at 13:48

7

If you are looking for something thats high performance, and based on one of your comments "something that can handle >5k queries per second". You need to keep in mind that an ORM is not built specifically for speed and performance, it is built for maintainability and ease of use. If the data is so basic that even SqlAlchemy might be overkill, and your mostly doing writes, it might be easier to just do straight inserts and skip the ORM altogether.

answered Aug 31 '10 at 13:48

Tanerax

5,826
5
29
27

1

Thanks. I will also explore the possibility of switching to memcachedb for simple key-value pairs and fancy stuff like Cassandra for the rest if it will improve performance significantly without taking too much time to write. – dpq Sep 01 '10 at 13:44

score 7 · Answer 2 · answered Oct 31 '11 at 04:04

7

The peewee orm is fast and extremely lightweight, might be a good fit if SQA is too heavy.

answered Oct 31 '11 at 04:04

coleifer

24,887
6
60
75

score 2 · Answer 3 · answered Aug 31 '10 at 09:25

2

SqlAlchemy's SqlSoup module skips most of the tediousness of SqlAlchemy's mapping and session overhead. You can pretty much 'dive' straight in, take a look.

answered Aug 31 '10 at 09:25

NeonNinja

450
4
10

score 1 · Answer 4 · answered Aug 31 '10 at 09:41

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

The latter was developed for and is used by sites such as Ubuntu/Canonical's launchpad, so it should scale well.

Fast, thread-safe Python ORM?

4 Answers4