SQLite Driver

A self-contained, embeddable, zero-configuration SQL database engine

The REBOL/Pro SQLite database driver uses the library access features of REBOL/Pro to provide native REBOL access to SQLite databases.

What is SQLite?

For detailed information on SQLite, visit their home page here. What’s attractive from a REBOL perspective is:

• Cross platform
It is written entirely in C, with precompiled binaries available for Windows, Linux and Mac OS X.
• One library
The “database engine” is a single, small, drop-in file (DLL on Windows, .so for others) requiring no special installation or configuration.
• Public Domain
The source and binaries are freely available for both commercial and non-commercial use with no restrictions whatsoever.
• Works well with REBOL
Its simple and efficient design make it a natural fit for REBOL file-based database storage and access.
• Fast and powerful
It provides a fast, full-featured, multi-user RDBMS solution that “works out of the box”.

Features

The SQLite driver provides a simplified wrapper to the SQLite library. Its features include:

• Works out of the box
Just add do %sqlite.r to your script and you are ready to go.
• Native REBOL storage
Your data is stored and accessed as REBOL values which means that you have the full range of REBOL data-types at your fingertips!
• Plays well
The half-dozen functions that drive the database behave like any other REBOL function, accepting and returning REBOL values as you would expect.
• Lock detection
The driver detects locks and initiates retries on your behalf.
• Configurable
Many aspects of the driver’s behaviour can be changed/controlled by specifying various refinements when you “connect” to a SQLite database.