On Fri, 2007-05-04 at 18:22 -0400, Vitali Lovich wrote:
> Hi,
>
> I was wondering what would be the optimal way to select 1 matching row
> from multiple tables. Here is the scenario.
>
> Multiple tables contain a primary key KEY. If Table1 contains a
> matching KEY, then I want that row from
Thanks again Ulrik...the problem was with the tokenizer and not the
parser...
Medi
-Original Message-
From: Medi Montaseri [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 5:14 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Lemon parser generator question
Thanks Ulrik...I am
Thanks Ulrik...I am now looking for the lexer...
Medi
-Original Message-
From: Ulrik Petersen [mailto:[EMAIL PROTECTED]
Sent: Friday, May 04, 2007 4:30 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Lemon parser generator question
Medi,
Lemon is a parser, not a lexer. The
I did a comparison some time back between gcc and IBM's Xlc. The IBM
compiler was a bit slower to compile but the fully optimized executables
were quite different in performance. Xlc's executable ran 40% faster.
A look at the generated code showed that the IBM optimizer was carefully
matched
Medi,
Lemon is a parser, not a lexer. The terminals are defined outside of
Lemon. Perhaps you inherited the .y file but did not receive the
lexer/tokenizer?
SQLite, for example, has a hand-coded tokenizer. Other projects (such
as my own) may use a lexer-generator such as flex.
In
Hi,
Firstly, if this is not the proper forum for Lemon questions, please let
me know where I need to go...
Second, I am looking at a SQL grammer written for Lemon parser generator
and am failing to see where some terminals are defined. For example
COMMA, FROM, SELECT are terminals and
Hi,
I was wondering what would be the optimal way to select 1 matching row
from multiple tables. Here is the scenario.
Multiple tables contain a primary key KEY. If Table1 contains a
matching KEY, then I want that row from Table1. Only if it isn't in
Table1, then look in Table2 if it is
Will u please send me to this email? thank you
On 04/05/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
On 5/4/07, Cesar Rodas <[EMAIL PROTECTED]> wrote:
> Looks great... and this image is public domain?
Sure. Be free to use it. Also, I have the xcf file. So if anybody
knows how to tweak Gimp,
On 5/4/07, Cesar Rodas <[EMAIL PROTECTED]> wrote:
Looks great... and this image is public domain?
Sure. Be free to use it. Also, I have the xcf file. So if anybody
knows how to tweak Gimp, I'll be pleased to send it.
Cheers
Alberto
On 04/05/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
>
>
Looks great... and this image is public domain?
On 04/05/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
> > If nobody have one, I'll try to put one up tomorrow :)
Ok, I had some time today. What do you think of the one shown in:
http://dicionario-aberto.net/bin/dic.pl
Cheers
Alberto
--
Apologies if I should have found an answer to this by searching or
being less naive about SQL!
I'm using 3.3.17 built by me with gcc (3.4.3? can't check just now as
machine is at work - it's the one Sun ship anyway) on a SPARC Solaris
10u3 box.
I don't have any significant experience of
time gcc -m32 -O2 -I. -I../sqliteSrc/sqlite-3.3.17/src -DNDEBUG -DTHREADSAFE=1
-DSQLITE_THREAD_OVERRIDE_LOCK=-1 -DSQLITE_OMIT_LOAD_EXTENSION=1 -c sqlite3.c
-fPIC -DPIC -o .libs/sqlite3.o
real0m20.266s
user0m19.773s
sys 0m0.444s
time gcc -m32 -O2 -I.
> If nobody have one, I'll try to put one up tomorrow :)
Ok, I had some time today. What do you think of the one shown in:
http://dicionario-aberto.net/bin/dic.pl
Cheers
Alberto
--
Alberto Simões
-
To unsubscribe,
"C.Peachment" <[EMAIL PROTECTED]> wrote:
> With the suggestion that the problem was a compiler bug
> in PellesC for Windows, I posted a message on their forum.
> One response suggested a couple of configuration changes
> and also said to wait a while because it took a long time to
> compile.
>
Ulrich Telle wrote:
drh wrote:
I'm still having trouble trying to understand how managing
60 separate code files is perceived to be easier than managing
just 2 files (sqlite3.c and sqlite3.h). It seems to me that
the management problem gets much easier the fewer files there
are to manage.
With the suggestion that the problem was a compiler bug
in PellesC for Windows, I posted a message on their forum.
One response suggested a couple of configuration changes
and also said to wait a while because it took a long time to
compile.
So, I let the compiler continue after it had reported a
OK We will wait for it ;)... but i think you should put into your website
and send here the link, because i think (i am not sure) you could not send
attach email here.
On 04/05/07, Alberto Simões <[EMAIL PROTECTED]> wrote:
On 5/4/07, Griggs, Donald <[EMAIL PROTECTED]> wrote:
> Regarding: Is
On 5/4/07, Griggs, Donald <[EMAIL PROTECTED]> wrote:
Regarding: Is there any image/logo with "powered by SQLite"? You know,
people with web services (not webservices) that rely on SQLite might
like to say that to others :)
Well, Alberto, there *was* one, but it was so very tiny, lightweight,
On 5/4/07, Ken <[EMAIL PROTECTED]> wrote:
100% concur with Dennis.
Thanks again for a great product!
+1
I couldn't said it better, maybe even in my native language ;-)
Best regards,
~Nuno Lucas
Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote:
>
> Can somebody please
Regarding: Is there any image/logo with "powered by SQLite"? You know,
people with web services (not webservices) that rely on SQLite might
like to say that to others :)
Well, Alberto, there *was* one, but it was so very tiny, lightweight,
and efficient that few could actually see it.
;-)
Hi
Is there any image/logo with "powered by SQLite"? You know, people
with web services (not webservices) that rely on SQLite might like to
say that to others :)
Well, I would.
Cheers
Alberto
--
Alberto Simões
-
To
100% concur with Dennis.
Thanks again for a great product!
Dennis Cote <[EMAIL PROTECTED]> wrote: [EMAIL PROTECTED] wrote:
>
> Can somebody please explain to my how 2 files is less manageable
> than 60?
>
>
>
Richard,
I think part of the problem is simple inertia. Some people have
[EMAIL PROTECTED] wrote:
"Shane Harrelson" <[EMAIL PROTECTED]> wrote:
This allowed me to get the benefits of the single source file (more compiler
optimizations, etc.) while keeping the manageability, etc. of the separate
source file.
I'm still having trouble trying to understand how
[EMAIL PROTECTED] wrote:
Can somebody please explain to my how 2 files is less manageable
than 60?
Richard,
I think part of the problem is simple inertia. Some people have
developed a methodology for using the sqlite source files based on the
previous arrangement. They may have
drh wrote:
> I'm still having trouble trying to understand how managing
> 60 separate code files is perceived to be easier than managing
> just 2 files (sqlite3.c and sqlite3.h). It seems to me that
> the management problem gets much easier the fewer files there
> are to manage.
In the case
On Fri, May 04, 2007 at 14:04:24 +, [EMAIL PROTECTED] wrote:
> Can somebody please explain to my how 2 files is less manageable
> than 60?
To my mind, the only missing feature is CPP #line directives, like
#line 1 "alter.c"
when contents of alter.c begins. If they are in place,
On 5/3/07, Arjen Markus <[EMAIL PROTECTED]> wrote:
Lloyd wrote:
That is a very large number of files! I know FAT32 can not handle files
larger than
2 GB, and I imagine there is limit on the number of files as well. Try
creating
some subdirectories and moving the files there. The problem is most
27 matches
Mail list logo