Python Bottle SQLite Version

gistfile1.py

from bottle import route, run, install
from bottle_sqlite import SQLitePlugin

install(SQLitePlugin(dbfile='bottle.db'))

@route('/db/')
def database(db):
    data = db.execute('SELECT SQLITE_VERSION()').fetchone()
    print "SQLite version: %s" % data      

run(host='localhost', port=8080)

This works:

from bottle import route, run, redirect,install, template
import sqlite3 as lite
import sys

@route('/db/')
def database():
    con = lite.connect('test.db')

    with con:

        cur = con.cursor()    
        cur.execute('SELECT SQLITE_VERSION()')

        data = cur.fetchone()

        return "SQLite version: %s" % data              

run(host='localhost', port=8080)