Skip to main content
This is a pre-production deployment of Warehouse. Changes made here affect the production instance of PyPI (
Help us improve Python packaging - Donate today!

Storm integration for Flask.

Project Description
|test-status| |documentation-status| |pypi-version|

Flask-Storm is an extension for `Flask <>`_ that adds support for Canonical's ORM `Storm <>`_ to your application. Flask-Storm automatically opens and closes database connections on demand when requests need them.

Access to the database is done using the `store` `application context local <>`_. Within an application context this variable holds a reference to a Storm Store instance. If no connection is opened it will automatically open one. When the application context is torn down, normally after the request has returned, the store is closed.

.. code-block:: python

from flask_storm import store
from storm.locals import Int, Unicode

class User(object):
__storm_table__ = "users"

id = Int(primary=True)
name = Unicode()

def index():
# Get name of user with ID 1
return store.get(User, 1).name


.. code-block:: bash

$ pip install flask_storm[fancy]

This installs Flask-Storm with SQL highlighting and reformatting support. If you do not want this drop the ``fancy``.

.. code-block:: bash

$ pip install flask_storm

Documentation is available on `<>`_

Why not Python 3
Sadly Storm is not Python 3 compatible, which is why it doesn't make sense to make Flask-Storm compatible yet.

.. |test-status| image::
:alt: Test status
:scale: 100%

.. |documentation-status| image::
:alt: Documentation status
:scale: 100%

.. |pypi-version| image::
:alt: PyPI version status
:scale: 100%

.. Include changelog on PyPI

Version are structured like the following: ``<major>.<minor>.<bugfix>``. Unless
explicitly stated, changes are made by
`Andreas Runfalk <>`_.

Version 0.1.2
Released on 14th June 2017

- Fixed an issue with query logging in ``flask shell`` and PostgreSQL

Version 0.1.1
Released on 9th June 2017

- Fixed issue with new versions of sqlparse by bumping its version requirement

Version 0.1.0
Released on 19 July 2016

- Initial release

Release History

Release History

This version
History Node


History Node


History Node


Download Files

Download Files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

File Name & Checksum SHA256 Checksum Help Version File Type Upload Date
Flask_Storm-0.1.2-py2.py3-none-any.whl (12.2 kB) Copy SHA256 Checksum SHA256 py2.py3 Wheel Jun 14, 2017
Flask-Storm-0.1.2.tar.gz (23.2 kB) Copy SHA256 Checksum SHA256 Source Jun 14, 2017

Supported By

WebFaction WebFaction Technical Writing Elastic Elastic Search Pingdom Pingdom Monitoring Dyn Dyn DNS Sentry Sentry Error Logging CloudAMQP CloudAMQP RabbitMQ Heroku Heroku PaaS Kabu Creative Kabu Creative UX & Design Fastly Fastly CDN DigiCert DigiCert EV Certificate Rackspace Rackspace Cloud Servers DreamHost DreamHost Log Hosting