Components All New MacOS Windows Linux iOS
Examples Mac & Win Server Client Guides Statistic FMM Blog Deprecated Old

SQL.InternalSQLiteLibrary.Activate

Activates the internal SQLite library.

Component Version macOS Windows Linux Server iOS SDK
SQL 5.3 ✅ Yes ✅ Yes ✅ Yes ✅ Yes ✅ Yes
MBS( "SQL.InternalSQLiteLibrary.Activate" )

Parameters

none

Result

Returns OK or error.

Description

Activates the internal SQLite library.
If you use this command, you don't need to provide sqlite3.dll or sqlite3.dylib yourself.

Our internal SQLite library includes the following extensions:

  • JSON1, the extension to provide JSON functions
  • FTS5, the full text search extension in version 5
  • R*Tree index extension
  • SOUNDEX function
  • SQL math functions
  • Geopoly extension
  • ICU extension for unicode handling
  • The RBU Extension
  • SQLite Encryption Extension

You can turn on these SQLite extensions at runtime with MBS Plugin:

  • UUID extension
  • Base64 extension
  • CSV extension

More extensions could be added on request.

Examples

Activate the internal SQLite library if not already activated:

If [MBS( "SQL.InternalSQLiteLibrary.Activated" ) ≠ 1]
    Set Variable [$r; Value:MBS( "SQL.InternalSQLiteLibrary.Activate" )]
End If

Enable all extensions and activate:

Set Variable [$r; Value: MBS( "SQL.InternalSQLiteLibrary.SetBase64ExtensionEnabled"; 1 )]
Set Variable [$r; Value: MBS( "SQL.InternalSQLiteLibrary.SetCSVExtensionEnabled"; 1 )]
Set Variable [$r; Value: MBS( "SQL.InternalSQLiteLibrary.SetICUEnabled"; 1 )]
Set Variable [$r; Value: MBS( "SQL.InternalSQLiteLibrary.SetUUIDExtensionEnabled"; 1 )]
Set Variable [$r; Value: MBS( "SQL.InternalSQLiteLibrary.Activate" ) ]

See also

Release notes

Example Databases

Blog Entries

This function checks for a license.

Created 23th September 2015, last changed 30th June 2025


SQL.InsertRecords - SQL.InternalSQLiteLibrary.Activated