Re: [sqlite] Problem with LIMIT and transactions? Or is it just me

2003-10-22 Thread ben . carlyle
Howdy, "Jay Macaulay" <[EMAIL PROTECTED]> 23/10/2003 05:55 AM To: <[EMAIL PROTECTED]> cc: Subject:[sqlite] Problem with LIMIT and transactions? Or is it just me > I am running into a real odd problem that I hope someone can explain. I > have a

Re: [sqlite] Journalling

2003-10-27 Thread ben . carlyle
Hello, v t <[EMAIL PROTECTED]> 27/10/2003 05:16 PM To: "Mrs. Brisby" <[EMAIL PROTECTED]> cc: sqlite <[EMAIL PROTECTED]> Subject:Re: [sqlite] Journalling > I am trying to use sqlite in a context where I will be using it to store some configuration

Re: Re[2]: [sqlite] Performance problem

2003-11-03 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 04/11/2003 02:26 PM - Ben Carlyle 04/11/2003 02:01 PM To: Doug Currie <[EMAIL PROTECTED]> cc: Subject:Re: Re[2]: [sqlite] Performance problem Doug Currie <[EMAIL PROTECTED]> 03/11/2003 05:

Re: [sqlite] Performance problem

2003-11-06 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 07/11/2003 10:00 AM - Ben Carlyle 07/11/2003 10:00 AM To: "Mrs. Brisby" <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] Performance problem "Mrs. Brisby" <[EMAIL PR

Re: [sqlite] database table is locked

2003-11-06 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 07/11/2003 10:03 AM - Ben Carlyle 07/11/2003 10:03 AM To: Thiago Mello <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] database table is locked Thiago Mello <[EMAIL PROTECTED]> 08/11/2

Re: [sqlite] Concurrency in SQLite

2003-11-24 Thread ben . carlyle
G'day, "D. Richard Hipp" <[EMAIL PROTECTED]> 24/11/2003 03:22 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Concurrency in SQLite > Please, give me some examples of the kinds of things you are > doing which could benefit from improved concurrency. >

RE: [sqlite] Documentation

2004-01-05 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 06/01/2004 08:34 AM - Ben Carlyle 06/01/2004 08:31 AM To: "Allan Edwards" <[EMAIL PROTECTED]>@CORP cc: Subject:RE: [sqlite] Documentation Hello, "Allan Edwards" <[EMAIL PR

Re: [sqlite] locked - what am I doing wrong?

2004-01-08 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 09/01/2004 10:44 AM - Ben Carlyle 09/01/2004 09:35 AM To: "David Swigger" <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] locked - what am I doing wrong? G'day, "David Swigg

Re: [sqlite] Clarification on file locking in web-served apps

2004-01-14 Thread ben . carlyle
Vania, Vania Smrkovski <[EMAIL PROTECTED]> 15/01/2004 12:14 PM Please respond to vania To: "SQLite-Users (E-mail)" <[EMAIL PROTECTED]> cc: Subject:[sqlite] Clarification on file locking in web-served apps > Why the heck would anyone even need

Re: [sqlite] Converting Sqlite to Myqsl

2004-01-21 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 22/01/2004 11:13 AM - Ben Carlyle 22/01/2004 11:06 AM To: Martin Brinkmann <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] Converting Sqlite to Myqsl Martin, Martin Brinkmann <[EMAIL PROTE

Re: [sqlite] Primary key and index

2004-02-08 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 09/02/2004 12:04 PM - Ben Carlyle 09/02/2004 12:04 PM To: Bertrand Mansion <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] Primary key and index Bertrand, Bertrand Mansion <[EMAIL PROTECTE

RE: [sqlite] multithreading

2004-02-26 Thread ben . carlyle
"rumcais" <[EMAIL PROTECTED]> 26/02/2004 05:16 PM To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> cc: Subject:RE: [sqlite] multithreading > I've make some experiments around accessing the SQLite database fom concurent processes at the same time > and I find

Re: [sqlite] multithreading

2004-02-26 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 27/02/2004 09:53 AM - Ben Carlyle 27/02/2004 09:49 AM To: [EMAIL PROTECTED]@CORP cc: Subject:Re: [sqlite] multithreading Dave, [EMAIL PROTECTED] 26/02/2004 04:56 PM To: [EMAIL PROTECTED

Re: [sqlite] Delete a database file

2004-02-26 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 27/02/2004 09:54 AM - Ben Carlyle 27/02/2004 09:34 AM To: "Benoit Gantaume" <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] Delete a database file Benoit, "Benoit Gantaume"

RE: [sqlite] Resetting primary key auto-increment after table re-create

2004-03-08 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 09/03/2004 10:56 AM - Ben Carlyle 09/03/2004 10:54 AM To: "Roger Hawkins" <[EMAIL PROTECTED]>@CORP cc: Subject:RE: [sqlite] Resetting primary key auto-increment after table re-create Ro

Re: [sqlite] sqlite not sharing page cache across processes?

2004-03-21 Thread ben . carlyle
Mark, "Mark D. Anderson" <[EMAIL PROTECTED]> 22/03/2004 05:15 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] sqlite not sharing page cache across processes? > It appears from looking at pager.c that every process working > with a database acquires its

