[sqlite] building SQLite DLL with Visual C++

[Drago, William @ CSG - NARDA-MITEQ]

I don't know what error you're getting so I can't offer specific help.

This is what works for us:

Open your project in Visual Studio.

Click Tools > NuGet Package Manager > Manage NuGet Packages for Solution...

Select Online > nugget.org

In the search box enter system.data.sqlite

A list of packages should be displayed after a short wait.

Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and Entity 
Framework support, select System.Data.SQLite (x86/x64), then click Install
(we use Core here)

After installation you should see a little green checkmark next to the package 
you selected.

Click Close and you're done. Check on line for VB.NET code samples using SQLITE.

Good luck,

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com



> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> Sent: Saturday, April 25, 2015 3:50 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] building SQLite DLL with Visual C++
>
> Hi Bill
>
> I have been trying for 2 days and I am totally lost.
>
> I have NuGet Package Manager. I don't know how to use it.
>
> From the  PM>   System.Data.SQLiteI get an error.
>
> Can you be a little more specific.
>
> Jay
>
> On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
> William.Drago at l-3com.com> wrote:
>
> > > -Original Message-
> > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > > Sent: Thursday, April 23, 2015 3:47 PM
> > > To: General Discussion of SQLite Database
> > > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> > >
> > > Thank you Adam for responding to my post. I have the windows
> > > binaries downloaded.
> > >
> > > At this point I am just following the instructions in the book. And
> > > I really am not sure what I need the dll for.
> > >
> > > Here's the scenario. I have created a program in vb2012. The
> program
> > > stores less than 20 fields of data. I am currently saving the data
> > > in a html format. I just recently discovered SQLite. I am now in
> the
> > > process of changing over to a database to store data. I studied SQL
> > > and Oracle
> > > 10 years ago. I have almost completed the database for the project.
> > > My problem is how to integrate the SQL db into my VB program.
> >
> > Your subject line says C++, but the line above says VB, so is your
> > program written in C++ or VB?
> > If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager,
> > then search for System.Data.SQLite Core).
> >
> > -Bill
> >
> >
> > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and
> > any attachments are solely for the use of the addressee and may
> > contain information that is privileged or confidential. Any
> > disclosure, use or distribution of the information contained herein
> is
> > prohibited. In the event this e-mail contains technical data within
> > the definition of the International Traffic in Arms Regulations or
> > Export Administration Regulations, it is subject to the export
> control
> > laws of the U.S.Government. The recipient should check this e-mail
> and
> > any attachments for the presence of viruses as L-3 does not accept
> any
> > liability associated with the transmission of this e-mail. If you
> have
> > received this communication in error, please notify the sender by
> > reply e-mail and immediately delete this message and any attachments.
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

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

[Drago, William @ CSG - NARDA-MITEQ]

> -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] Thoughts 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 total,
> that's
> > how I will blob and store it. This is the simplest way to add it to
> > the database. It's just one more field along with all the other data.
> > If I ever need to operate on that trace data again it's a simple
> > matter of pulling out of the database and un-blobbing it.
>
> In a case like this, I don't think I've ever come to regret suggesting
> the use of a serialization library, like protobuf (or cap'n proto or
> third or avro or ...).  When you make your ad-hoc serialization
> strategy, it works swell for six months, then a new requirement comes
> downstream and you have to figure out a new format plus how to convert
> all the old data.  If that happens two or three times, you start to get
> a combinatoric problem which makes it hard to reason about how a change
> is going to affect existing installs.  Most such requirements are for
> an additional field per array index, which many serialization libraries
> can support pretty transparently.

So, serialize the complex array data then store it in SQLite as a blob? I'm 
working in C# which has built-in support for serialization, do I still need a 
third party library? Other than writing some objects to disk in Java quite a 
few years ago, I have little experience with serialization, sorry for the 
ignorance.

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com



CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] Thoughts on storing arrays of complex numbers

[Drago, William @ CSG - NARDA-MITEQ]

