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

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

Re: [sqlite] Newbie question about using SQLite with Windows Forms application (VS 2005 C++)

> From: wiktor > Subject: [sqlite] Newbie question about using SQLite with > Windows Forms application (VS 2005 C++) > I'm trying to build a win form application that uses > sqlite. I have problems with making it work. I would like > to have the sqlite source included in my

Re: [sqlite] converting sqlite db into xml

> From: candd > I want to have a sample C source for a program that convert > an sqlite > data base file to xml file. > could you help me please! Thats a pretty broad and open ended question. What exactly are you trying to accomplish here? Do you want to produce enough XML

Re: [sqlite] Limit to database and/or blob size on Mac/Windows?

> From: John Machin > Irrespective of what people tell you and how authoritative > they seem, I > would recommend that you do some simple tests: Excellent advice! Thanks! ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite database to xml converter??

> From: candd > > Dear All! > > I am new user of sqlite3 > I want to have a sample C source for a program that convert > an sqlite > data base file to xml file. > could you help me please! Hi and welcome to the group. Your problem is very easy to solve, just rename your

[sqlite] Limit to database and/or blob size on Mac/Windows?

the amalgamation and it says that >2GB file support is enabled on POSIX if the underlying OS supports it. And "Similar is true for Mac OS X". But there is no mention of Windows. Anyone? Thanks! Sincerely, Vinnie ___ sqlite-users mailing list

[sqlite] Whoops! Huge misunderstanding of multi-threaded database

So I'm getting SQLITE_BUSY now. I have one thread inserting rows while another thread tries to read a row from the same table. I had a bad implementation where I was keeping the transaction open far longer than necessary so I think I went over some 5 second rule? Does SQLite wait up some

[sqlite] PRAGMA doesn't support parameter binds?

Sorry for only posting when I have a problem...but... I'm doing PRAGMA user_version=?; And getting result code SQLITE_ERROR (1) from sqlite3_prepare_v2(). Of course I can't step into the sqlite3.c code because the Visual Studio 2008 debugger gets hopelessly confused when confronted with a

[sqlite] Multiple connections from different threads

Sorry for asking such a basic question, and it seems I know the answer but I would like a confirmation. If I am executing the same SQL statement from multiple database handles to the same database file, I still need to prepare a distinct sqlite3_stmt for each connection, even though the SQL

[sqlite] UTF-16 API a second class citizen?

Wow man that is the page I've been looking for my whole life but didn't know it...finally an explanation for this mess. > From: "Igor Tandetnik" > > "The Absolute Minimum Every Software Developer > Absolutely, Positively > Must Know About Unicode and Character Sets (No >

Re: [sqlite] UTF-16 API a second class citizen?

> Note that both UTF-8 and UTF-16 are capable of representing > the full range of Unicode characters. Conversion between the two is > lossless. You seem to be under impression that UTF-8 is somehow > deficient, only suitable for "legacy" encoding. This is not the > case. Yeah thats what they

Re: [sqlite] UTF-16 API a second class citizen?

PRAGMA statements, I see what you mean now. This is exactly what I needed, thanks a lot. To clarify what I am doing, my SQL statements are in UTF-8 and they are all prepared, with parameter bindings. So table names, column names, etc.. are all UTF-8. However, I have table fields which will

Re: [sqlite] UTF-16 API a second class citizen?

> From: "Igor Tandetnik" > You could convert your file name from UTF-16 to UTF-8, then > call sqlite3_open_v2. Converting the file name is no problem. But I thought that depending on how you opened the database (open16 versus open_v2), SQL treats your strings

[sqlite] UTF-16 API a second class citizen?

Dear Group: When my application launches I want to open the associated database, and if that fails because the file does not exist then I would create a new database. sqlite3_open_v2() is ideal for this purpose because you can leave out SQLITE_OPEN_CREATE flag, and specify

Re: [sqlite] creating unique data takes many hours, help

Michael: While my answer isn't strictly limited to sqlite, the performance nut in me can't help myself. You have a a table with only one column, a string. I could be wrong here but it seems like you just want to keep a list of values that you have already tried. After you insert a bunch of

[sqlite] Source code position out of sync debugging in VS 2008

I have added sqlite.c to my Visual Studio 2008 project and everything seems to be working in terms of database calls. However, when I step into an actual sqlite routine using the debugger, the source code position is out of sync with the actual location. For example, I step into