|
|
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.
|
 |
|
|