At 11:49 AM -0500 7/23/04, Greg Miller wrote:
There are certainly a few drawbacks to using Reply-To, but I can't
remember the last time I was on a mailing list that didn't make use
of it. Clearly, there's a very solid consensus out there that
Reply-To is the way to go.
That may be because a
Yes, i'm fine with the synchronous=YES -> synchronous=FULL.
It's the good choice.
But in my case, i always need synchronous=OFF.
I'm working on an high availability project using the model
of Extended Virtual Synchrony. For the speed of
the distributed system during update/insert, i need
to reduce
On Fri, 23 Jul 2004 18:50:49 +0200, you wrote:
>
>> How do you renumber an index anyway?
>
>Hmm ... given the tables
> work (idx, sortcrit)
> storeroom(rowcount integer)
>
>where 'idx' may be the index to renumber and 'sortcrit' a sorting criteria.
>
>I would try to do something
b.bum wrote:
Some more locking questions...
When sqlite3OsLock() takes out the PENDING lock, it switches between
RDLOCK and WRLOCK depending on the locktype requested.
However, it doesn't appear that any subsequent code checks for RDLOCK
vs.WRLOCK on the PENDING BYTE. Actually, it appears that
On Fri, 2004-07-23 at 10:25, D. Richard Hipp wrote:
> Dan Keeley wrote:
> > Or, why dont we have a vote, and once it's decided, tuff luck thats how
> > it stays? :)
> >
>
> Better: Somebody please write me a simple, secure, mail handler to
> replace qmail/ezmlm that lets each user decide for
Guillaume Fougnies wrote:
>
> PRAGMA default_synchronous disappeared from 3.x. Should we now execute a
> PRAGMA synchronous each time a db is opened?
>
Yes. The thinking was that there is rarely ever a good
reason to make a persistent database less than fully synchronous.
So synchronous=FULL is
> How do you renumber an index anyway?
Hmm ... given the tables
work (idx, sortcrit)
storeroom(rowcount integer)
where 'idx' may be the index to renumber and 'sortcrit' a sorting criteria.
I would try to do something like the code below, but I just remembered that
sqlite
Michael Roth wrote:
Please switch off Reply-To again.
There are certainly a few drawbacks to using Reply-To, but I can't
remember the last time I was on a mailing list that didn't make use of
it. Clearly, there's a very solid consensus out there that Reply-To is
the way to go.
--
Hello,
PRAGMA default_synchronous disappeared from 3.x.
Should we now execute a PRAGMA synchronous each time a db is
opened?
Could it be possible to get a configure flag or a define
in sqliteInt.h to set this by default?
Regards,
--
Guillaume FOUGNIES
SQLite Version 3.0.3
When I compile my own sqlite3.exe binary and try to create a table, I
get the message "database is locked". This happens when I use the
configure script from the sqlite tarball, or when compiling the objects
seperately and linking with the sqlite-source zip file. The same
Le ven 23/07/2004 à 14:38, Jay Macaulay a écrit :
> Removing the Reply-To makes me have to view the mail properties, find the
> From email, then type that in. On the other hand, if I wanted to reply to
> the list before and not to a person directly, all I had to do was hilight
> the name and
On Fri, 23 Jul 2004, Brass Tilde wrote:
> > Better: Somebody please write me a simple, secure, mail handler to
> > replace qmail/ezmlm that lets each user decide for themselves whether
> > they want a Reply-To back to the mailing list or unmunged headers.
> >
> > I'll be happy to supply
D. Richard Hipp wrote:
Bert Verhees wrote:
Hello,
Are there any plans in the near feature to implement the keywords
EXISTS and ALTER TABLE?
These to keywords/functions are very important when using SQLite in a
MDA (Model Driven Architecture) where SQL-code is generated?
There are plans to add
> Better: Somebody please write me a simple, secure, mail handler to
> replace qmail/ezmlm that lets each user decide for themselves whether
> they want a Reply-To back to the mailing list or unmunged headers.
>
> I'll be happy to supply volunteers with a detailed specification of
> what I am
[EMAIL PROTECTED] wrote:
Fredrik Axelsson <[EMAIL PROTECTED]> writes:
I need to count the number of occurances of different characters in a string
in my database. So that I can select records where a string contains a number
of occurences of a certain character (independent of order). I'm not
Dan Keeley wrote:
Or, why dont we have a vote, and once it's decided, tuff luck thats how
it stays? :)
Better: Somebody please write me a simple, secure, mail handler to
replace qmail/ezmlm that lets each user decide for themselves whether
they want a Reply-To back to the mailing list or
Bert Verhees wrote:
Hello,
Are there any plans in the near feature to implement the keywords
EXISTS and ALTER TABLE?
These to keywords/functions are very important when using SQLite in a
MDA (Model Driven Architecture) where SQL-code is generated?
There are plans to add EXISTS and ALTER TABLE
Or, why dont we have a vote, and once it's decided, tuff luck thats how it
stays? :)
_
It's fast, it's easy and it's free. Get MSN Messenger today!
http://www.msn.co.uk/messenger
> If you put an Reply-To Header in the mail, you make this options
> disfunctional. Now, both buttons do the same thing, they don't work as
> expected.
>
> Freedom is all about choice. Reply-To tries to disable the choice. Not
> very friendly, in my opinion.
>
> Please switch off Reply-To again.
>
I'll try it and give you a feedback!!
Thank you so much! =)
Roger.
- Original Message -
From: "Andy Colson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 22, 2004 9:56 PM
Subject: Re: [sqlite] Versions 2.8.15 and 3.0.3 available
> Roger Reghin (Duty/Sedes/CWB)
> As an experiment, I have turned on Reply-To munging. Reply-To now
> points back to the mailing list (assuming I did it right).
I'll be interested in seeing how this turns out. I've been waffling on the
issue since reading the original essay, but the rebuttal makes some good
points. The
> If you put an Reply-To Header in the mail, you make this options
> disfunctional. Now, both buttons do the same thing, they don't work as
> expected.
>
> Freedom is all about choice. Reply-To tries to disable the choice. Not
> very friendly, in my opinion.
>
> Please switch off Reply-To again.
>
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
D. Richard Hipp wrote:
| As an experiment, I have turned on Reply-To munging. Reply-To now
| points back to the mailing list (assuming I did it right).
IMHO this is a annoying experiment.
MUAs have two buttons or key-bindings: One replies to the
On Thu, 22 Jul 2004, Will Leshner wrote:
>Ok. I think I know what is going on. Each of the rows in my database
>is "too big" to fit on the main page (about 320 bytes for each row).
>So each one is forcing an overlow page. I'm assuming that each
>overflow page only stores one row of data. In other
Nuno Lucas wrote:
Don't want to start any flame war, but found this, which I consider are
valid points for the "reply-to" mail header:
http://www.metasystema.net/essays/reply-to.mhtml
Written in response to Chip Rosenthal's "Reply-To Munging Considered
Harmful"
Andrew Clark wrote:
Not knowing the code that well but guessing I would say that because the
statements are on a single line I believe maybe the SQL interpreter is
reading the BEGIN (start a transaction) but not reading the rest of the
commands when an error occurs and therefore doesn't see the
Hi,
Using the C API if i submit the statements:
BEGIN;
CREATE TABLE test (id, name);
COMMIT;
within a single Exec command (or as a single line on the command line
tool) then it works the first time and displays an error the second time
as expected due to the table already existing.
However,
Don't want to start any flame war, but found this, which I consider are
valid points for the "reply-to" mail header:
http://www.metasystema.net/essays/reply-to.mhtml
Written in response to Chip Rosenthal's "Reply-To Munging Considered
Harmful" (http://www.unicom.com/pw/reply-to-harmful.html).
At 1:46 PM +0800 7/23/04, Ng Pheng Siong wrote:
I'd imagine keeping DBD::SQLite for v2 and creating DBD::SQLite3 for v3 is
the most straightforward approach.
Actually, I just thought of a counter-example that may work even
better. I propose that the existing DBD::SQLite name keep going as
it is
29 matches
Mail list logo