Re: [sqlite] Text(3)

2004-03-24 Thread ben . carlyle
"Anabell Chan" <[EMAIL PROTECTED]> 24/03/2004 05:23 PM Please respond to anabell To: <[EMAIL PROTECTED]> cc: Subject:[sqlite] Text(3) > Firstly, how do I define a string table field with constraints on its size? > For example Text(3), string of three

Re: [sqlite] Search results

2004-03-25 Thread ben . carlyle
Greg, "Greg Obleshchuk" <[EMAIL PROTECTED]> 26/03/2004 03:29 PM To: <[EMAIL PROTECTED]> cc: Subject:[sqlite] Search results > In the database I will have three columns where I will be searching for matches , my question is what type of method do

[sqlite] Concurrency Proposal

2004-03-30 Thread ben . carlyle
G'day, I've been mulling over this for a little while, but only got around to writing anything down last night. I may have made some errors, perhaps serious ones. Either way, I thought I'd just put it out there. This email contains an algorithm for permitting concurrent reader and writer

Re: [sqlite] Concurrency Proposal

2004-03-30 Thread ben . carlyle
- Forwarded by Ben Carlyle/AU/IRSA/Rail on 31/03/2004 02:38 PM - Ben Carlyle 31/03/2004 02:34 PM To: "D. Richard Hipp" <[EMAIL PROTECTED]>@CORP cc: Subject:Re: [sqlite] Concurrency Proposal Peoples, "D. Richard Hipp"

Re: [sqlite] Concurrency Proposal

2004-04-01 Thread ben . carlyle
G'day, "D. Richard Hipp" <[EMAIL PROTECTED]> 31/03/2004 01:21 PM To: [EMAIL PROTECTED] cc: Subject:Re: [sqlite] Concurrency Proposal > I think the gist of Ben's proposal is as follows > (please correct me if I am wrong): > Writes do not modify the

Re: [sqlite] A proposal for SQLite version 3.0

2004-04-07 Thread ben . carlyle
Peoples :) "D. Richard Hipp" <[EMAIL PROTECTED]> 07/04/2004 11:22 PM To: [EMAIL PROTECTED] cc: Subject:[sqlite] A proposal for SQLite version 3.0 > A design proposal for SQLite version 3.0 can be found at: > http://www.sqlite.org/prop2.html >

[sqlite] Clustered indicies Was: [sqlite] A proposal for SQLite version 3.0

2004-04-07 Thread ben . carlyle
Jeff, Jeff Pleimling <[EMAIL PROTECTED]> 08/04/2004 12:42 PM To: [EMAIL PROTECTED] cc: Subject:Re: [sqlite] A proposal for SQLite version 3.0 At 12:08 PM 4/8/2004 +1000, [EMAIL PROTECTED] wrote: > I believe you're thinking of a 'clustered index'. This

[sqlite] Effectiveness of PRAGMA integrity_check;

2004-04-13 Thread ben . carlyle
G'day, I'm trying to write some defensive code that is able to recover from database corruption. The idea is that if a disk fails and a database becomes corrupt it can be detected and synchronised from a backup copy. To this end, I've just been trying to write a function that returns true

Re: [sqlite] command history

2004-05-03 Thread ben . carlyle
Puneet, Puneet Kishor <[EMAIL PROTECTED]> 03/05/2004 05:01 AM To: SQLite <[EMAIL PROTECTED]> cc: Subject:[sqlite] command history > Is there a way to enable some kind of command history in the SQLite > shell? You know, press the up arrow to get the

