Flask SQLAlchemy Session

This is a Database Session storage interface for Flask with SQLAlchemy

How to use

First you will have to create the sessions table

CREATE TABLE sessions (
  session_id CHAR(129) UNIQUE NOT NULL,
  atime      TIMESTAMP,
  data       TEXT);

Then you will have to connect the interface to your Flask application

from FlaskSQLAlchemySession import set_db_session_interface
application.config['SQLALCHEMY_DATABASE_URI'] = "[your-sqlalchemy-db-uri]"
set_db_session_interface(application)

By default, the data is stored using pickle module, but you can pass other data serializer like JSON module

import json
from FlaskSQLAlchemySession import set_db_session_interface
application.config['SQLALCHEMY_DATABASE_URI'] = "[your-sqlalchemy-db-uri]"
set_db_session_interface(application, data_serializer=json)

Requirements

• Flask
• Flask-SQLAlchemy