Mike McGonagle wrote:
Basically, I am trying to connect SQLite up to Pure Data (a dataflow
programming language), and I am creating arbitrary lists of floating point
numbers that I would like to be able to store as sets. The SQL code from my
original message is what I am currently using for the array stuff. Just one
big table with each element tagged for grouping and another for their order.
It sounds like what you described would be great, if it were only in SQLite.
I had thought about the idea of creating everything as a long string,
separated by a space, and storing them as a group. I just wasn't sure if
this was the "accepted" way to do it in SQL.
Mike,
Do you need to be able to access the individual array elements with SQL
statements, or do you simply need to save and restore entire arrays?
If the latter is the case, you should look at storing your entire
floating point array directly into the database as a BLOB. You will have
one database record for each array, and loading and saving an array is
very straight forward.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