Re: [sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 Issue 115

2004-05-23 Thread ben . carlyle
G'day, Ulrik Petersen <[EMAIL PROTECTED]> 23/05/2004 07:31 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 - Issue 115 > Read especially section 3.2. The EULA is here: >

Re: [sqlite] Sqlite Secure backup

2004-06-03 Thread ben . carlyle
David Costa <[EMAIL PROTECTED]> 03/06/2004 09:26 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Sqlite Secure backup > I am in the process of writing a PEAR package to handle Sqlite backups > (both local backups and remote backups) and I am looking for

Re: [sqlite] getpid() and linux threads in sqlite

2004-06-03 Thread ben . carlyle
Hello, "Mrs. Brisby" <[EMAIL PROTECTED]> 03/06/2004 01:37 PM To: Daniel K <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED] Subject:Re: [sqlite] getpid() and linux threads in sqlite > On Wed, 2004-06-02 at 01:53, Daniel K wrote: > > The getpid() call on my

[sqlite] create trigger before commit...

2004-06-15 Thread ben . carlyle
G'day, I seem to recall (but cannot find) an email on this mailing list sent by drh quite sometime ago regarding triggers before commits. As I recall, he was battling with some kind of problem for which a trigger that executed immediately before the commit was executed seemed to be the best

Re: [sqlite] Locking and concurrency in SQLite version 3.0

2004-06-16 Thread ben . carlyle
G'day, "D. Richard Hipp" <[EMAIL PROTECTED]> 12/06/2004 08:16 AM To: [EMAIL PROTECTED] cc: Subject:[sqlite] Locking and concurrency in SQLite version 3.0 > http://www.sqlite.org/lockingv3.html My thoughts are listed as they come to me. Thought 1:

Re: [sqlite] SQLite performance with mid-size databases

2004-06-17 Thread ben . carlyle
Raymond, So far on this list I have only seen a reports of scalability problems with sqlite when the real problems were specific queries being given to sqlite that were constructed in a way that sqlite does not process well. In every such case I can recall an alternative form of the query was

Re: [sqlite] RE: SQLite performance with mid-size databases

2004-06-17 Thread ben . carlyle
"Ismail Kizir" <[EMAIL PROTECTED]> 17/06/2004 06:48 PM To: <[EMAIL PROTECTED]> cc: Subject:Re: [sqlite] RE: SQLite performance with mid-size databases > I had the same problem as Richard's. > Unfortunately, i have decided to use postgres and finally back

Re: [sqlite] database corruption

2004-06-24 Thread ben . carlyle
Hello, "D. Richard Hipp" <[EMAIL PROTECTED]> 24/06/2004 06:04 AM To: cc: [EMAIL PROTECTED] Subject:Re: [sqlite] database corruption > Michael Robinette wrote: > > ... > You present a new and novel approach to corrupting the database, which > is to

[sqlite] A quick code review, analysis of locking model, "fine-tuning" suggestions

2004-06-24 Thread ben . carlyle
G'day, I thought I'd so somewhat of a code review on the lower-level pieces of sqlite 3.0.1, so here goes: v- code review v You use a loop here to try and write all data synchronously to disk. I had to read it a couple of times before I realised it was

Re: [sqlite] strange rounding problem

2004-10-13 Thread ben . carlyle
Donald, Will Leshner <[EMAIL PROTECTED]> 14/10/2004 04:20 AM Please respond to sqlite-users To: [EMAIL PROTECTED] cc: Subject:Re: [sqlite] strange rounding problem >The point is that the number is in the database as '358', but by the time we get it

Re: [sqlite] Client/Server Environment

2004-11-09 Thread ben . carlyle
Hello, "Clay Dowling" <[EMAIL PROTECTED]> 09/11/2004 02:39 AM Please respond to sqlite-users To: [EMAIL PROTECTED] cc: Subject:Re: [sqlite] Client/Server Environment > Richard Boehme said: > > Hi there. How well does SQLite do in a client/server

Re: [sqlite] Suppressing column (field) headers?

2004-11-21 Thread ben . carlyle
Hello, [EMAIL PROTECTED] 21/11/2004 04:56 PM Please respond to sqlite-users To: [EMAIL PROTECTED] cc: Subject:[sqlite] Suppressing column (field) headers? > 1. How can I get the dll to return JUST the desired data? >When I send the following