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

Many of the answers I came across online implied that it wouldn't be as straightforward as serializing ints and strings. On Fri, Nov 21, 2014 at 1:04 AM, Igor Tandetnik wrote: > On 11/21/2014 12:52 AM, Thane Michael wrote: > >> I've been searching for a way to serialize an

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

Hi, I previously sent out out an email that was not clear, this email is meant to fix that. ---previous message 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.

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

On 11/21/2014 12:52 AM, Thane Michael wrote: I've been searching for a way to serialize an object's vector using sqlite3 There's nothing in sqlite3 that would help (or hinder) this task. What made you believe otherwise? -- Igor Tandetnik ___

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

Hi, 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. A second question I have is whether it is possible to serialize an object which doesn't have attributes. An

Re: [sqlite] Column name as a variable

On Tue, 18 Nov 2014 12:06:02 + Simon Slavin wrote: > > my requirement, which is using a > > table name as a variable > > This is deliberately made very difficult in SQL. I think it's for > security reasons. That may be part of it, but It's really all about values.

Re: [sqlite] default ignore-glob for sqlite

Jan, I added to your list .target_source lemon.obj libsqlite3.lib mkkeywordhash.obj sqlite3.def sqlite3.dll sqlite3.exp sqlite3.lib On Thu, Nov 6, 2014 at 9:25 AM, E. Timothy Uy wrote: > Thank you Jan. > > On Thu, Nov 6, 2014 at 7:46 AM, Jan Nijtmans >

Re: [sqlite] Why is a b-tree sort required for this query?

On 20 Nov 2014, at 9:48pm, Oliver Smith wrote: > The t2c table has an index on id, name; I expected it would use that index so > that the data would be naturally in order. As you've found, you cannot rely on this. If you need an answer to a query to be in a specific order,

Re: [sqlite] Why is a b-tree sort required for this query?

Oliver Smith wrote: >> On Sun, Nov 16, 2014 at 2:18 PM, Oliver Smith wrote: >>> ... >>> CREATE TABLE t2c (id INTEGER, name text, t2_id INTEGER, UNIQUE (t2_id, >>> name)); >>> >>> EXPLAIN QUERY PLAN >>> SELECT t1c.t1_id, t1c.id, t2c.t2_id, t2c.id >>> FROM t1c,

Re: [sqlite] Why is a b-tree sort required for this query?

Date: Mon, 17 Nov 2014 21:29:21 -0500 From: Richard Hipp To: General Discussion of SQLite Database Subject: Re: [sqlite] Why is a b-tree sort required for this query? Message-ID:

Re: [sqlite] compiling for WP81

I found the issue. I call vcvarsphoneall.bat and then vcvarsall.bat again in order to reset everything. But WindowsPhoneKitDir does not get unset, this triggers build-all-msvc.bat to cal vcvarsphoneall once again. Probably that segment needs to be removed from build-all-msvc.bat since it seems

Re: [sqlite] compiling for WP81

It seem the problem was that I was calling vcvarsphoneall first. Though I am surprised the winrt build worked fine. On Thu, Nov 20, 2014 at 11:15 AM, Joe Mistachkin wrote: > > E. Timothy Uy wrote: > > > >> Seems that when making mkkeywordhash.exe, it should be using the

Re: [sqlite] compiling for WP81

E. Timothy Uy wrote: > >> Seems that when making mkkeywordhash.exe, it should be using the x86 lib >> paths. >> >> On Thu, Nov 20, 2014 at 12:45 AM, E. Timothy Uy wrote: >> >>> Hi, I am attempting to compile for WP81 using build-all-msvc.bat. >>> However, when I initialize with

Re: [sqlite] Virtual table implementation details

Sorry but I did not make my question clear... my problem is not only restoring data to old data (easy, sqlite already does it at some time during it) but to do other operations during rollback (e.g. notifying the object that its data has changed, so the object will read it back). What I have in

Re: [sqlite] Virtual table implementation details

You seem to be forgetting one important detail… if a Rollback is called, the underlying data and undo tables will be rolled back automatically. They are, after all “real” tables in the database, and will be managed as such. Unless you’re storing data outside the SQLite database, there is

[sqlite] Virtual table implementation details

Good day, I'm implementing a serialization/redo engine based on sqlite. My implementation (particulars omitted) will work by adding a layer of virtual tables over real sqlite data tables plus a physical table to store the list of modifications made to them (to implement undo functionality).

Re: [sqlite] automatic index on sqlite_sq_#######

Yongil Jang wrote: > It is a normal work but I just want to notify that some of automatic index > log message is not easy to recognize which query made this log output. SQLite just delivers the log message to the application; it is the application's job to relate it to whatever it is actually

Re: [sqlite] compiling for WP81

Seems that when making mkkeywordhash.exe, it should be using the x86 lib paths. On Thu, Nov 20, 2014 at 12:45 AM, E. Timothy Uy wrote: > Hi, I am attempting to compile for WP81 using build-all-msvc.bat. However, > when I initialize with vcvarsphoneall, I end up with > > /debug >

Re: [sqlite] automatic index on sqlite_sq_#######

Yes, it's not a bug. It is a normal work but I just want to notify that some of automatic index log message is not easy to recognize which query made this log output. Thank you. On Nov 20, 2014 5:39 PM, "Simon Slavin" wrote: > > On 20 Nov 2014, at 7:45am, Yongil Jang

[sqlite] compiling for WP81

Hi, I am attempting to compile for WP81 using build-all-msvc.bat. However, when I initialize with vcvarsphoneall, I end up with /debug /out:mkkeywordhash.exe "/LIBPATH:F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib" "/LIBPATH:C:\Program Files (x86)\Windows Phone Silverlight

Re: [sqlite] automatic index on sqlite_sq_#######

On 20 Nov 2014, at 7:45am, Yongil Jang wrote: > I've found that following log string when using sub-query. > > "automatic index on sqlite_sq_9F222470(STAT_DATA_ID)" This is not output by SQLite. It is output by a program which uses SQLite. It may indicate normal