||This article appears to be written like an advertisement. (November 2011)|
|Development status||alpha (invite only)|
StepSqlite is a multi-target PL/SQL compiler for the popular small database SQLite which supports a subset of Oracle PL/SQL syntax. Oracle's Berkeley DB 11g R2 release added support for SQL based on the popular SQLite API by including a version of SQLite in Berkeley DB. Consequently, StepSqlite can also be used as a third-party tool to run PL/SQL code on Berkeley DB.
At the core of StepSqlite is a compiler with front-end (lexer, parser and tree-parser) built using ANTLR and back-end built using StringTemplate. The back-end generates code in a high-level language like C++ or Java which is then compiled to machine code using the respective high-level language compiler. The entire compilation process is implemented 'in-the-cloud' and presented to user as a simple web-interface.
- Multi-target: It can be used to compile the same database interface written in PL/SQL for use on several target operating systems, architectures and language APIs. Currently it supports Linux and iPhone on x86 and ARM using Sqlite native C++ API.
- It is cloud-based: No installations are required to use it. No upgrades are required when new features are introduced.
- Major supported features include variable substitution (auto-binding) in SQL, built-in date operators, triggers with procedural code, packages and cursors.
- "StepSQLite". metatranz.com. Retrieved 13 Nov 2011.
- "Twitter / Gregory Burd: @humanications We didn't r ...".
- "Official Berkeley DB FAQ". Oracle Corporation. Retrieved March 30, 2010. "Does Berkeley DB support PL/SQL?"