date:20141120

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

2014-11-20 Thread Thane Michael

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 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-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Thane Michael

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.

A second question I have is whether it is possible to serialize an object
which doesn't have attributes. An answer has been provided, which is that
it's not possible but I would like to be sure.

Here's an example; TRAY.h


 #ifndef TRAY_H
 #define TRAY_H
 #include 
 #include "EGG.h";
 #include "FLOUR.h";
 class TRAY
 {
double price;
std::vector dozen;
 public:
TRAY(int number); ~TRAY();
double getTotalPrice();
std::vector getEggs();
 };
 #endif

In the above example, how, if it is possible, do I serialize a TRAY object?

Regards,

Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Igor Tandetnik


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-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Thane Michael

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 answer has been provided, which is that
it's not possible but I would like to be sure.

Here's an example;


   1. #ifndef BREAD_H
   2. #define BREAD_H
   3. #include "EGGS.h";
   4. #include "FLOUR.h";
   5. class BREAD
   6. {
   7. public:
   8. BREAD();~BREAD();
   9. //lame example
   10. std::vector selectIngredient(std::vectorgrocery);
   11.
   12. };
   13. #endif

In the above example, how, if it is possible, do I serialize a BREAD object?

Regards,

Mike
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Column name as a variable

2014-11-20 Thread James K. Lowden

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.  

SQL has value semantics.  That there are no pointers is a deliberate
choice, made because value semantics are easier to reason about.  

A table is an SQL variable; the name of a table is  a name of a
variable. Not many languages interpolate variable names the way e.g.
Perl does.  When you think of it that way, it's unsurprising that

select T = 'foo';
select count(*) from tableof(T);

doesn't work, nor does anything similar.  Even though it doesn't look
like a C pointer, T above is a pointer in semantic terms: it is not a
table, but putatively a "tablename variable", something that holds the
name of a table (which is SQL is the only way to reference any
variable).  

Given the obscure SQL I've seen, I'm glad not to deal with that kind of
indirection.  

IMO the most confusing aspect is parameterized queries, which IIRC
aren't defined by the SQL standard (not that that matters much).  Once
you can replace data with @param or similar, it seems a small step to
parameterize metadata, too.  But the designers were thinking along
functional lines, 

table = function(parameter)

and again, within that framework, it's pretty rare to find a language
in which the parameter could itself be the name of a variable.  

Note that parameterized metadata would add no value to SQL per se.
Parameterized data yields efficiency and even accuracy gains because
numeric (and other nontext) data can be sent to the server in binary
form without being converted to strings. (In that way parameterized
queries mirror plain old SELECT, which returns binary data.)  Metadata
on the other hand are always text and can be readily parameterized
with any macro processor without reference to datatypes in the
database.  

--jkl
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] default ignore-glob for sqlite

