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

I've made my own wrapper class around sqlite for executing database commands. Its completely generic and supports the use of binds and parameter substitution through the use of variable arguments () as well as a printf-style format string that clues the routine into the types of the arguments.

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

On 27/04/2009 8:35 PM, Vinnie wrote: > I've made my own wrapper class around sqlite for executing database commands. > Its completely generic and supports the use of binds and parameter > substitution through the use of variable arguments () as well as a > printf-style format string that clues t

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 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 paramet

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

> 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 archives are using vari

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

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 idea. > Because none of

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

Hi. I wondered whether anyone is using SQLite3 on the On-Time RTOS platform, and if so, if there are any patches or tips to help others along? We've been giving the SQLite 3.6.10 amalgamation source code for Windows a try against RTOS 5.14 and it compiled out of the box. However, we ran into some

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

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 SQlite. > > My goal for a

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

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 s

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

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: sqlite-users-boun.

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

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 http:

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

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 slo

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

> > 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. > The trend is more for fu

[sqlite] Special Character Problem

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] the speed of embedded database engines, sqlite3 vs berkeley db, I'm confused

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

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

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