Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-27 Thread Matthew L. Creech
On Mon, Apr 27, 2009 at 10:25 PM, liubin liu <7101...@sina.com> wrote: > > thanks > > 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

Re: [sqlite] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

2009-04-27 Thread liubin liu
thanks 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 that? My application needs some

[sqlite] Special Character Problem

2009-04-27 Thread Kalyani Phadke
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 Ïðåçèäåíò Ãðóçèè Ìèõàèë Ñààêàøâèëè ïðèçíàë, ÷òî èìåííî îí îòäàë ïðèêàç î íà÷àëå âîåííîé îïåðàöèè â

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread Vinnie
> > 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. >

[sqlite] Can SQLite3 handle OSM 150G data file?

2009-04-27 Thread Kelly Jones
I've seen many posts saying that SQLite2 can't handle OpenStreetMap's large planet.osm data file: http://planet.openstreetmap.org/planet-090421.osm.bz2 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

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread Logan.Ratner
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. See

Re: [sqlite] Using SQLite3 on On-Time RTOS ...

2009-04-27 Thread Virgilio Alexandre Fornazin
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. -Original Message- From:

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread Jay A. Kreibich
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

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread Eugene Wee
Hi, 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

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread John Machin
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 >> http://www.codeproject.com/KB/database/CppSQLite.aspx > > Apparently I did come up with an original

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread Vinnie
> From: Neville Franks > Subject: Re: [sqlite] How do you guys use sqlite from C++? > I use a modified version of the C++ wrapper > http://www.codeproject.com/KB/database/CppSQLite.aspx Apparently I did come up with an original idea. Because none of the wrappers from the

Re: [sqlite] How do you guys use sqlite from C++?

2009-04-27 Thread Neville Franks
I use a modified version of the C++ wrapper http://www.codeproject.com/KB/database/CppSQLite.aspx 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