This makes perfect sense. Thank you.

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-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.
>
> Elements Table
> Since arrays are usually referenced by names, I would include an
> "arrayname" field in the Elements table to indicate membership in a
> particular array. Also, I would not trust the recordID for the internal
> ordering of the array, so I would suggest a SeqNo (sequence number or
> unidimensional index) for the elements of the array.
>
> CREATE TABLE ComplexElements
> (
>ComplexElementID INTEGER PRIMARY KEY,
>ComplexArrayName  CHARACTER NOT NULL DEFAULT 'ComplexArray1',
>SeqNo INTEGER NOT NULL DEFAULT 0,-- zero based
>RealPart REAL NOT NULL DEFAULT 0,
>ImagPart REAL NOT NULL DEFAULT 0
> );
>
> The dimensions of the array are an array property and not an element
> property, therefore the number of elements in each dimensions are
> stored in the ComplexArrays table. SQLite knows nothing about the
> dimensions (they are just data) the higher level language calling
> SQLite coerces the dimensions on the unidimensional list of array
> element pairs provided by SQLite.
>
> I have allowed for up to five dimensions (dim1 through dim5).
>
> Do you want zero or one based arrays?
>
> Do you want row-major or column-major interpretation of element vector?
>
> ?
> CREATE TABLE  ComplexArrays
> (
>   ComplexArrayID INTEGER PRIMARY KEY,
>   ComplexArrayName  CHARACTER NOT NULL DEFAULT 'ComplexArray1',
>   dim1 INTEGER NOT NULL DEFAULT 0,  -- min element 0 in 1 dim
>   dim2 DEFAULT NULL ALIAS y,-- dim is maxsize of dim, not coord
>   dim3 DEFAULT NULL ALIAS z,
>   dim4 DEFAULT NULL,
>   dim5 DEFAULT NULL,
> );
>
> Coordinates, you would probably want to generate the indices for the
> arrays "on the fly" in the higher level language, but if you wanted to
> reference the array indices in SQL you might have a third table
> "Coordinates" which would store the ComplexArrayName, SeqNo, Coord1
> ALIAS ,X Coord2 ALIAS Y,
> Coord3 ALIAS Z, Coord4, Coord5.
>
> Then one might create a SQL VIEW  "ComplexData" which would allow one
> to query the contents of an array (a view is a stored query that acts
> as a virtual table -- you can use the view name as if it were a table
> in a
> query):
>
> SELECT ArrayName, X, Y, Z, RealPart, ImagPart FROM ComplexData WHERE
> ArrayName = 'Array1';
>
> or, to select a single element, specify the coordinates:
>
> SELECT ArrayName, X, Y, Z, RealPart, ImagPart FROM ComplexData WHERE
> ArrayName = 'Array1' AND X = 0 AND Y = 0 AND Z = 0; -- 3D, zero based
> array
>
> Thanks to Keith, he was on the right track.
>
> Warning, my capitalization and names may be inconsistent and my SQL
> might be pseudocode, but the intent is create the structures to support
> the final two queries.
>
> Hope this helps.
>
> Jim Callahan
> Orlando, FL
>
> On Fri, Apr 24, 2015 at 5:52 PM, Keith Medcalf 
> wrote:
>
> >
> > Create table ComplexNumbers
> > (
> >id integer primary key,
> >real real not null default 0,
> >imag real not null default 0
> > );
> >
> > Then, where ever you need to use a complex number you store it in the
> > complex number table and store the id of that number instead.  For
> example:
> >
> > ?
> > create table  Boxes
> > (
> >id integer primary key,
> >length integer references ComplexNumbers,
> >width integer references COmplexNumbers );
> >
> > Or if you need a list then something lije:
> >
> > create table ListHeader
> > (
> >List integer primary key,
> >Name text collate nocase not null unique, );
> >
> > create table ListEntries
> > (
> >List integer not null references ListHeader,
> >member integer not null references ComplexNumber );
> >
> > This is called a Relational Data Model because, well, you relate
> > things to each other.
> >
> > > -Original Message-
> > > From: sqlite-users-bounces at mailinglists.sqlite.org
> > > [mailto:sqlite-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 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

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

[Jim Callahan]

Does the data from the network analyzer have a datetime stamp?
On Apr 25, 2015 3:45 PM, "Drago, William @ CSG - NARDA-MITEQ" <
William.Drago at l-3com.com> wrote:

> > -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] Thoughts 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 total,
> > that's
> > > how I will blob and store it. This is the simplest way to add it to
> > > the database. It's just one more field along with all the other data.
> > > If I ever need to operate on that trace data again it's a simple
> > > matter of pulling out of the database and un-blobbing it.
> >
> > In a case like this, I don't think I've ever come to regret suggesting
> > the use of a serialization library, like protobuf (or cap'n proto or
> > third or avro or ...).  When you make your ad-hoc serialization
> > strategy, it works swell for six months, then a new requirement comes
> > downstream and you have to figure out a new format plus how to convert
> > all the old data.  If that happens two or three times, you start to get
> > a combinatoric problem which makes it hard to reason about how a change
> > is going to affect existing installs.  Most such requirements are for
> > an additional field per array index, which many serialization libraries
> > can support pretty transparently.
>
> So, serialize the complex array data then store it in SQLite as a blob?
> I'm working in C# which has built-in support for serialization, do I still
> need a third party library? Other than writing some objects to disk in Java
> quite a few years ago, I have little experience with serialization, sorry
> for the ignorance.
>
> --
> Bill Drago
> Senior Engineer
> L3 Narda-MITEQ
> 435 Moreland Road
> Hauppauge, NY 11788
> 631-272-5947 / William.Drago at L-3COM.com
>
>
>
> CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any
> attachments are solely for the use of the addressee and may contain
> information that is privileged or confidential. Any disclosure, use or
> distribution of the information contained herein is prohibited. In the
> event this e-mail contains technical data within the definition of the
> International Traffic in Arms Regulations or Export Administration
> Regulations, it is subject to the export control laws of the
> U.S.Government. The recipient should check this e-mail and any attachments
> for the presence of viruses as L-3 does not accept any liability associated
> with the transmission of this e-mail. If you have received this
> communication in error, please notify the sender by reply e-mail and
> immediately delete this message and any attachments.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] building SQLite DLL with Visual C++

