Re: [sqlite] Inserting python data structues into database

2006-06-01 Thread John Stanton
Not the question. You probably chose to store it in an SQL DBMS so that you can use the DML to access the data in some way. Do you want to access individual array rows, individual array elements or just store and retrieve the entire array? jt wrote: From pysqlite http://initd.org/tracker/py

Re: [sqlite] Inserting python data structues into database

2006-06-01 Thread jt
From pysqlite http://initd.org/tracker/pysqlite. On 6/2/06, John Stanton <[EMAIL PROTECTED]> wrote: Python newsgroup wrote: > Hi, > > What is the most efficient way to enter python binary data such as lists or > dictionaries in to sqlite? Has anyone had any experiences with this? We > will > be

Re: [sqlite] Inserting python data structues into database

2006-06-01 Thread John Stanton
Python newsgroup wrote: Hi, What is the most efficient way to enter python binary data such as lists or dictionaries in to sqlite? Has anyone had any experiences with this? We will be inserting a list of lists of integers into our database. For example: [[1,2,3],[1,4,6],[1,1,1],[2,4,6],[12,32,

Re: [sqlite] Inserting python data structues into database

2006-06-01 Thread jt
Try the pickle module, it dumps nearly any datastruct (except file object) in a string. You can load it back afterwards. On 6/1/06, Python newsgroup <[EMAIL PROTECTED]> wrote: Hi, What is the most efficient way to enter python binary data such as lists or dictionaries in to sqlite? Has anyone h

[sqlite] Inserting python data structues into database

2006-06-01 Thread Python newsgroup
Hi, What is the most efficient way to enter python binary data such as lists or dictionaries in to sqlite? Has anyone had any experiences with this? We will be inserting a list of lists of integers into our database. For example: [[1,2,3],[1,4,6],[1,1,1],[2,4,6],[12,32,4],...,[1,3,4]] Any sugges