Andreas Runfalk

Flask-Storm

Flask-Storm simplifies the use of the Storm ORM in Flask. It automatically opens and closes database connections on demand when requests need them. For debugging and query testing there is integration with flask shell. Whenever a query is executed in the shell it is printed with nice formatting and syntax highlighting.

>>> store.find(Message).any()
SELECT messages.eid,
       messages.id,
       messages.text,
       messages."time"
FROM messages
LIMIT 1;
-- SUCCESS in 11.771 ms
<Message id="1" text="Foobar">

It used by my company's product Permutar to manage all database connections. Though I'm happy with it, I can't recommend it for new projects since Storm doesn't support Python 3 and haven't had a release since 2013. The only reason to use it is if your project is already heavily invested in Storm.