Bulk Insert With SQLAlchemy ORM

SQLAlchemy introduced that in version 1.0.0 :

Bulk operations - SQLAlchemy docs

With these operations, you can now do bulk inserts or updates!

For instance (if you want the lowest overhead for simple table INSERTs), you can use Session.bulk_insert_mappings() :

loadme = [(1, 'a'),

(2, 'b'),

(3, 'c')]

dicts = [dict(bar=t[0], fly=t[1]) for t in loadme]

s = S... See more