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
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
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto: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] T
s-bounces at mailinglists.sqlite.org] On Behalf Of Jim Callahan
> Sent: Saturday, April 25, 2015 1:37 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Thoughts on storing arrays of complex numbers
>
> Keith is close.
>
> I would suggest two tables: Elements and Arrays.
>
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
n Behalf Of Drago, William @ CSG -
> > NARDA-MITEQ
> > Sent: Friday, 24 April, 2015 09:38
> > To: General Discussion of SQLite Database
> > Subject: [sqlite] Thoughts on storing arrays of complex numbers
> >
> > All,
> >
> > I'm trying to avoid re-in
* Steven M. McNeese:
> I would serialize to JSON and store as a string.
You need to be careful about the choice of JSON library, many of them
lose information when converting doubles to JSON.
s-bounces at mailinglists.sqlite.org] On Behalf Of James K. Lowden
> Sent: Friday, April 24, 2015 12:42 PM
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Thoughts on storing arrays of complex numbers
>
> On Fri, 24 Apr 2015 13:37:40 +
> "Drago, William @ CSG - NARDA
-users-
> bounces at mailinglists.sqlite.org] On Behalf Of Drago, William @ CSG -
> NARDA-MITEQ
> Sent: Friday, 24 April, 2015 09:38
> To: General Discussion of SQLite Database
> Subject: [sqlite] Thoughts on storing arrays of complex numbers
>
> All,
>
> I'm tryin
On Fri, Apr 24, 2015 at 3:37 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:
> I'm trying to avoid re-inventing the wheel. Is there a best or generally
> accept way to store arrays of complex numbers? I'm considering the
> following:
>
> I could have two blob fields
All,
I'm trying to avoid re-inventing the wheel. Is there a best or generally accept
way to store arrays of complex numbers? I'm considering the following:
I could have two blob fields in my table. One for the real parts and one for
the imaginary. (I don't like this.)
Or, I could use a single
On Fri, 24 Apr 2015 13:37:40 +
"Drago, William @ CSG - NARDA-MITEQ" wrote:
> I'm trying to avoid re-inventing the wheel. Is there a best or
> generally accept way to store arrays of complex numbers?
A table in First Normal Form has no repeating groups. That means no
row has an array of
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.
>I could have two blob fields in my table. One for the real parts > and one
for the imaginary. (I don't like this.)
Could you be more specific about what is not to like?
A. Does it limit your ability to use SQL?
B. Does it cause problems for the language interface?
C. Is it harder to do data
of SQLite Database
Subject: [sqlite] Thoughts on storing arrays of complex numbers
All,
I'm trying to avoid re-inventing the wheel. Is there a best or generally
accept way to store arrays of complex numbers? I'm considering the
following:
I could have two blob fields in my table. One for the real
If you are working with linear algebra type matrices, then simply make a
column that represents each element. For example, a Jones matrix which
is 2x2 would have four columns. Then each set of matrices are
represented by a row. Best way to handle is to visualizes how you would
use the
16 matches
Mail list logo