Re: [sqlite] beginner

I have that book, also, and it is OK, but I ordered it online and didn't realize how much of it was dedicated to incorporating SQLite into applications. Of course, "Using SQLite" is the title, after all... I have SQL for Dummies, too, which I think is a nice supplement. One more thing:

Re: [sqlite] Troubleshooting...

Okay. I worked out a solution, but I am still unsure of why it fixes the problem. Or rather, I know why it works, but it still doesn't explain why the basic_string::c_str() call did not work. My only guess is that basic_string::c_str() doesn't really provide a pointer to a null-terminated

Re: [sqlite] Troubleshooting...

Pavel, I really appreciate you hanging with me on this subject. I can sometimes be a bit thick and your patience in dealing with my situation is greatly appreciated. The data I am using is a very small set of names pulled from an InDesign document text frame. They look like this: John

Re: [sqlite] Troubleshooting...

> So you can see that when I add the hard-coded data, everything looks fine in > the results of the select statement, which leads me to believe that the > problem is not confusion between UTF8 and UTF16 output. Your hardcoded data has only characters from ASCII set which don't differ from the

Re: [sqlite] Troubleshooting...

I could not figure out how to pipe my info to a file (I guess I am still a very young (at 57 years) newbie when it comes to SQLite) so I tried something else. In my code, I hardcoded the data instead of using variables. Here is a copy of one of the statement groups I am using to bind data to

Re: [sqlite] 64 bit sqlite 3

On 17 Dec 2010, at 4:30pm, Adam DeVita wrote: > Will a 64 bit Windows DLL eventually be posted for download? SQLite is distributed as source. Generally speaking you compile the amagamation form directly into your application rather than making a separate library of it. Whatever form you

Re: [sqlite] Windows performance problems associated with malloc()

On Fri, Dec 17, 2010 at 12:21 PM, Marcus Grimm wrote: > > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. > I have uploaded new executables, built in such a way (I hope) that no longer requires MSVCR100.dll. Please try again and let me know if the new

Re: [sqlite] Windows performance problems associated with malloc()

I believe the Windows default is to use the LFH on Vista and newer versions of Windows. The suggestion by Marcus Grimm to use _set_sbh_threshold() to enable use of the SBH (small block heap) may help under some usage scenarios on those platforms. -Shane On Fri, Dec 17, 2010 at 6:29 PM, Doug

Re: [sqlite] Windows performance problems associated with malloc()

I wonder if HeapSetInformation (which can enable a low-fragmentation heap) would be helpful too. You can set it on the process and the CRT heaps. Note that it's not available in Win2K and earlier. Doug -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] Windows performance problems associated with malloc()

Quoth Richard Hipp , on 2010-12-17 15:12:58 -0500: > Can somebody with windows-foo please explain to me what I need to do to > vs2010 so that it generates exe file that doe not depend on non-standard > DLLs? AFAIK, the platform-approved solution is to distribute the C runtime

Re: [sqlite] Windows performance problems associated with malloc()

On Fri, Dec 17, 2010 at 3:12 PM, Richard Hipp wrote: > On Fri, Dec 17, 2010 at 2:27 PM, John Drescher wrote: > >> > >> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. >> > >> That is visual studio 2010 runtime. >> > > Can somebody with

Re: [sqlite] Windows performance problems associated with malloc()

On 12/17/2010 3:12 PM, Richard Hipp wrote: > Can somebody with windows-foo please explain to me what I need to do to > vs2010 so that it generates exe file that doe not depend on non-standard > DLLs? If you are building from the command line, specify /MT (/MTd for debug builds) in place of /MD

Re: [sqlite] Windows performance problems associated with malloc()

On Fri, Dec 17, 2010 at 2:27 PM, John Drescher wrote: > > > > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. > > > That is visual studio 2010 runtime. > Can somebody with windows-foo please explain to me what I need to do to vs2010 so that it generates exe file

