Platforms to show: All Mac Windows Linux Cross-Platform
The module InternalSQLiteLibraryMBS
module InternalSQLiteLibraryMBSType | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
module | SQL | MBS SQL Plugin | 15.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
This is a SQLite3 library built into a plugin, so you can decide with use of MBS SQL Plugin to use this plugin instead of providing your own external copy of SQLite shared library.
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
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.
- method CompileOption(index as Integer) as String
- method CompileOptionUsed(optionName as String) as Boolean
- method DumpToFile(SqliteDBConectionHandle as Ptr, File as FolderItem, TableName as string = "", PreserveRowid as Boolean = false, Newlines as Boolean = false, DumpDataOnly as Boolean = false, DumpNoSys as Boolean = false)
- method DumpToString(SqliteDBConectionHandle as Ptr, byref Data as String, MaximumSize as Integer = 10000000, TableName as string = "", PreserveRowid as Boolean = false, Newlines as Boolean = false, DumpDataOnly as Boolean = false, DumpNoSys as Boolean = false)
- method DumpToStrings(SqliteDBConectionHandle as Ptr, SchemaName as String = "", TableName as string = "") as String()
- method isKeyword(name as string) as boolean
- method Keywords as String()
- method LoadICU as Boolean
- method SourceID as String
- method Use as boolean
- method Version as String
- method VersionNumber as Integer
- property Base64ExtensionEnabled as Boolean
- property CSVExtensionEnabled as Boolean
- property ICUEnabled as Boolean
- property ICULoaded as Boolean
- property ICUUsed as Boolean
- property MemoryHighwater as Int64
- property MemoryUsed as Int64
- property Path as String
- property UUIDExtensionEnabled as Boolean
Some examples which use this module:
- /SQL/SQL Unit Tests
- /SQL/SQLDatabaseMBS DuckDB
- /SQL/SQLDatabaseMBS SQLite API 2
- /SQL/SQLDatabaseMBS SQLite Blob test
- /SQL/SQLDatabaseMBS SQLite Connect
- /SQL/SQLDatabaseMBS SQLite Connect console
- /SQL/SQLDatabaseMBS SQLite Connect in Memory Database
- /SQL/SQLDatabaseMBS SQLite Create Encrypted
- /SQL/SQLDatabaseMBS SQLite custom function
- /SQL/SQLDatabaseMBS SQLite Encryption Fetch values
- /SQL/SQLDatabaseMBS SQLite ExecuteSQL
- /SQL/SQLDatabaseMBS SQLite ExecuteSQL threaded
- /SQL/SQLDatabaseMBS SQLite ExecuteSQL with Workers
- /SQL/SQLDatabaseMBS SQLite Fetch values
- /SQL/SQLDatabaseMBS SQLite Fetch values threaded
- /SQL/SQLDatabaseMBS SQLite insert record
- /SQL/SQLDatabaseMBS SQLite insert record with transaction
- /SQL/SQLDatabaseMBS SQLite load extension
- /SQL/SQLDatabaseMBS SQLite Prepared Statement
- /SQL/SQLDatabaseMBS SQLite select version
- /SQL/SQLite Backup
- /SQL/SQLite Benchmark vs REALSQLDatabase
- /SQL/SQLite Blob test
- /SQL/SQLite Connect
- /SQL/SQLite Connect in Memory Database
- /SQL/SQLite Display Schema
- /SQL/SQLite Encryption Fetch values
- /SQL/SQLite ExecuteSQL
- /SQL/SQLite ExecuteSQL with Parameters
- /SQL/SQLite Fetch rows bulk
- /SQL/SQLite Fetch values
- /SQL/SQLite Fetch values with Recordset
- /SQL/SQLite Fetch values with RowSet
- /SQL/SQLite Internal Library Compiler Options
- /SQL/SQLite load extension
- /SQL/SQLite Lock Test/SQLite Busy Handler
- /SQL/SQLite select version
- /SQL/SQLite select version with Trace events
- /SQL/SQLite Table Definition
- /SQL/SQLite Unicode test
- /SQL/SQLite Update values
- /SQL/SQLite Version
- /SQL/SQLite with ICU
- /SQL/SQLite Write blob to file
- /SQL/Web app/with SQLConnectionMBS
- /SQL/Web app/with SQLDatabaseMBS
- /SQL/Xojo SQLite custom function
Blog Entries
- Base64 function for SQLite
- MBS Xojo Plugins, version 25.3pr2
- News from the MBS Xojo Plugins Version 24.1
- MonkeyBread Software Releases the MBS Xojo Plugins in version 24.1
- Did you know that you can load extensions in SQLite?
- MonkeyBread Software Releases the MBS Xojo Plugins in version 21.2
- SQLite and ICU Extension for Xojo
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 16.4
- SQLite3 command line tool in Xojo
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 15.2
Xojo Developer Magazine
- 14.1, page 27: The MBS SQL Plugin, An alternative way to connect to databases by Christian Schmitz
- 13.5, page 8: News
Release notes
- Version 25.3
- Improved DumpToStrings method to InternalSQLiteLibraryMBS module.
- Added uuid and base64 extensions for the built-in SQLite library in InternalSQLiteLibraryMBS module.
- Added UUIDExtensionEnabled and Base64ExtensionEnabled properties to InternalSQLiteLibraryMBS module.
- Added CSV extension for the built-in SQLite library in InternalSQLiteLibraryMBS module.
- Added DumpToStrings method to InternalSQLiteLibraryMBS module.
- Version 24.1
- Added Path property to InternalSQLiteLibraryMBS module.
- Updated our Unicode extension for SQLite in InternalSQLiteLibraryMBS class to work in Xojo 2024r1 on Windows.
- Version 22.5
- Fixed a problem in InternalSQLiteLibraryMBS module for new changes64 function.
- Version 22.2
- Added DumpToFile and DumpToString methods for InternalSQLiteLibraryMBS class.
- Version 22.0
- Removed Shell method for InternalSQLiteLibraryMBS class. Please use command line tool instead.
- Version 21.2
- Added code to use ICU libraries for SQLite. See new properties on InternalSQLiteLibraryMBS module.
- Enabled math and geopoly functions for internal SQLite library. see InternalSQLiteLibraryMBS
- Version 19.2
- Deprecated the Shell function on InternalSQLiteLibraryMBS class.
- Version 18.3
- Added MemoryUsed, MemoryHighwater, Keywords and isKeyword to InternalSQLiteLibraryMBS module.
- Improved InternalSQLiteLibraryMBS.Shell function to reset global settings for further calls.
The items on this page are in the following plugins: MBS SQL Plugin.
