numpy array <=> python DB-API adapter? numpy array <=> python DB-API adapter? sqlite sqlite

numpy array <=> python DB-API adapter?


Can you use the default package, sqlite3?

In [1]: import sqlite3In [3]: conn = sqlite3.connect('test.db')In [4]: cur = conn.cursor()In [5]: cur.execute('select * from table1')Out[5]: <sqlite3.Cursor object at 0xa3142c0>In [6]: scipy.array(cur.fetchall())Out[6]: array([[ 1.,  2.],       [ 3.,  4.]])