logo background
   
home about products development tools news downloads sitemap contact us  

 

RebGUI
RebDB
SQLite Driver
faq
iphone

 

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.

Important

As of REBOL 2.7.6 library access is free. Click here for details.

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.




Documentation
Driver Guide
5-Nov-2006
User Guide
5-Nov-2006
SQL As Understood By SQLite
23-Sep-2006

Snapshots
Flat refinement
Format refinement
Describe

Discussion
SQLite Group


 
© 2009 Dobeash Software Pty Ltd. Site designed and created by Jeni-C and Iming Chan.