[Jay Smith]

Hi Bill

I have been trying for 2 days and I am totally lost.

I have NuGet Package Manager. I don't know how to use it.

>From the  PM>   System.Data.SQLiteI get an error.

Can you be a little more specific.

Jay

On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ <
William.Drago at l-3com.com> wrote:

> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith
> > Sent: Thursday, April 23, 2015 3:47 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] building SQLite DLL with Visual C++
> >
> > Thank you Adam for responding to my post. I have the windows binaries
> > downloaded.
> >
> > At this point I am just following the instructions in the book. And I
> > really am not sure what I need the dll for.
> >
> > Here's the scenario. I have created a program in vb2012. The program
> > stores less than 20 fields of data. I am currently saving the data in a
> > html format. I just recently discovered SQLite. I am now in the process
> > of changing over to a database to store data. I studied SQL and Oracle
> > 10 years ago. I have almost completed the database for the project.  My
> > problem is how to integrate the SQL db into my VB program.
>
> Your subject line says C++, but the line above says VB, so is your program
> written in C++ or VB?
> If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager, then
> search for System.Data.SQLite Core).
>
> -Bill
>
>
> CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any
> attachments are solely for the use of the addressee and may contain
> information that is privileged or confidential. Any disclosure, use or
> distribution of the information contained herein is prohibited. In the
> event this e-mail contains technical data within the definition of the
> International Traffic in Arms Regulations or Export Administration
> Regulations, it is subject to the export control laws of the
> U.S.Government. The recipient should check this e-mail and any attachments
> for the presence of viruses as L-3 does not accept any liability associated
> with the transmission of this e-mail. If you have received this
> communication in error, please notify the sender by reply e-mail and
> immediately delete this message and any attachments.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Integrating sqlite with Core Data and iCloud

[Jeff M]

> On Apr 24, 2015, at 2:44 AM, Simon Slavin  wrote:
> 
> On 24 Apr 2015, at 6:59am, Jeff M  wrote:
> 
>> I don't need to map SQLite to iCloud -- I only need to map SQLite to Core 
>> Data.  Core Data then takes care of the iCloud issues.
> 
> I imagine you'd do that by writing a VFS which used Core Data for storage.  
> Core Data could store your data in any of the formats it has drivers for, 
> including plaintext files and SQLite.  And Core Data could store your data in 
> any medium it has drivers for, including local storage and iCloud.
> 
> The result might be slow and inefficient, since you're building a DBMS 
> (SQLite) on top of a DBMS (Core Data) on top of a DBMS (SQLite).
> 
> If you use Core Data the resulting file wouldn't look like a normal SQLite 
> database.  Core Data stores objects.  It doesn't store the rows and columns 
> you refer to with SQL commands.  Maybe your objects would be table rows.
> 
> Simon.

Originally, I wanted to map my tables, rows, and columns to similarly-named 
Core Data entities and attributes so I could continue to use the SQL language.  
I was hoping to hook into the SQL parser to get the benefits of where.c, but I 
realize now that's impractical.

Your suggestion of working at the file system level is interesting, but my 
objects would be disk blocks.  I could use a simple Core Data model: one entity 
(representing the entire database file) and create one object per block (each 
having a binary attribute containing one block of data).  It would be easy to 
map each file system read() and write() to the corresponding objects.  Using 
Core Data as a memory array would earn me the Kludge of The Year Award.  But, I 
see data corruption in my future.

Can you point me to some sample source code (outside of SQLite itself) that 
implements sqlite3_vfs_register()?

Jeff

[sqlite] Thoughts on storing arrays of complex numbers

[Jim Callahan]

Keith is close.

I would suggest two tables: Elements and Arrays.

