A self-contained, embeddable, zero-configuration SQL database engine
The REBOL SQLite database driver uses the library access features of REBOL 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".
The SQLite driver provides a simplified wrapper to the SQLite library. Its features include:
- Works out of the box
do %sqlite.rto 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.
Many aspects of the driver's behaviour can be changed/controlled by specifying various refinements when you "connect" to a SQLite database.