[sqlite] Thoughts on storing arrays of complex numbers (Solved)

2015-04-27 Thread Nathan F
rg] On Behalf Of Scott Hess > > > Sent: Friday, April 24, 2015 3:19 PM > > > To: General Discussion of SQLite Database > > > Subject: Re: [sqlite] Thoughts on storing arrays of complex numbers > > > (Solved) > > > > > > On Fri, Apr 24, 2015 at 12

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

2015-04-26 Thread Joe Mucchiello
I'm surprised no one suggested a virtual table interface to the OP's blob. Store the blob of complex numbers as a blob in raw form (he said it was a single platform so endian concerns don't matter) and then create a virtual table that provides the array index into the complex numbers. Add a few

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

2015-04-25 Thread Drago, William @ CSG - NARDA-MITEQ
houghts on storing arrays of complex numbers > (Solved) > > On Fri, Apr 24, 2015 at 12:01 PM, Drago, William @ CSG - NARDA-MITEQ > wrote: > > Since the data is received from the analyzer as an array of > > real/imaginary pairs (R,I,R,I,R,I,R,I...), 3202 elements tot

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

2015-04-25 Thread Jim Callahan
to:sqlite- > > users-bounces at mailinglists.sqlite.org] On Behalf Of Scott Hess > > Sent: Friday, April 24, 2015 3:19 PM > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] Thoughts on storing arrays of complex numbers > > (Solved) > > > > On Fri, A

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

2015-04-24 Thread Drago, William @ CSG - NARDA-MITEQ
All, I always learn something from this group even when the answers don't directly solve my problem, and for that I am always thankful. Perhaps I should have included more information about what I'm trying to accomplish and/or phrased the question differently. That might have saved some time

[sqlite] Thoughts on storing arrays of complex numbers (Solved)

2015-04-24 Thread Scott Hess
On Fri, Apr 24, 2015 at 12:01 PM, Drago, William @ CSG - NARDA-MITEQ wrote: > Since the data is received from the analyzer as an array of > real/imaginary pairs (R,I,R,I,R,I,R,I...), 3202 elements total, > that's how I will blob and store it. This is the simplest way > to add it to the database.