Elements Table
Since arrays are usually referenced by names, I would include an
"arrayname" field in the Elements table to indicate membership in a
particular array. Also, I would not trust the recordID for the internal
ordering of the array, so I would suggest a SeqNo (sequence number or
unidimensional index) for the elements of the array.

CREATE TABLE ComplexElements
(
   ComplexElementID INTEGER PRIMARY KEY,
   ComplexArrayName  CHARACTER NOT NULL DEFAULT 'ComplexArray1',
   SeqNo INTEGER NOT NULL DEFAULT 0,-- zero based
   RealPart REAL NOT NULL DEFAULT 0,
   ImagPart REAL NOT NULL DEFAULT 0
);

The dimensions of the array are an array property and not an element
property, therefore the number of elements in each dimensions are stored in
the ComplexArrays table. SQLite knows nothing about the dimensions (they
are just data) the higher level language calling SQLite coerces the
dimensions on the unidimensional list of array element pairs provided by
SQLite.

I have allowed for up to five dimensions (dim1 through dim5).

Do you want zero or one based arrays?

Do you want row-major or column-major interpretation of element vector?

?
CREATE TABLE  ComplexArrays
(
  ComplexArrayID INTEGER PRIMARY KEY,
  ComplexArrayName  CHARACTER NOT NULL DEFAULT 'ComplexArray1',
  dim1 INTEGER NOT NULL DEFAULT 0,  -- min element 0 in 1 dim
  dim2 DEFAULT NULL ALIAS y,-- dim is maxsize of dim, not coord
  dim3 DEFAULT NULL ALIAS z,
  dim4 DEFAULT NULL,
  dim5 DEFAULT NULL,
);

Coordinates, you would probably want to generate the indices for the arrays
"on the fly" in the higher level language, but if you wanted to reference
the array indices in SQL you might have a third table "Coordinates" which
would store the ComplexArrayName, SeqNo, Coord1 ALIAS ,X Coord2 ALIAS Y,
Coord3 ALIAS Z, Coord4, Coord5.

Then one might create a SQL VIEW  "ComplexData" which would allow one to
query the contents of an array (a view is a stored query that acts as a
virtual table -- you can use the view name as if it were a table in a
query):

SELECT ArrayName, X, Y, Z, RealPart, ImagPart FROM ComplexData
WHERE ArrayName = 'Array1';

or, to select a single element, specify the coordinates:

SELECT ArrayName, X, Y, Z, RealPart, ImagPart FROM ComplexData
WHERE ArrayName = 'Array1' AND X = 0 AND Y = 0 AND Z = 0; -- 3D, zero based
array

Thanks to Keith, he was on the right track.

Warning, my capitalization and names may be inconsistent and my SQL might
be pseudocode, but the intent is create the structures to support the final
two queries.

Hope this helps.

Jim Callahan
Orlando, FL

On Fri, Apr 24, 2015 at 5:52 PM, Keith Medcalf  wrote:

>
> Create table ComplexNumbers
> (
>id integer primary key,
>real real not null default 0,
>imag real not null default 0
> );
>
> Then, where ever you need to use a complex number you store it in the
> complex number table and store the id of that number instead.  For example:
>
> ??
> create table  Boxes
> (
>id integer primary key,
>length integer references ComplexNumbers,
>width integer references COmplexNumbers
> );
>
> Or if you need a list then something lije:
>
> create table ListHeader
> (
>List integer primary key,
>Name text collate nocase not null unique,
> );
>
> create table ListEntries
> (
>List integer not null references ListHeader,
>member integer not null references ComplexNumber
> );
>
> This is called a Relational Data Model because, well, you relate things to
> each other.
>
> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-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 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 blob field and concat the real and imaginary
> > parts into one long blob. (I like this.)
> > Or, I could store pairs in the blob
> > (realimaginaryrealimaginaryrealimaginaryrealimaginary). (I like this.)
> >
> > Or maybe there's a real nifty way to handle complex numbers that I
> haven't
> > thought of.
> >
> > Thanks,
> > --
> > Bill Drago
> > Senior Engineer
> > L3 Narda-MITEQ
> > 435 Moreland Road
> > Hauppauge, NY 11788
> > 631-272-5947 / William.Drago at L-3COM.com > L-3COM.com>
> >
> >
> > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any
> > attachments are solely for the use of the addressee and may contain
> > information that is 

[sqlite] First-N query time scaling with table size

[Simon Slavin]

On 25 Apr 2015, at 1:12am, John Pitney  wrote:

> The results are the following, on a Windows 7 64-bit platform:

Please do ANALYZE, then check your times again.

Simon.

[sqlite] Thoughts on storing arrays of complex numbers

[Florian Weimer]

* 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.