Skip to main content

Storm integration for Flask.

Project description


Test status Documentation status PyPI version status

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.

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


$ pip install flask_storm[fancy]

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

$ 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.


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

Project details

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
Flask_Storm-0.1.2-py2.py3-none-any.whl (12.2 kB) Copy SHA256 hash SHA256 Wheel py2.py3 Jun 14, 2017
Flask-Storm-0.1.2.tar.gz (23.2 kB) Copy SHA256 hash SHA256 Source None Jun 14, 2017

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page