Flask Debug Toolbar SQLAlchemy Extension
Enable Flask-DebugToolbar’s SQLAlchemy pane for CKAN.
Requirements
- CKAN 2.9 or 2.10
- flask-sqlalchemy~=2.5.0
Note: The latest version (v3.0) of flask-sqlalchemy is only partially supported. While it shows all the queries, SELECT and EXPLAIN links for individual queries do not work.
Features
- SQLAlchemy panel in Flask Debug Toolbar
- View all database queries on a page
- SELECT and EXPLAIN links for individual queries (requires flask-sqlalchemy~=2.5.0)
- Performance debugging and analysis
Installation
pip install 'ckanext-fdt-sqlalchemy[deps]'
Add fdt_sqlalchemy to ckan.plugins in your CKAN config file.
Developer Installation
git clone https://github.com/ckan/ckanext-fdt-sqlalchemy.git
cd ckanext-fdt-sqlalchemy
python setup.py develop
Note
This is an official CKAN extension for development/debugging purposes. Do not use in production environments with the debug toolbar enabled.