2014-11-20 Thread 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

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 
> wrote:
>
>> 2014-11-06 1:14 GMT+01:00 E. Timothy Uy :
>> > Hi, I noticed that the ignore-glob for sqlite is empty. Is it just
>> because
>> > fossil does not transfer this information? What should I be using?
>>
>> I'm using the "ignore-glob" versioned setting below.
>>
>> Regards,
>>   Jan Nijtmans
>>
>> $ cat .fossil-settings/ignore-glob
>> tsrc/*
>> *.db
>> Makefile
>> config.h
>> config.log
>> config.status
>> keywordhash.h
>> lemon
>> lemon.exe
>> lempar.c
>> libsqlite3.la
>> libtclsqlite3.la
>> libtool
>> mkkeywordhash
>> mkkeywordhash.exe
>> opcodes.c
>> opcodes.h
>> parse.c
>> parse.h
>> parse.h.temp
>> parse.out
>> parse.y
>> shell.c
>> sqlite3
>> sqlite3.c
>> sqlite3.exe
>> sqlite3.h
>> sqlite3.lo
>> sqlite3.o
>> sqlite3.pc
>> sqlite3ext.h
>> tclsqlite.lo
>> tclsqlite.o
>> testfixture
>> testfixture.exe
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Simon Slavin

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, specify it using ORDER BY.  It's the only way to be 
sure.

Don't try to second-guess the optimizer.  It occasionally does things that seem 
weird just because the numbers suggest they're optimal.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Clemens Ladisch

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,
>>>   t2 INNER JOIN t2c ON (t2c.t2_id = t2.id)
>>> ORDER BY t1c.t1_id, t1c.id, t2.name, t2c.name
>>>
>>> And yet the plan invokes a B-Tree to sort:
>>>
>>> "0""0""0""SCAN TABLE t1c USING COVERING INDEX 
>>> idx_t1c_by_t1_id"
>>> "0""1""2""SCAN TABLE t2c"
>>> "0""2""1""SEARCH TABLE t2 USING AUTOMATIC COVERING INDEX 
>>> (id=?)"
>>> "0""0""0""USE TEMP B-TREE FOR RIGHT PART OF ORDER BY"
>>>
>>> Is the temp b-tree redundant here?
>>
>> I don't think so.  What query plan are you thinking might be able to omit
>> the sorting pass in this query?
>
> 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.

If you had used "ORDER BY t2c.id, t2c.name, ...", it would be possible
to use this index.  How would a different order help?


Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Oliver Smith


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

2014-11-20 Thread E. Timothy Uy

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
that you are no longer dependent on vcvarsphoneall.bat.

On Thu, Nov 20, 2014 at 12:03 PM, E. Timothy Uy  wrote:

> 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 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
>> >>>
>> >
>>
>> Please try the following commands from a Visual Studio 2013 Command
>> Prompt:
>>
>> SET PLATFORMS=x86 x86_arm
>> SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1
>>
>> CALL tool\build-all-msvc.bat C:\path\to\output\dir
>>
>> --
>> Joe Mistachkin
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling for WP81

2014-11-20 Thread E. Timothy Uy

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 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
> >>>
> >
>
> Please try the following commands from a Visual Studio 2013 Command Prompt:
>
> SET PLATFORMS=x86 x86_arm
> SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1
>
> CALL tool\build-all-msvc.bat C:\path\to\output\dir
>
> --
> Joe Mistachkin
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling for WP81

2014-11-20 Thread Joe Mistachkin


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 vcvarsphoneall, I end up with
>>>
>

Please try the following commands from a Visual Studio 2013 Command Prompt:

SET PLATFORMS=x86 x86_arm
SET NMAKE_ARGS=FOR_WINRT=1 USE_WP81_OPTS=1

CALL tool\build-all-msvc.bat C:\path\to\output\dir

--
Joe Mistachkin

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Virtual table implementation details

2014-11-20 Thread Alessandro Marzocchi

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 mind is an architecture similar to model view controller... in
which the sqlite database acts as model.  So it's important for me which
will be the state of db when I'll query it during rollback... hope I could
clarify my question enough. In the evening I'll try to write some more
accurate description of the full architecture I have in mind to see if
anybody may have suggestions. Thank you again

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
nothing for your function to do… the SQLite engine will rollback all the
tables and put them into their prior state all on its own.

 -j


On Nov 20, 2014, at 3:26 AM, Alessandro Marzocchi <
alessandro.marzoc...@gmail.com> wrote:

> 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). Also a
> callback to the real object is provided to notify when values are changed
> (eg for a rollback or undo). My problem comes on implementing rollback
> function. When rollback is called my thought is to restore old data
directly
> from the data table or the undo table. For example (still simplified)
>
> 1) Virtual table: dataObjectA(id INTEGER PRIMARY KEY, Foo INTEGER)
>Data table: _dataObjectA(id INTEGER PRIMARY KEY, Foo INTEGER)
>Undo table: _undo(step INTEGER PRIMARY KEY, STRING class, id INTEGER,
> variable STRING, oldValue VARIANT, newValue VARIANT),
>objectA[27]->Foo=3; so _dataObjectA contains a single entry (27,3)
> 2) BEGIN
> 3) User calls objectA[27]->setFoo(4): c++ from this calls make an UPDATE
> dataObjectA SET Foo=4 WHERE id=27;
> 4) My xUpdate gets called. Following queries are made: UPDATE _dataObjectA
> SET Foo=4 WHERE id=27; INSERT INTO _undo VALUES (0 /*incremental step
number
> */, 'objectA', 27, 'Foo', 3, 4)
> 5) ROLLBACK
> 6) My xRollback gets called and has to restore previous state (and notify
it
> through the callback)
>
> Now what database state will xRollback see? The one before (4) or the one
> after? Looking at code I see xRollback in sqlite3.c (3.8.7.1 amalgamation)
> is called with following call stack:
> 112789: static void callFinaliser(sqlite3 *db, int offset)
> 112838: sqlite3VtabRollback
>
> Which itself may be called from:
> 125934 sqlite3RollbackAll /* After sqlite3BtreeRollback is called */
> 125744 sqlite3Close /* Not meaningfull on my case */
>
> So it seems that when my xRollback will be called it will see old data.
Can
> anybody confirm me there are no corner case in which something different
> could happened and may I assume that this behavior will be kept in future
> releases too?
>
> Also, even if I'm afraid the answer is not is there a way to force
> "reloading" of virtual table(s)? In my implementation columns can be added
> (in virtual as in real data table) through another special virtual table
> (following the example before user may do a INSERT INTO classDef VALUES
> ('ObjectA', 'Bar', 'STRING') and this would add a column to _dataObjectA.
> Have I any ways to force (other than forced DROP TABLE/CREATE VIRTUAL
TABLE)
> reloading so I can notify sqlite of new schema with sqlite3_declare_vtab?
>
> Thank you for your help
> Alessandro
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

--
Jay A. Kreibich < J A Y @ K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it, but
showing it to the wrong people has the tendency to make them feel
uncomfortable." -- Angela Johnson





___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Virtual table implementation details

2014-11-20 Thread Jay Kreibich


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 nothing for your 
function to do… the SQLite engine will rollback all the tables and put them 
into their prior state all on its own.

 -j


On Nov 20, 2014, at 3:26 AM, Alessandro Marzocchi 
 wrote:

> 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). Also a
> callback to the real object is provided to notify when values are changed
> (eg for a rollback or undo). My problem comes on implementing rollback
> function. When rollback is called my thought is to restore old data directly
> from the data table or the undo table. For example (still simplified)
> 
> 1) Virtual table: dataObjectA(id INTEGER PRIMARY KEY, Foo INTEGER)
>Data table: _dataObjectA(id INTEGER PRIMARY KEY, Foo INTEGER)
>Undo table: _undo(step INTEGER PRIMARY KEY, STRING class, id INTEGER,
> variable STRING, oldValue VARIANT, newValue VARIANT),
>objectA[27]->Foo=3; so _dataObjectA contains a single entry (27,3)
> 2) BEGIN
> 3) User calls objectA[27]->setFoo(4): c++ from this calls make an UPDATE
> dataObjectA SET Foo=4 WHERE id=27;
> 4) My xUpdate gets called. Following queries are made: UPDATE _dataObjectA
> SET Foo=4 WHERE id=27; INSERT INTO _undo VALUES (0 /*incremental step number
> */, 'objectA', 27, 'Foo', 3, 4)
> 5) ROLLBACK
> 6) My xRollback gets called and has to restore previous state (and notify it
> through the callback)
> 
> Now what database state will xRollback see? The one before (4) or the one
> after? Looking at code I see xRollback in sqlite3.c (3.8.7.1 amalgamation)
> is called with following call stack:
> 112789: static void callFinaliser(sqlite3 *db, int offset)
> 112838: sqlite3VtabRollback
> 
> Which itself may be called from:
> 125934 sqlite3RollbackAll /* After sqlite3BtreeRollback is called */
> 125744 sqlite3Close /* Not meaningfull on my case */
> 
> So it seems that when my xRollback will be called it will see old data. Can
> anybody confirm me there are no corner case in which something different
> could happened and may I assume that this behavior will be kept in future
> releases too?
> 
> Also, even if I'm afraid the answer is not is there a way to force
> "reloading" of virtual table(s)? In my implementation columns can be added
> (in virtual as in real data table) through another special virtual table
> (following the example before user may do a INSERT INTO classDef VALUES
> ('ObjectA', 'Bar', 'STRING') and this would add a column to _dataObjectA.
> Have I any ways to force (other than forced DROP TABLE/CREATE VIRTUAL TABLE)
> reloading so I can notify sqlite of new schema with sqlite3_declare_vtab?
> 
> Thank you for your help
> Alessandro
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

--  
Jay A. Kreibich < J A Y @ K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it, but showing 
it to the wrong people has the tendency to make them feel uncomfortable." -- 
Angela Johnson





___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Virtual table implementation details

2014-11-20 Thread Alessandro Marzocchi

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). Also a
callback to the real object is provided to notify when values are changed
(eg for a rollback or undo). My problem comes on implementing rollback
function. When rollback is called my thought is to restore old data directly
from the data table or the undo table. For example (still simplified)

