On Jan 16, 2008 2:18 PM, Dennis Cote <[EMAIL PROTECTED]> wrote: > 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?
The arrays are a set, so they would never be addressed as individual elements. > > > 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. Well, this is what I would like to do, but currently my usage of SQLite doesn't include support for Blobs. That will be in version 2. Time to get to writing some code... Thanks, Mike > > > HTH > Dennis Cote > > > > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > -- Peace may sound simple—one beautiful word— but it requires everything we have, every quality, every strength, every dream, every high ideal. —Yehudi Menuhin (1916–1999), musician
