[sqlite] Lemon Parser - Modular & Extensible ?

Hello: Is lemon parser modular and extensible? Thanks Uma Asif Lodhi <[EMAIL PROTECTED]> wrote: Hi Everybody, I have just joined this mailing list as Sqlite looks like a good software solution to my needs. What I need right now is RE-assurance of "crash-recovery" that is

Re: [sqlite] Optimization of equality comparison when NULL involved

> select tableA.path, tableA.value from tableA,tableB where > tableA.path=tableB.path and (tableA.value=tableB.value or > (tableA.value IS NULL AND tableB.value IS NULL)); > > It's possible that won't use an index, either, due to the OR, in which > case you could try a union between a select with

Re: [sqlite] Trigger update of multiple columns

Hi John, Thanks for your reply. You would have a better database if you normalize it and not do what you propose. Meaning what, exactly? Obviously, I've only given rough indications as to my data source, such as: the huge Products table (which is actually a UNION ALL of various

Re: [sqlite] How SQLite may work on AVR or similar mcu?

Dne pátek 15 červen 2007 13:57 Eduardo Morras napsal(a): > At 14:18 13/06/2007, you wrote: > >I do not need it actually, but i am so inquisitive. > > > >I have heard that sqlite has been ported to AVR too. > >How may be solved the main storage solved on it? > >So for example, i have system with

Re: [sqlite] Trigger update of multiple columns

Hi, I tried to update a list of columns: UPDATE t SET (c1, c2, c3) = (SELECT c1, c2, c3) FROM t2 WHERE .. but this syntax is not accepted as you probably already know. I may promote [INSERT OR] REPLACE then. It is syntactically described in the SQLite documentation but for the semantics you

Re: [sqlite] Recovery After Crash

Hi Kees, Thanks for replying. On 6/17/07, Kees Nuyt <[EMAIL PROTECTED]> wrote: >... thankful if you experts would give me an "accurate" and fair >picture of the crash-recovery aspects of SQLite - without any hype. I'm not sure if you would qualify this as hype, but sqlite is used in many

Re: [sqlite] Recovery After Crash

Hi Asif, On Sun, 17 Jun 2007 12:59:21 +0500, you wrote: >Hi Everybody, > >I have just joined this mailing list as Sqlite looks like a good >software solution to my needs. What I need right now is RE-assurance >of "crash-recovery" that is mentioned on your front page. So, I would >be thankful if

[sqlite] Trigger update of multiple columns

Hi All, I have a pretty standard sales tracking database consisting of tables: Products - Each row is a product available for sale. Includes fields: Code, Buy, Sell, Description Sales - Each row is a sale made to a customer. Includes fields: Ref,

[sqlite] Recovery After Crash

Hi Everybody, I have just joined this mailing list as Sqlite looks like a good software solution to my needs. What I need right now is RE-assurance of "crash-recovery" that is mentioned on your front page. So, I would be thankful if you experts would give me an "accurate" and fair picture of the