[sqlite] Fwd: [sqlite-dev] SQLIte 64bit precompiled libraries for Windows

Is there anyone publishing stable version of precompiled binaries of sqlite for Windows 64-bit ? I understand from the below sqlite.org doesn't, but there maybe another site? Thanks -- Forwarded message -- From: Dan Kennedy Date: Tue, Nov 30, 2010 at 6:58

Re: [sqlite] Just compiled SQLite in Visual Studio

Dustin Sallings wrote: > On Nov 30, 2010, at 18:04, Igor Tandetnik wrote: > >> It is true, however, that it's fairly easy to transform any C program into a >> program that's both valid C and C++, by applying >> straightforward modifications - tightening type safety and such. >

Re: [sqlite] Just compiled SQLite in Visual Studio

On Nov 30, 2010, at 18:04, Igor Tandetnik wrote: > It is true, however, that it's fairly easy to transform any C program into a > program that's both valid C and C++, by applying straightforward > modifications - tightening type safety and such. Except there are a lot of areas where C

Re: [sqlite] Just compiled SQLite in Visual Studio

On 11/30/2010 9:04 PM, Simon Slavin wrote: > Oh. No matter. It's the one Apple's Xcode calls and it's being very clever > about what language it's compiling. It defeated my test. > > Simon. a quick google query seems to imply that Xcode uses the Gnu Compiler Collection (gcc, g++, gcj,

Re: [sqlite] Just compiled SQLite in Visual Studio

Bob Keeland wrote: > Oh, from the various replies I see that C++ is a more capable extension of C. > Igor was only using a figure of speech, kind of. Everything I said in this thread so far, I meant quite literally. Which expression of mine do you take as a figure of

Re: [sqlite] Just compiled SQLite in Visual Studio

On 1 Dec 2010, at 1:46am, Reid Thompson wrote: > On 11/30/2010 8:42 PM, Simon Slavin wrote: >> On 1 Dec 2010, at 1:33am, Jay A. Kreibich wrote: >> >>> On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the >>> wall: >>> So every C program is a C++ program, >>> Not true.

Re: [sqlite] Just compiled SQLite in Visual Studio

Simon Slavin wrote: > So every C program is a C++ program Not quite true. Here are a few examples that are valid C but invalid C++: /* implicit 'int' return type */ f(); /* implicit conversion from void* to any pointer type */ char* p = malloc(100); // calling a

Re: [sqlite] Just compiled SQLite in Visual Studio

Bob Keeland wrote: > OK then I have a newbee question that is actually out of the scope of SQLite. > If the only difference between C and C++ is the > file extension, then what is the difference between C and C++? Since the premise of the question is false, any conclusion

Re: [sqlite] Just compiled SQLite in Visual Studio

On 11/30/2010 8:42 PM, Simon Slavin wrote: > On 1 Dec 2010, at 1:33am, Jay A. Kreibich wrote: > >> On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the wall: >> >>> So every C program is a C++ program, >> Not true. >> >> Try to compile sqlite3.c with a C++ compiler and see

Re: [sqlite] Just compiled SQLite in Visual Studio

On 1 Dec 2010, at 1:33am, Jay A. Kreibich wrote: > On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the wall: > >> So every C program is a C++ program, > > Not true. > > Try to compile sqlite3.c with a C++ compiler and see how far you get. Can you explain the problem to

Re: [sqlite] Just compiled SQLite in Visual Studio

On 11/30/2010 10:18 PM, Doug wrote: > Objects exist in > C++, and they don't in C actually objects can and do exist in C, it's just a matter of writing them. C++ added the extensions to make writing/managing them easier.

Re: [sqlite] Just compiled SQLite in Visual Studio

Oh, from the various replies I see that C++ is a more capable extension of C. Igor was only using a figure of speech, kind of. Sorry about the newbee question, but thanks for the replies.   Bob Keeland --- On Tue, 11/30/10, Simon Slavin wrote: From: Simon Slavin

Re: [sqlite] Just compiled SQLite in Visual Studio

On Wed, Dec 01, 2010 at 01:10:51AM +, Simon Slavin scratched on the wall: > So every C program is a C++ program, Not true. Try to compile sqlite3.c with a C++ compiler and see how far you get. -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear:

Re: [sqlite] Just compiled SQLite in Visual Studio

ailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users __ Information from ESET NOD32 Antivirus, version of virus signature database 5662 (20101130) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __

Re: [sqlite] Just compiled SQLite in Visual Studio

On 1 Dec 2010, at 1:01am, Bob Keeland wrote: > OK then I have a newbee question that is actually out of the scope of SQLite. > If the only difference between C and C++ is the file extension, No. > then what is the difference between C and C++? I'm thinking of adding a > language other than

Re: [sqlite] Just compiled SQLite in Visual Studio

OK then I have a newbee question that is actually out of the scope of SQLite. If the only difference between C and C++ is the file extension, then what is the difference between C and C++? I'm thinking of adding a language other than the Visual Basic that I kind of know and would like to know

Re: [sqlite] SQLITE transactions failing with multiple threads

On 30 Nov 2010, at 8:11pm, cricketfan wrote: > Drake, I am using SQLITE in threadsafe mode. Transaction inside another > transaction isnt that equivalent of nested transactions? Should that be > allowed? I have no problem opening another handle but just trying to > understand the intricacies,

Re: [sqlite] SQLITE transactions failing with multiple threads

Drake, It is in serialized mode. Opening another handle did resolve the issue. I am doing inserts in one thread and then if necessary update the same using another thread. Drake Wilson-3 wrote: > > Quoth cricketfan , on 2010-11-30 12:11:52 -0800: >> Drake, I

Re: [sqlite] cost of sqlite3_open

>It's not contradictory. I say that "real cost" of sqlite3_open is >parsing the schema. Igor says that this cost is actually deferred from >inside sqlite3_open call to the first "substantive" sqlite3_step call. >So you will have to pay this price anyway, just profiler output would >be somewhat

Re: [sqlite] Some floats of 15 digits or less do not round-trip

On Tue, Nov 30, 2010 at 12:29 AM, Shane Harrelson wrote: > It turns out the same problem exists on Linux (I used sqlite3-3.7.3.bin); for example: sqlite> create table t1(d float); sqlite> insert into t1 values(9.87e+31); sqlite> select * from t1; 9.870001e+31 So it

Re: [sqlite] SQLITE transactions failing with multiple threads

Quoth cricketfan , on 2010-11-30 12:11:52 -0800: > Drake, I am using SQLITE in threadsafe mode. Transaction inside another > transaction isnt that equivalent of nested transactions? Should that be > allowed? SQLite has named savepoints, but not nested BEGIN transactions.

Re: [sqlite] SQLITE transactions failing with multiple threads

Drake, I am using SQLITE in threadsafe mode. Transaction inside another transaction isnt that equivalent of nested transactions? Should that be allowed? I have no problem opening another handle but just trying to understand the intricacies, thanks. Drake Wilson-3 wrote: > > Quoth cricketfan

Re: [sqlite] searching with like on FTS3

It does but as you can see the like is only performed on a normal table and the match you find only entrys like " sql " or maby " selserver " but not "blablalbasqlstatic" Am Dienstag, den 30.11.2010, 11:50 -0800 schrieb Sam Roberts: > On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr

Re: [sqlite] searching with like on FTS3

On Mon, Nov 29, 2010 at 9:08 AM, Pascal Schnurr wrote: > Hi recently I noticed that i can't search with the like '%searchword%' > syntax on an FTS3 virtual table. I'm no expert, but are you sure? This exact example, using LIKE, appears in the FTS3 docs:

Re: [sqlite] cost of sqlite3_open

>> > 1) How "expensive" is a call to sqlite3_open. Does a call to >> sqlite3_enable_shared_cache make it "cheaper"? >> >>Its cost depends on the size of your schema as it gets parsed during >>open. > > Isn't this contradictory with an answer by Igor made in a recent thread? It's not

