Introduction to Recital
Contents
- 1 Introduction to Recital
- 1.1 An Overview of Recital
- 1.2 Powerful Scripting Language
- 1.3 Integrated Database with Industry Standard SQL and Navigational Data Access
- 1.4 Develop and Deploy Desktop and Web Database Applications
- 1.5 Fault Tolerant, High Availability, Business Continuity Database Solution
- 1.6 Bulletproof Security with DES3 Encryption
- 1.7 Database Timelines with Chronological Data Versioning
- 1.8 How does Recital compare to PHP, Perl and Python Scripting Languages?
- 1.9 How does Recital compare to Oracle, MySQL and SQL Server?
- 1.10 Summary
Introduction to Recital
An Overview of Recital
Recital is a dynamic programming language with an integrated high performance embedded database particularly well suited for the development and deployment of high transaction throughput applications.
The Recital database engine is not a standalone process with which the application program communicates. Instead, the Recital database is an integral part of any applications developed in Recital.
Recital implements most of the SQL-99 standard for SQL, but also provides lower level navigational data access for performing high transaction throughput. It is the choice of the application developer whether to use SQL, navigational data access, or a combination of both depending upon the type of application being developed.
The Recital database engine, although operating as an embedded database in the user process, multiple users and other background processes may access the same data concurrently. Read accesses are satisfied in parallel. Recital uses automatic record level locking when performing database updates. This provides for a high degree of database concurrency and superior application performance and differentiates the Recital database from other embeddable databases such as sqlite that locks the entire database file during writing.
Key features of the Recital scripting language include:
- High performance database application scripting language
- Modern object-oriented language features
- Easy to learn, easy to use
- Fast, just-in-time compiled
- Develop desktop or web applications
- Cross-platform support
- Extensive built-in functions
- Superb built-in SQL command integration
- Navigational data access for the most demanding applications
Key features of the Recital database include:
- A broad subset of ANSI SQL 99, as well as extensions
- Cross-platform support
- Stored procedures
- Triggers
- Cursors
- Updatable Views
- System Tables
- Query caching
- Sub-SELECTs (i.e. nested SELECTs)
- Embedded database library
- Database timelines providing data undo functionality
- Fault tolerant clustering support
- Replication support (i.e. Master-Master Replication & Master-Slave Replication)
- Hot backup
