Thanks a lot for your opinion Hick. But the act of exposing struct Vdbe
should be simple right. It's there sitting on my source code and my
application needs to access it, just like it can access struct sqlite3. Can
you kindly tell me how that can be done ?
P.S. I am almost always going to compil
Just like any other definition provided in a .h file...
If you have the amalgamation sources (just a sqlite3.c and sqlite3.h file) you
need to either split sqlite3.c into its component files or download the
component files directly. Or maybe just extract the vdbeint.h file.
Such practices are n
On Tue, Sep 23, 2014 at 2:33 AM, Donald Shepherd
wrote:
> Are any of these improvements specifically in the area of the online backup
> API, or are they more in the general running of SQLite?
>
The "speedtest1" benchmark does not use the backup API. However, many of
the performance improvements
On 23 Sep 2014, at 8:25am, Prakash Premkumar wrote:
> Thanks a lot for your opinion Hick. But the act of exposing struct Vdbe
> should be simple right. It's there sitting on my source code
Not really. It's there in someone else's source code. You're just compiling
that source code in your pr
Hi,
I have been looking for a product that can encrypt Sqlite database using
JavaScript and came across Sqlite Encryption extension.
Can I use this with my application that uses jquery mobile and sqlitedatabase?
Before purchasing the product, if I could get some information on it or a trial
c
On Mon, Sep 22, 2014 at 3:00 PM, Prava Kafle wrote:
> Hi,
>
> I have been looking for a product that can encrypt Sqlite database using
> JavaScript and came across Sqlite Encryption extension.
> Can I use this with my application that uses jquery mobile and
> sqlitedatabase? Before purchasing t
On Fri, 2014-09-19 at 21:14 -0400, Richard Hipp wrote:
> The latest SQLite 3.8.7 alpha version (available on the download page
> http://www.sqlite.org/download.html) is 50% faster than the 3.7.17 release
> from 16 months ago. That is to say, it does 50% more work using the same
> number of CPU cyc
I sounds like you are trying to 'bind' your column buffers once for the
statement, sort of like we do with, say ODBC. (and sort of like we do in
sqlite for parameters). To wit there is not a means of doing that, but are
you sure these column calls are costly? If you really wanted to experiment
wi
I am working with SQLite code I have developed in .NET 2.0
I have done this development in .NET 2.0 because one of the
installation locations for the database client runs
Windows 2000, controlling a large machine (a beam saw).
The saw was shipped with a computer running Windows 2000,
and has never
On 22/09/14 10:48, Richard Hipp wrote:
> But if you have any new ideas on how we can further reduce the I/O, we'd love
> to hear from you.
The single biggest problem for me is defaults. SQLite supports memory
mapped i/o which has many advantages. The stat4 analyze does a really good
job. WAL r
Steve Rogers wrote:
>
> Reading in order, it says that:
> SQLiteDb.LDb3.PrepareCommand threw an exception with the message
> 'unable to open database file'
>
Is the database file name a UNC path? If so, the number of leading
backslashes must be doubled (i.e. four leading backslashes are now
req
On Tue, 23 Sep 2014 14:12:19 -0500
"dave" wrote:
> sounds like you are trying to 'bind' your column buffers once for
> the statement, sort of like we do with, say ODBC. (and sort of like
> we do in sqlite for parameters). To wit there is not a means of
> doing that, but are you sure these column
On 9/23/2014 10:57 PM, Joe Mistachkin wrote:
Steve Rogers wrote:
Reading in order, it says that:
SQLiteDb.LDb3.PrepareCommand threw an exception with the message
'unable to open database file'
Is the database file name a UNC path? If so, the number of leading
backslashes must be doubled (i.e.
"Steve Rogers" wrote...
On 9/23/2014 10:57 PM, Joe Mistachkin wrote:
Steve Rogers wrote:
Reading in order, it says that:
SQLiteDb.LDb3.PrepareCommand threw an exception with the message
'unable to open database file'
Is the database file name a UNC path? If so, the number of leading
backsl
>I have found out that using UNC paths vs a mapped drive to a server, is
>much slower. Specially if you are going to use a database shared amoungst
>other folks. I would suggest a test on both scenario (UNC path and mapped
>drive) and place some times on the same calls and you'll see the differe
Hi,
Let's say I have tables T1,T2 and T3 with 2 columns each and I am joining
them.
The result rows will have 8 columns each.
Let's say an output of the join is:
r11,r21,r31
r11,r21,r32
r11,r21,r33
where r1i is the i th row in T1, r2i is the i th row in T2 and r3i is the
ith row in T3:
sqlite
To further clarify, the result of a join forms a row that has a new schema
. (the new schema is derived from the schemas of the tables participating
in the joins.) I would like to retain the old schema in the join result as
well, so there is a split between which column belongs / is coming from
wh
17 matches
Mail list logo