Re: [sqlite] cost of sqlite3_open

Pavel, > > 1) How "expensive" is a call to sqlite3_open. Does a call to > sqlite3_enable_shared_cache make it "cheaper"? > >Its cost depends on the size of your schema as it gets parsed during >open. Isn't this contradictory with an answer by Igor made in a recent thread? >Subject: Re:

Re: [sqlite] EXPLAIN QUERY PLAN

Thanks, Dan! On 11/30/10 9:05 AM, "Dan Kennedy" wrote: On 11/30/2010 11:38 PM, Duquette, William H (316H) wrote: > I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part > of the output is somewhat opaque. > > The command returns three columns:

Re: [sqlite] EXPLAIN QUERY PLAN

On 11/30/2010 11:38 PM, Duquette, William H (316H) wrote: > I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part > of the output is somewhat opaque. > > The command returns three columns: order, from, and detail. "order" is > evidently the order in which the indices are

[sqlite] creating a database

Okay, I seem to have figured it out. One needs to create the database and then add a table before the database will be created. Sorry for the baby steps. R, John A.M. Darnell Senior Programmer Walsworth Publishing Company Brookfield, MO John may also be reached at

Re: [sqlite] Creating a database.

On Tue, Nov 30, 2010 at 10:40:52AM -0600, john darnell scratched on the wall: > I know this is a fundamental question, but in the book I'm using to > learn SQLite, there is no reference that I can find for what one needs > to do to create a database. I thought that simply using a CREATE >

