A full working sample that utilizes the SQLite® database using BlackBerry WebWorks applications.
Please click on the attachment below to download the sample code.
Update : Gears no longer supported.
As of BlackBerry 6, the Gears Web APIs have been deprecated in place of strong support for HTML5 storage API.
For BlackBerry device software 6 and higher, developers should store data for offline use using HTML5 local storage, or Web DB.