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?
thanks
Bert Verhees
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).
J
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, when
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
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" (http://www.unicom.com/pw/reply-to
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
-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 author
> 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.
>
> 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 purpos
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) wrot
I, on the other hand, prefer to have a reply-to in a mailing list go to that mailing
list. For the rare occassion that I reply to someone personally on a mailing list, I
don't mind the extra steps to get their email address. I think what you're going to
find with this topic is that you will ma
> 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.
>
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
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 and
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 unmunge
[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 su
> 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 look
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 EXI
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 volunteer
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 delet
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
m
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
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.
--
http://www.vel
> 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 does
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 the only
GET
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 no
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 th
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
somehow i've managed to corrupt my db - the error was
./src/pager.c:1179: syncJournal: Assertion `pPager->nRec*pgSz+hdrSz==jSz' failed.
running PRAGMA integrity_check yields something like
carp:~/eg/ruby/rq/rq-0.1.2 > sqlite q 'PRAGMA integrity_check' | head
*** in database main ***
On page
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 like
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
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 larg
I put it all on a web-page, also the needed binaries.
http://www.rosa.nl/Bold2/
Kind regards
Bert Verhees
33 matches
Mail list logo
