StepSqlite

From Wikipedia, the free encyclopedia
Jump to: navigation, search
StepSqlite
Original author(s) Metatranz.com
Stable release alpha
Development status alpha (invite only)
Operating system Cross-platform
Platform cloud
License Proprietary software[1]
Website metatranz.com

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.[2] Consequently, StepSqlite can also be used as a third-party tool to run PL/SQL code on Berkeley DB.[3]

Architecture[edit]

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.

  1. 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.
  2. It is cloud-based: No installations are required to use it. No upgrades are required when new features are introduced.
  3. Major supported features include variable substitution (auto-binding) in SQL, built-in date operators, triggers with procedural code, packages and cursors.

References[edit]

  1. ^ "StepSQLite". metatranz.com. Retrieved 13 Nov 2011. 
  2. ^ "Twitter / Gregory Burd: @humanications We didn't r ...". 
  3. ^ "Official Berkeley DB FAQ". Oracle Corporation. Retrieved March 30, 2010. "Does Berkeley DB support PL/SQL?" 

External links[edit]