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
AFS (the Andrew FileSystem) supports whole-file locks but not
byte-range locks. Unfortunately, it has a problematic "feature"
whereby it will claim to grant requests for byte-range locks, but not
actually perform any locking activity. This unfortunately can easily
lead to corruption for
[EMAIL PROTECTED] uttered:
It takes at least two complete rotations of the disk platter
to do an atomic and durable commit. On a 7200 RPM disk, that
means 60 transactions per second is your speed of light.
Your question boils down to this: Can you speed up transactions
by dropping the
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
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
VACUUM ought to work on a :memory: database, I would think.
Give it a try and see what happens.
--- PY <[EMAIL PROTECTED]> wrote:
> Do you have any idea for my question 2??
> > 2. How to release the unused page in the memory database? just like the
> > vacuum in the file database.
--- 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
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
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
Hi,
This works as what I want :
select date('2006-12-05')
2006-12-05
But,
select date('2006-12-5')
null
Please help me , how to handle the single digit month or day ?
Thank you.
--
wwg
-
To unsubscribe, send email
Thanks. I will try it.
Do you have any idea for my question 2??
2. How to release the unused page in the memory database? just like the
vacuum in the file database.
Thanks.
On 12/24/06, Joe Wilson <[EMAIL PROTECTED]> wrote:
This mailing list thread may be helpful:
-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,
12 matches
Mail list logo