1) Virtual table: dataObjectA(id INTEGER PRIMARY KEY, Foo INTEGER)
Data table: _dataObjectA(id INTEGER PRIMARY KEY, Foo INTEGER)
Undo table: _undo(step INTEGER PRIMARY KEY, STRING class, id INTEGER,
variable STRING, oldValue VARIANT, newValue VARIANT),
objectA[27]->Foo=3; so _dataObjectA contains a single entry (27,3)
2) BEGIN
3) User calls objectA[27]->setFoo(4): c++ from this calls make an UPDATE
dataObjectA SET Foo=4 WHERE id=27;
4) My xUpdate gets called. Following queries are made: UPDATE _dataObjectA
SET Foo=4 WHERE id=27; INSERT INTO _undo VALUES (0 /*incremental step number
*/, 'objectA', 27, 'Foo', 3, 4)
5) ROLLBACK
6) My xRollback gets called and has to restore previous state (and notify it
through the callback)

Now what database state will xRollback see? The one before (4) or the one
after? Looking at code I see xRollback in sqlite3.c (3.8.7.1 amalgamation)
is called with following call stack:
112789: static void callFinaliser(sqlite3 *db, int offset)
112838: sqlite3VtabRollback

Which itself may be called from:
125934 sqlite3RollbackAll /* After sqlite3BtreeRollback is called */
125744 sqlite3Close /* Not meaningfull on my case */

