[Tutor] saving a numpy ndarray in sqlite3

markus kossner m.kossner at tu-bs.de
Mon Dec 21 14:48:59 CET 2009


Dear Folks,
I am wondering about the most efficient way to save a  numpy.ndarray in 
a sqlite3 database file.
I was initially thinking about using the 'buffer' type and creating a 
'blob'  field in the database.
however the .from_buffer() routines in numpy assume the array to be 
recreated  having dimension one.
so if I do not know the shape of the array when reading from the sqlite3 
database, I would have to use
additional fields for storing the array shape. Is there a more 
convenient way?




More information about the Tutor mailing list