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
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
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
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
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
"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
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
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:
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
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
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
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:
>
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
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
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
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
>
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
- 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"
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
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
"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
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
- 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
- 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"
- 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
"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
- 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
- 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
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
- 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
- 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
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.
>
- 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
- 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
- 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:
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
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
37 matches
Mail list logo