So it seems that when my xRollback will be called it will see old data. Can
anybody confirm me there are no corner case in which something different
could happened and may I assume that this behavior will be kept in future
releases too?

Also, even if I'm afraid the answer is not is there a way to force
"reloading" of virtual table(s)? In my implementation columns can be added
(in virtual as in real data table) through another special virtual table
(following the example before user may do a INSERT INTO classDef VALUES
('ObjectA', 'Bar', 'STRING') and this would add a column to _dataObjectA.
Have I any ways to force (other than forced DROP TABLE/CREATE VIRTUAL TABLE)
reloading so I can notify sqlite of new schema with sqlite3_declare_vtab?

Thank you for your help
 Alessandro
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Clemens Ladisch

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

Regards,
Clemens
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling for WP81

2014-11-20 Thread E. Timothy Uy

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
> /out:mkkeywordhash.exe
> "/LIBPATH:F:\Program Files (x86)\Microsoft Visual Studio 12.0\VC\lib"
> "/LIBPATH:C:\Program Files (x86)\Windows Phone Silverlight
> Kits\8.1\lib\x86"
> mkkeywordhash.obj
> LINK : fatal error LNK1104: cannot open file 'kernel32.lib'
> NMAKE : fatal error U1077: '"F:\Program Files (x86)\Microsoft Visual
> Studio 12.0\VC\bin\cl.EXE"' : return code '0x2'
> Stop.
> Failed to build Debug "sqlite3.dll" for platform x86_arm.
>
> Any tips on how I should do this? Should I even be using
> build-all-msvc.bat?
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Yongil Jang

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  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 working and not a bug.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] compiling for WP81

2014-11-20 Thread E. Timothy Uy

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 Kits\8.1\lib\x86"
mkkeywordhash.obj
LINK : fatal error LNK1104: cannot open file 'kernel32.lib'
NMAKE : fatal error U1077: '"F:\Program Files (x86)\Microsoft Visual Studio
12.0\VC\bin\cl.EXE"' : return code '0x2'
Stop.
Failed to build Debug "sqlite3.dll" for platform x86_arm.

Any tips on how I should do this? Should I even be using build-all-msvc.bat?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

2014-11-20 Thread Simon Slavin

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 working and not a bug.

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

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

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

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

Re: [sqlite] Column name as a variable

Re: [sqlite] default ignore-glob for sqlite

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

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

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

Re: [sqlite] compiling for WP81

Re: [sqlite] compiling for WP81

Re: [sqlite] compiling for WP81

Re: [sqlite] Virtual table implementation details

Re: [sqlite] Virtual table implementation details

[sqlite] Virtual table implementation details

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

Re: [sqlite] compiling for WP81

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

[sqlite] compiling for WP81

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

20 matches

Site Navigation

Mail list logo

Footer information