[sqlite] building SQLite DLL with Visual C++

2015-04-25 Thread 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

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

2015-04-25 Thread 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

[sqlite] Thoughts on storing arrays of complex numbers

2015-04-25 Thread 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

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

2015-04-25 Thread 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

[sqlite] building SQLite DLL with Visual C++

2015-04-25 Thread 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 <

[sqlite] Integrating sqlite with Core Data and iCloud

2015-04-25 Thread 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

[sqlite] Thoughts on storing arrays of complex numbers

2015-04-25 Thread 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

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

2015-04-25 Thread 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

2015-04-25 Thread 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.