Proposed SQLite Procedural Language

One of the things SQLite has been lacking is support for stored procedures, and an associated procedural language. This exploratory project defines such a procedural language ("SQLite/PL") and adds support for stored procedures.

The current work is based on SQLite version two and under development. Functionality and syntax may still change without notice. Once the key concepts have stabilised, the code will be ported to the SQLite 3 branch and optimised.

Note that there is no promise that this work will be incorporated into the "official" SQLite code base. It may well remain a diff, available for the interested user.

Documentation

Exec statement

Create/Drop Procedure

PL Blocks

PL Statements

Source

Source Tree (SQLite 2 based)

Key file: "proc.c"

Test script