Re: [sqlite] Is there a command to lock a database for a short while (0.25 sec, say)

On Wed, 17 Apr 2013 15:39:50 +0200 "J Trahair" wrote: > I'm looking for a way to ensure other users aren't allowed to write > to the database during this quarter-second period. That might work for you this time, but it doesn't scale well; historically that's why

Re: [sqlite] CLI Source Code

Oh never mind. Instructions are at the bottom of the CLI page itself. :] On Wed, Apr 17, 2013 at 11:54 AM, Stephen Chrzanowski wrote: > Maybe I'm blind, but, I don't see the source code for the CLI on the > download page. Is this an oversight, or by design? >

[sqlite] CLI Source Code

Maybe I'm blind, but, I don't see the source code for the CLI on the download page. Is this an oversight, or by design? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a command to lock a database for a short while (0.25 sec, say)

Don't forget that your "other" applications will need to extend their connection time outs, otherwise, while "this" application has the lock, the "other" applications will time out and throw errors. On Wed, Apr 17, 2013 at 9:43 AM, Simon Davies wrote: > On 17 April

Re: [sqlite] RTree Documentation Error?

It would also be nice if 3.3 showed the "expected output" too. Would be a bit easier for the beginner to ensure they are sane. Also would've prevented this GIGO error me thinkst. Michael Black ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Is there a command to lock a database for a short while (0.25 sec, say)

On 17 April 2013 14:39, J Trahair wrote: > Hi everyone > > Can my application lock the database for its own exclusive use at the > beginning of a series of INSERTs UPDATEs and SELECTs, then unlock it again > afterwards? I've read about the five locking states

[sqlite] Is there a command to lock a database for a short while (0.25 sec, say)

Hi everyone Can my application lock the database for its own exclusive use at the beginning of a series of INSERTs UPDATEs and SELECTs, then unlock it again afterwards? I've read about the five locking states (unlocked, shared, etc.) but I assume the dll handles all that at INSERT or UPDATE

Re: [sqlite] RTree Documentation Error?

On Wed, Apr 17, 2013 at 9:25 AM, Michael Black wrote: > Correct -- no results for the "real" 2nd query > I see. I ran two queries together in my script so what I thought was the 2nd query was really the 3rd. The SQLite HQ coordinates are fixed in

Re: [sqlite] RTree Documentation Error?

Correct -- no results for the "real" 2nd query ...you got no results for it either.\ Then 2nd query is this and produces no results...nor should it with the data given. SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND minY>=35.00 AND maxY<=35.44; I think the data point you

Re: [sqlite] RTree Documentation Error?

On Wed, Apr 17, 2013 at 8:41 AM, Michael Black wrote: > I think the point is that this query that produces nothing: > SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND > minY>=35.00 AND maxY<=35.44; > > Should produce something as the directions imply. >

Re: [sqlite] RTree Documentation Error?

I think the point is that this query that produces nothing: SELECT id FROM demo_index WHERE minX>=-81.08 AND maxX<=-80.58 AND minY>=35.00 AND maxY<=35.44; Should produce something as the directions imply. It's just that SQL HQ is not actually inside the city limits apparently (mailing addresses

Re: [sqlite] sqlite3 or sqlite4 for a new project?

On Wed, Apr 17, 2013 at 8:30 AM, Paolo Bolzoni < paolo.bolzoni.br...@gmail.com> wrote: > Dear list, > The subject pretty much says it all. I want to use sqlite in a small > software I am writing, > and I would like to know what are the reason of using sqlite3 or 4. > sqlite4 is still

[sqlite] sqlite3 or sqlite4 for a new project?

Dear list, The subject pretty much says it all. I want to use sqlite in a small software I am writing, and I would like to know what are the reason of using sqlite3 or 4. The newer version seems quite an improvement, but as far as I can tell it not very used yet. What is the reason? It is not

[sqlite] How to Cross Compile SQLite3 inside the SBC

May I know the step of cross compile the sqlite inside the single board computer(SBC-TS5500)?I have done my code on the terminal.Now I need the guide on cross compile and then to test my sqlite code in the sbc environment. -- View this message in context:

Re: [sqlite] Beginning database question

This is a tough one to answer because there is so much context to consider. SQLite, or any database, could easily solve the problem you mention (storing values that can change without needing to recompile your program). Whether it's more efficient is another question. If you think you'll

[sqlite] Bug report: small bug in shell.c

I have found that the following command in my opinion returns an incorrect exit code: eric@sirius:~/src/sqlite-amalgamation-3071602$ ./sqlite3 appl.db .quit eric@sirius:~/src/sqlite-amalgamation-3071602$ echo $? 2 This should (in my opinion) return 0 for success instead of 2. In interactive

Re: [sqlite] RTree Documentation Error?

On Wed, Apr 17, 2013 at 7:48 AM, Clemens Ladisch wrote: > Richard Hipp wrote: > > On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani wrote: > >> Hi, I was looking at the RTree documentation page with one of my > >> colleagues -

Re: [sqlite] RTree Documentation Error?

Richard Hipp wrote: > On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani wrote: >> Hi, I was looking at the RTree documentation page with one of my >> colleagues - >> >> We tried the example with the schema in 3.1, populated the data from 3.2 >>

Re: [sqlite] RTree Documentation Error?

On Tue, Apr 16, 2013 at 1:15 PM, Mohit Sindhwani wrote: > Hi, I was looking at the RTree documentation page with one of my > colleagues - > http://www.sqlite.org/rtree.**html > > We tried the example with the schema in 3.1, populated the data

Re: [sqlite] Help speed up query

On Tue, Apr 16, 2013 at 8:52 PM, wrote: > Simon and everyone who has thrown ideas into the mix, > I very much appreciate the effort that you folks have put into this! > If nothing else, I am learning from this exorcise. > At this point, sounds like the only way to possibly