Re: [sqlite] Windows performance problems associated with malloc()

> > I'm unable to run your sqlite3.exe: MSVCR100.dll no found. > That is visual studio 2010 runtime. John ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows performance problems associated with malloc()

On Fri, Dec 17, 2010 at 8:29 AM, Richard Hipp wrote: > I also observe that compiling for 64-bit using vs2010 (not an option with my > ancient version 2.95.3 gcc cross-compiler) that the queries are an > additional 2x faster.  I was surprised at the dramatic performance increase >

Re: [sqlite] sqlite3_column_type issue

On 12/17/2010 4:36 AM, Sumedh wrote: > I am using C API > I am using sqlite3_column_type to determine, the type of column as it is > requirement for me to decide whether to return the value as string or > number. It works well, but not in case when i use left outer join. > > When i use left outer

Re: [sqlite] Windows performance problems associated with malloc()

From: "Richard Hipp" To: "General Discussion of SQLite Database" ; Sent: Friday, December 17, 2010 5:29 PM Subject: [sqlite] Windows performance problems associated with malloc() > An SQLite user has brought to our attention a

Re: [sqlite] Windows performance problems associated with malloc()

> An SQLite user has brought to our attention a performance issue in SQLite > that seems to be associated with malloc(). If you have insights or > corroborating experience with this issue please let me know. We recently had a malloc/free slowdown issue after changing to VS2008 in combination

Re: [sqlite] 64 bit sqlite 3

Will a 64 bit Windows DLL eventually be posted for download? On Fri, Dec 17, 2010 at 9:45 AM, Eric Smith wrote: > On Fri, Dec 17, 2010 at 4:36 AM, giuseppe500 wrote: > > There is a version of SQLite 3 for 64-bit systems? > > or, you can simply compile

[sqlite] Windows performance problems associated with malloc()

An SQLite user has brought to our attention a performance issue in SQLite that seems to be associated with malloc(). If you have insights or corroborating experience with this issue please let me know. SQLite supports a "zero-malloc option" (see http://www.sqlite.org/malloc.html#memsys5 for

Re: [sqlite] Troubleshooting...

Thanks, Pavel. I will do this. R, John > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Pavel Ivanov > Sent: Friday, December 17, 2010 9:22 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite]

Re: [sqlite] Troubleshooting...

> I am using SQLite3.exe to query the data with standard select statements > (select * from table).  Is there some setting within SQLite3 that I should be > manipulating to provide me UTF8 output? I'm not strong in that but I believe your settings should be not in SQLite3 but in Windows. Try to

Re: [sqlite] beginner

(Grin and embarrassed blush) I am. Quite useful, as a matter of fact. If you need an endorsement, please let me know. > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] > On Behalf Of Jay A. Kreibich > Sent: Friday, December 17, 2010

Re: [sqlite] beginner

On Fri, Dec 17, 2010 at 08:42:54AM -0600, john darnell scratched on the wall: > I am learning SQLite based on the O'Reilly book by Jay Kreibich, > called "USING SQLITE," which came out in August of this year, so > it's pretty up to date. I hope you're finding it useful. -j -- Jay A.

Re: [sqlite] 64 bit sqlite 3

On Fri, Dec 17, 2010 at 4:36 AM, giuseppe500 wrote: > There is a version of SQLite 3 for 64-bit systems? > or, you can simply compile the source of sqlite3 at 64-bit with c++ 2008? > thanks. FWIW I compiled sqlite 3.6.23.1 along with its tcl hooks and have been happily

Re: [sqlite] beginner

Hello Srindhi: From one SQLite beginner to another... SQLite and SQL are two different subjects. So you need to clarify for yourself what you want to do. Do you want to learn SQL? Then there are a number of good books you can get from Amazon to help you learn, and there are a number

Re: [sqlite] BUSY on COMMIT when EXCLUSIVE is held is an unexpected result