[sqlite] Creating a database.

I know this is a fundamental question, but in the book I'm using to learn SQLite, there is no reference that I can find for what one needs to do to create a database. I thought that simply using a CREATE statement with a database name included might do the trick, but alas it does not. I went

[sqlite] EXPLAIN QUERY PLAN

I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part of the output is somewhat opaque. The command returns three columns: order, from, and detail. "order" is evidently the order in which the indices are applied; the "detail" explains which table and index is involved.

Re: [sqlite] Just compiled SQLite in Visual Studio

Thanks Igor. -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, November 29, 2010 7:11 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Just compiled SQLite in Visual Studio john darnell

Re: [sqlite] SQLITE transactions failing with multiple threads

On 30 Nov 2010, at 3:49pm, cricketfan wrote: >I have 2 threads in my program, 1st thread is doing inserts into a > table and 2nd thread is trying to update the already inserted columns. > 1. I have bundled the 1000 inserts per transaction in 1st thread. > 2. When I try to start a

Re: [sqlite] SQLITE transactions failing with multiple threads

Quoth cricketfan , on 2010-11-30 07:49:36 -0800: > Also not that both threads are > using the same handle passed by main. No, don't do that. Using the same handle in two threads concurrently can break depending on the SQLite threading mode, and will gain you no

[sqlite] SQLITE transactions failing with multiple threads

Hello, I have 2 threads in my program, 1st thread is doing inserts into a table and 2nd thread is trying to update the already inserted columns. 1. I have bundled the 1000 inserts per transaction in 1st thread. 2. When I try to start a transaction in the 2nd thread for my updates (when

Re: [sqlite] cost of sqlite3_open

> 1) How "expensive" is a call to sqlite3_open. Does a call to > sqlite3_enable_shared_cache make it "cheaper"? Its cost depends on the size of your schema as it gets parsed during open. Shared cache doesn't make it cheaper. It can make somewhat cheaper (in some cases) to use several connections

[sqlite] cost of sqlite3_open

Hi, I'm working on a multi-threaded image server and I have 2 questions: 1) How "expensive" is a call to sqlite3_open. Does a call to sqlite3_enable_shared_cache make it "cheaper"? 2) If sqlite3_open is an expensive operation then I would like to keep a list (cache) of open database

[sqlite] searching with like on FTS3

Hi recently I noticed that i can't search with the like '%searchword%' syntax on an FTS3 virtual table. And with "match" i can't search on example sentences (the indexed data is a japanese dictionary an therefore has no spaces in example sentences and there is no perfekt tokenizer atm i tried

Re: [sqlite] WAL mode and backup API

On 30.11.2010 11:50, Dan Kennedy wrote: > >> BTW: >> Is there any chance that in the future the wal mode >> will avoid that the backup API will restart on DB >> changes during the backup loop ? >> Currently, even in wal mode, it does restart when changes >> are detected while the backup is

Re: [sqlite] WAL mode and backup API

> BTW: > Is there any chance that in the future the wal mode > will avoid that the backup API will restart on DB > changes during the backup loop ? > Currently, even in wal mode, it does restart when changes > are detected while the backup is ongoing. What happens if you open a read transaction

Re: [sqlite] Question

As said off topic - but I have never heard of a cell ID being recorded with an SMS message. You can find more info on the SMS message format by search for "sms pdu" (protocol description unit) you can see from this somewhat complex structure that the cell ID is not part of the transmitted message

Re: [sqlite] WAL mode and backup API

On 30.11.2010 11:32, Dan Kennedy wrote: > On 11/30/2010 05:03 PM, Marco Bambini wrote: >> Hello, >> >> if a running sqlite database is in WAL mode and a backup is performed on >> that db using the sqlite3_backup API, does that process is considered like a >> reader and can proceed concurrently

Re: [sqlite] WAL mode and backup API

On 11/30/2010 05:03 PM, Marco Bambini wrote: > Hello, > > if a running sqlite database is in WAL mode and a backup is performed on that > db using the sqlite3_backup API, does that process is considered like a > reader and can proceed concurrently with other readers and with the other > writer?

[sqlite] WAL mode and backup API

Hello, if a running sqlite database is in WAL mode and a backup is performed on that db using the sqlite3_backup API, does that process is considered like a reader and can proceed concurrently with other readers and with the other writer? Thanks a lot for your answer. -- Marco Bambini