Access SQLite db in Spotfire IronPython. Would literally murder for with blocks.

sf_sqlite.py

import clr
clr.AddReferenceToFileAndPath(r'X:\path\to\System.Data.SQLite.dll')
import System.Data.SQLite as sql

try:
    db = sql.SQLiteConnection(r'DataSource=X:\path\to\Chinook_Sqlite.sqlite;Version=3')
    db.Open()
    command = sql.SQLiteCommand('select * from Artist', db)
    try:
        reader = command.ExecuteReader()
        try:
            while reader.Read():
                print reader['Name']
        finally:
            reader.Dispose()
    finally:
        command.Dispose()
    db.Close()
finally:
    db.Dispose()

Thanks a million. This helped a lot