Re: [sqlite] C precompiler to bytecode

2006-08-09 Thread drh
Christian Smith <[EMAIL PROTECTED]> wrote: > > > Run time compilation is not that expensive if the generated vm is cached. > Just have a per-connection hash, use the SQL as the hash key, and the > resulltingvm as the value. Upon first use, the SQL will not be in the > hash, and will be compile

Re: [sqlite] C precompiler to bytecode

2006-08-09 Thread John Stanton
Daniel's concept is that of Embedded SQL, a marriage not quite made in heaven probably because of the clumsiness in integrating the database schema and the data definitions of legacy languages. At one time we built a byte-coded implementation of a legacy language which did exactly as Daniel pr

Re: [sqlite] C precompiler to bytecode

2006-08-09 Thread Trevor Talbot
On 8/8/06, Nuno Lucas <[EMAIL PROTECTED]> wrote: On 8/8/06, Daniel Önnerby <[EMAIL PROTECTED]> wrote: > I'm just a bit curios if it would be possible to make like a C > precompiler or a macro of some kind that compiles/interpret the > SQL-statements to bytecode just like the sqlite_prepare does

Re: [sqlite] C precompiler to bytecode

2006-08-09 Thread Christian Smith
Daniel Önnerby uttered: Hi everyone! I'm just a bit curios if it would be possible to make like a C precompiler or a macro of some kind that compiles/interpret the SQL-statements to bytecode just like the sqlite_prepare does but does this when compiling/precompiling your application instead

Re: [sqlite] C precompiler to bytecode

2006-08-08 Thread Joe Wilson
--- Bill KING <[EMAIL PROTECTED]> wrote: > Daniel Önnerby wrote: > > Hi everyone! > > > > I'm just a bit curios if it would be possible to make like a C > > precompiler or a macro of some kind that compiles/interpret the > > SQL-statements to bytecode just like the sqlite_prepare does but does > >

Re: [sqlite] C precompiler to bytecode

2006-08-08 Thread Bill KING
Daniel Önnerby wrote: > Hi everyone! > > I'm just a bit curios if it would be possible to make like a C > precompiler or a macro of some kind that compiles/interpret the > SQL-statements to bytecode just like the sqlite_prepare does but does > this when compiling/precompiling your application inste

Re: [sqlite] C precompiler to bytecode

2006-08-08 Thread Nuno Lucas
On 8/8/06, Daniel Önnerby <[EMAIL PROTECTED]> wrote: I'm just a bit curios if it would be possible to make like a C precompiler or a macro of some kind that compiles/interpret the SQL-statements to bytecode just like the sqlite_prepare does but does this when compiling/precompiling your applicati

Re: [sqlite] C precompiler to bytecode

2006-08-08 Thread Cesar David Rodas Maldonado
That's a very good idea!, and I would like to help for do that On 8/8/06, Daniel Önnerby <[EMAIL PROTECTED]> wrote: Hi everyone! I'm just a bit curios if it would be possible to make like a C precompiler or a macro of some kind that compiles/interpret the SQL-statements to bytecode just like t

[sqlite] C precompiler to bytecode

2006-08-08 Thread Daniel Önnerby
Hi everyone! I'm just a bit curios if it would be possible to make like a C precompiler or a macro of some kind that compiles/interpret the SQL-statements to bytecode just like the sqlite_prepare does but does this when compiling/precompiling your application instead of at runtime. Since most