Re: [sqlite] Embedded Database Functions

2006-12-24 Thread John Stanton
The way I would envisage a PL/SQL type capability existing in Sqlite is by adding the grammar to the existing parser and adding the code generation to the existing code generator. The existing VDBE engine might need to be slightly extended. Apparently a version of Sqlite which uses stored VDB

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread Eduardo Morras
At 17:00 24/12/2006, you wrote: On Sun, Dec 24, 2006 at 09:35:01AM -0600, John Stanton wrote: > >There is even a starting grammar for you: > > http://www.antlr.org/grammar/1107752678378/PLSQLGrammar.g > A compiler for a subset of PL/SQL would not be too arduous a project, If what you want is

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread John Stanton
Andrew Piskorski wrote: On Sun, Dec 24, 2006 at 09:35:01AM -0600, John Stanton wrote: There is even a starting grammar for you: http://www.antlr.org/grammar/1107752678378/PLSQLGrammar.g A compiler for a subset of PL/SQL would not be too arduous a project, If what you want is something l

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread Joe Wilson
--- Andrew Piskorski <[EMAIL PROTECTED]> wrote: > If what you want is something like PL/SQL, it might be both easier and > better to retarget PostgreSQL's PL/pgSQL for SQLite opcodes, rather > than starting from scratch with your own Oracle PL/SQL style language. > (And PL/pgSQL's BSD license is co

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread Andrew Piskorski
On Sun, Dec 24, 2006 at 09:35:01AM -0600, John Stanton wrote: > >There is even a starting grammar for you: > > http://www.antlr.org/grammar/1107752678378/PLSQLGrammar.g > A compiler for a subset of PL/SQL would not be too arduous a project, If what you want is something like PL/SQL, it might b

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread John Stanton
A compiler for a subset of PL/SQL would not be too arduous a project, and a code generator into VDBE would, as you suggest, give an insight into what extra opcodes would be desirable to produce dense PL/SQ. Obviously the SQL component and optimization is already handled. I can see that the maj

Re: [sqlite] Embedded Database Functions

2006-12-24 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Eduardo Morras wrote: | but don't know much about the VDBE code. The opcodes and operation (stacks etc) are all well documented: ~ http://www.sqlite.org/opcode.html All the necessary opcodes are already present in that you can do checks (ge, eq, le

Re: [sqlite] Embedded Database Functions

2006-12-23 Thread Eduardo Morras
At 03:41 22/12/2006, you wrote: There has been discussion about extending Sqlite to have more functions, but the risk is creating Sqlite-Bloat and losing the most endearing feature of the product, its light weight and simplicity. Here is an interesting and thought provoking discussion on the

[sqlite] Embedded Database Functions

2006-12-21 Thread John Stanton
There has been discussion about extending Sqlite to have more functions, but the risk is creating Sqlite-Bloat and losing the most endearing feature of the product, its light weight and simplicity. Here is an interesting and thought provoking discussion on the general subject. A good case is