[Fwd: Re: SQLite and transactional security]

[Benjamin]

Hello,

Matthew Vanecek wrote:
> What's the status of SQL99 support in SQLite?  Stored procedures (a la
> CREATE FUNCTION) would be really handy...

The main online guide can be found at http://www.sqlite.org/lang.html, 
and as it says on that page the definitive guide can be found in parse.y 
:) http://www.sqlite.org/omitted.html is a list of features explicitly 
not supported at this point in time.

To answer your specific query sqlite is primarily targeted at SQL92. 
There is no support for stored procedures, however there is now basic 
support for triggers.

It's also important to note that sqlite's query optimisation is minimal 
and that may require you to construct queries in specific orders to get 
optimum use of indices.

Benjamin