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: there
I have a composite index on queuedb made up of q_id, date,priority(in the
same order). I am trying to find out if the index is being used for both the
where clause and the order by clause. I have also posted the output for
EXPLAIN QUERY PLAN.
dbsql> explain select * from queuedb where q_id='59853
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
c-
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 Darnell
> 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 sa
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 t
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 want
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 binaries
work.
Thanks to all who
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 wr
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
[mailto:sqlite-users-boun...
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
library with your app
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 windows-foo please explain to me what I need to
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 (/
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 that doe not depend on
>
> 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
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
> in going from 32-
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 j
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 performance issue in SQLite
> that seems to be associated with mall
> 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 wit
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 the source of sqlite3 at 64-bit with c++
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 deta
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] Troublesh
> 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
(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 9:
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. Kr
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 using it in a (single-threa
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 o
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:
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
>
I have this case:
Thread 1 Thread 2
--
BEGIN EXCLUSIVE
BEGIN EXCLUSIVE -> BUSY
... etc ...
BEGIN EXCLUSIVE -> BUSY
COMMIT
BEGIN EXCLUSIVE -> OK
...
The
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.
>
> Ca
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 integrity check every time
> > > that
> > > our applicatio
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
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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-use
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.
>
__
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.
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 NUL
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 nL
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
>
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
40 matches
Mail list logo