SQLite has the ability to load extensions (including new application-defined SQL functions, collating sequences, virtual tables, and VFSes) at run-time. This feature allows the code for extensions to be developed and tested separately from the application and then loaded on an as-needed basis. An SQLite extension is a shared library or DLL and typically coded in C / C++.
ooSQLite provides complete support for loading and using these external extensions. In addition, the object orientated interface includes enhancements to using external extensions, such as automatic registration when any database connection is opened. The classes related to using and working with external extensions are documented in this chapter. Most of the work to use the SQLite database engine is done through the primary ooSQLite classes which are documented in their own Primary ooSQLite Classes .
Support for user defined extensions written in Rexx are also part of ooSQLite. This support is done through the createCollation and createFunction . In the future support for user defined virtual tables is intended to be added to ooSQLite through a createModule method.
The following table lists the classes used to work with user defined external extensions and the classes needed to implement user defined extensions in Rexx code:
| Class | Description |
| The ooSQLCollation Class | Some text. |
| The ooSQLCollationNeeded Class | Some text. |
| The ooSQLExtensions Class | Some text. |
| The ooSQLFunction Class | Some text. |
| The ooSQLLibrary Class | Some text. |
| The ooSQLPackage Class | Some text. |
| The ooSQLResult Class | Some text. This class is used in the implementation of user defined extensions in Rexx |
| The ooSQLValue Class | Some text. This class is used in the implementation of user defined extensions in Rexx |