On Mon, Apr 27, 2009 at 10:25 PM, liubin liu <7101...@sina.com> wrote:
> I'm not sure of the real reason.
> It's true that the speed of inserting with transaction is very fast. But my
> project is using SQLite mainly in selecting something. I don't know how to
> use transaction in the
I'm not sure of the real reason.
It's true that the speed of inserting with transaction is very fast. But my
project is using SQLite mainly in selecting something. I don't know how to
use transaction in the situation. May some friends give me some codes on
My application needs some
I am trying to insert the following data into my SQLite3 database using SQLIte3
ODBC driver (version .77)
Russian AV4 èçîáðàæåíè$
Russian AV4 èçîáðàæåíèÿ (13.0) has returned to normal
Ïðåçèäåíò Ãðóçèè Ìèõàèë Ñààêàøâèëè ïðèçíàë, ÷òî èìåííî îí îòäàë ïðèêàç î íà÷àëå
âîåííîé îïåðàöèè â
> > From: Neville Franks
> implementations are meant to save
> prepared statements in a cache and IIUC most do.
Thats exactly what I am doing. I still pass the original statement every time.
The same call either creates a new statement or re-uses the cached version.
I've seen many posts saying that SQLite2 can't handle OpenStreetMap's
large planet.osm data file:
which is 5.4G bzip2 compressed, about 150G uncompressed.
Can SQLite3 handle this? Has anyone tried?
I tried to do this myself, but I'm on a
Personally, I don't use var-args in C++ code. You lose type-safety,
can't use user-defined types, and can't detect when the wrong number of
arguments is passed, not even at run-time.
Instead, I'd create a class you can 'feed' variables too in much the
same way that boost::format works.
Maybe RTOS kernel does not implement Wide-Char functions...
Windows VFS must guard them with a SQLITE_WINDOWS_NO_UNICODE
macro or something like that at compile time, but you should
do it yourself... then you can contribute it back to SQLite.
On Mon, Apr 27, 2009 at 05:06:31AM -0700, Vinnie scratched on the wall:
> Hasn't anyone else used variable argument lists for binding parameters
> and what not?
There is a built-in API for that: http://sqlite.org/c3ref/mprintf.html
Part of the reason you may find that var-arg binding and
On Mon, Apr 27, 2009 at 8:06 PM, Vinnie wrote:
> Apparently I did come up with an original idea. Because none of the wrappers
> from the archives are using variable argument lists. All these wrappers are
> basically doing the same thing, a very thin layer on top of
On 27/04/2009 10:06 PM, Vinnie wrote:
>> From: Neville Franks
>> Subject: Re: [sqlite] How do you guys use sqlite from C++?
>> I use a modified version of the C++ wrapper
> Apparently I did come up with an original
> From: Neville Franks
> Subject: Re: [sqlite] How do you guys use sqlite from C++?
> I use a modified version of the C++ wrapper
Apparently I did come up with an original idea. Because none of the wrappers
I use a modified version of the C++ wrapper
Monday, April 27, 2009, 8:35:43 PM, you wrote:
V> I've made my own wrapper class around sqlite for executing
V> database commands. Its completely generic and supports the use of
V> binds and
Mail list logo