I'm using rollback - and no it's nothing like trying to commit inside a user-defined function. Very simple usage pattern. I'll isolate the code so that it's small enough to post here. I just noticed that I do sqlite3_busy_timeout(DB,0) - if that's relevant. Ben -Original Message- From:

Re: [sqlite] BUSY on COMMIT when EXCLUSIVE is held is an unexpected result

On 12/17/2010 07:54 PM, Ben Harper wrote: > I have this case: > > Thread 1 Thread 2 > -- > BEGIN EXCLUSIVE > BEGIN EXCLUSIVE -> BUSY > ... etc ... > BEGIN EXCLUSIVE -> BUSY > COMMIT >

[sqlite] BUSY on COMMIT when EXCLUSIVE is held is an unexpected result

I have this case: Thread 1 Thread 2 -- BEGIN EXCLUSIVE BEGIN EXCLUSIVE -> BUSY ... etc ... BEGIN EXCLUSIVE -> BUSY COMMIT BEGIN EXCLUSIVE -> OK ...

Re: [sqlite] beginner

On 17 Dec 2010, at 11:43am, Srinidhi Rao wrote: > I am interested to learn the nuances of a SQL but I have no background of > using one as I am an electronics student. > I would like to know few things, that does SQLite help me to learn and > devoid the space of not having any background. > >

Re: [sqlite] Pragma integrity_check takes a lot of time to complete

On Fri, Dec 17, 2010 at 2:17 AM, Max Vlasov wrote: > On Fri, Dec 17, 2010 at 2:47 AM, Richard Hipp wrote: > > > On Thu, Dec 16, 2010 at 4:12 PM, Marc wrote: > > > > > application. > > > > > > And another is it recommended to do a pragma

[sqlite] beginner

Hello SQLiters... I am interested to learn the nuances of a SQL but I have no background of using one as I am an electronics student. I would like to know few things, that does SQLite help me to learn and devoid the space of not having any background. Can any one suggest me where (and how...) to

[sqlite] sqlite3 backup

Hi all. I use Python's sqlite3. it is possible to backup a database without use the copy command file? -- Fabio Spadaro www.fabiospadaro.com ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] 64 bit sqlite 3

Hi, we compiled the amalgamation with VC++ 2010 64 bit and had no problems whatsoever. Martin Am 17.12.2010 10:36, schrieb giuseppe500: > There is a version of SQLite 3 for 64-bit systems? > or, you can simply compile the source of sqlite3 at 64-bit with c++ 2008? > thanks. >

[sqlite] 64 bit sqlite 3

There is a version of SQLite 3 for 64-bit systems? or, you can simply compile the source of sqlite3 at 64-bit with c++ 2008? thanks. -- View this message in context: http://old.nabble.com/64-bit-sqlite-3-tp30479452p30479452.html Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] sqlite3_column_type issue

Hi, I am using C API I am using sqlite3_column_type to determine, the type of column as it is requirement for me to decide whether to return the value as string or number. It works well, but not in case when i use left outer join. When i use left outer join, the column type returned is always

Re: [sqlite] UTF-8

Hello afriza, thanks for your quick replay. if i use the WCHAR or std'::wstring, should i used the _UNICODE macro in the Visual Studio Project setting? best regards ming On 16.12.2010 17:34, Afriza N. Arief wrote: > @Cory: correct. > > Fixed Code: > > HWND hWnd = /* from somewhere */; > int

Re: [sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

Hi, it was my own fault. Sorry for the noise. 3.7.4 is a lot faster. Martin Am 17.12.2010 09:30, schrieb Wiktor Adamski: > There is a lot more synchronization in 3.7.4. If you disable it new > version may be faster. > ___ > sqlite-users mailing list >

Re: [sqlite] Slowdown when switching from Version 3.2.5 to 3.7.4

There is a lot more synchronization in 3.7.4. If you disable it new version may be faster. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users