A thin pandas/database-backed web app

bombdiggity.py

#!/usr/bin/env python

from pandas.io.sql import read_sql
import MySQLdb
from flask import Flask

app = Flask(__name__)
qry = "select * from adh_bayescomp_msn limit 100"
db = MySQLdb.connect(read_default_file="~/.my.cnf.quark")

@app.route('/')
def index():
    df = read_sql(qry, db)
    return df.to_html()

app.run(debug=True)