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 SQL,
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 environment
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 back
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 combine a
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
file name=os_unix.c
comment lines=546-549 function=sqlite3OsWrite
importance=high
You use a loop here to try and write all data
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
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 to mysql.
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
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 some
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 Redhat9
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
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
Feedback
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
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 main
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
- 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 [EMAIL PROTECTED]
31/03/2004 01
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 characters.
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 own
- 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
Roger,
Roger Hawkins
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 it work
- 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
- 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 [EMAIL PROTECTED]
26/02/2004 08
- 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 PROTECTED]
09/02/2004
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 Transactions
- 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 Swigger [EMAIL PROTECTED]
09/01
- 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 PROTECTED]
06/01/2004 12:18 AM
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.
* Are
- 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 PROTECTED]
07/11/2003 12:08 AM
- 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/2003 09:00 AM
- 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:39 AM
Please
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 about a
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 simple query:
35 matches
Mail list logo