Re: [sqlite] Serializing an object's vector or array using sqlite3 in c++

2014-11-21 Thread Sohail Somani
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 2014-11-21, 12:52 AM, Thane Michael wrote: > I've been searching for a way to serialize an object's vector using > sqlite3 but are yet find a working solution. How do I go about > making it happen, an example would be of great help. If your goal is

Re: [sqlite] System.Data.SQLite NuGet

2014-11-21 Thread Joe Mistachkin
Michael Quinlan wrote: > > The current NuGet package seems to include SQLite version 3.8.6. Are there > plans to update to version 3.8.7? > The core NuGet packages contain the SQLite core library code, customized for use with System.Data.SQLite (i.e. commonly referred to as the "SQLite interop

[sqlite] System.Data.SQLite NuGet

2014-11-21 Thread Michael Quinlan
The current NuGet package seems to include SQLite version 3.8.6. Are there plans to update to version 3.8.7? -- Michael Quinlan mquin...@gmail.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqli

Re: [sqlite] Serializing an object's vector or array using sqlite3 in c++

2014-11-21 Thread Nelson, Erik - 2
RSmith wrote on Friday, November 21, 2014 4:46 AM > > On 2014/11/21 08:09, Thane Michael wrote: > > Many of the answers I came across online implied that it wouldn't be > > as straightforward as serializing ints and strings. > > Of course a byte-stream serializer is most speed-and-size happy and

Re: [sqlite] PRAGMA reverse_unordered_selects and CTEs

2014-11-21 Thread Richard Hipp
On Fri, Nov 21, 2014 at 5:58 AM, snowbiwan wrote: > > If this is not a bug, then this behaviour should be mentioned on either the > Pragma, or WITH Clause documentation pages. > Not a bug. https://www.sqlite.org/docsrc/info/3d72482e471 -- D. Richard Hipp d...@sqlite.org __

[sqlite] PRAGMA reverse_unordered_selects and CTEs

2014-11-21 Thread snowbiwan
I was experimenting with ways to return only the last row of a recursive CTE, when I came across some curious behaviour. The following two examples were run from the shell of 3.8.7.2: 1) PRAGMA reverse_unordered_selects = OFF; WITH RECURSIVE i(i) AS (SELECT 1 UNION ALL SELECT i+1 FROM i L

Re: [sqlite] Serializing an object's vector or array using sqlite3 in c++

2014-11-21 Thread Stephan Beal
On Fri, Nov 21, 2014 at 10:45 AM, RSmith wrote: > Alternatively you can serialize anything object-like to XML or JSON and > simply store the resulting string in the database. This allows you to not > spend a lot on DB design and to use the same DB layout for any future > changes to the base objec

Re: [sqlite] Serializing an object's vector or array using sqlite3 in c++

2014-11-21 Thread RSmith
On 2014/11/21 08:09, Thane Michael wrote: Many of the answers I came across online implied that it wouldn't be as straightforward as serializing ints and strings. It would be equally difficult in any RDBMS, the difficulty does not lie with the Database, it lies with your objects. There are two

Re: [sqlite] Serializiing an object's vector or array in c++ using sqlite3

2014-11-21 Thread Clemens Ladisch
Thane Michael wrote: > I've been searching for a way to serialize an object's vector using sqlite3 > but are yet find a working solution. The question is how to model the vector in the database. In most cases, you should normalize your tables: class A { int id; double som

Re: [sqlite] default ignore-glob for sqlite

2014-11-21 Thread Jan Nijtmans
2014-11-21 1:23 GMT+01:00 E. Timothy Uy: > Jan, I added to your list > > .target_source > lemon.obj > libsqlite3.lib > mkkeywordhash.obj > sqlite3.def > sqlite3.dll > sqlite3.exp > sqlite3.lib Thanks! I added them too. My preferred win32/64 compilation environment is MinGW(-w64), therefore I gener