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 |
Example:
// enable our built-in SQLite library, which supports encryption
Call InternalSQLiteLibraryMBS.Use
// where to store?
Dim f As FolderItem = SpecialFolder.Desktop.Child("test.db")
Dim storage_database As New SQLDatabaseMBS ' SQLiteDatabase
storage_database.SQLiteEncryptionKey = "aes256:password" ' <-- password with AES256 as prefix to pick algorithm
storage_database.DatabaseName = "sqlite:"+ f.NativePath
If storage_database.Connect Then
// create table if this is not yet here
storage_database.SQLExecute "Create table if not exists pics(pic_id integer PRIMARY KEY AUTOINCREMENT, name varchar(20), pic blob)"
// done
MsgBox "Ready"
Else
MsgBox storage_database.ErrorMessage
End If
- 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 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 ICUEnabled as Boolean
- property ICULoaded as Boolean
- property ICUUsed as Boolean
- property MemoryHighwater as Int64
- property MemoryUsed as Int64
Some examples which use this module:
- /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 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
Blog Entries
- MBS Xojo Plugins, version 22.2pr1
- News from the MBS Xojo Plugins Version 21.2
- MonkeyBread Software Releases the MBS Xojo Plugins in version 21.2
- SQLite and ICU Extension for Xojo
- Converting Xojo project to use MBS SQL Plugin
- CubeSQL support for MBS Xojo SQL Plugin
- Use JSON functions with SQLite
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 16.4
- MBS Releases the MBS Xojo / Real Studio plug-ins in version 15.2
- SQL Plugin option to include SQLite Library
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
The items on this page are in the following plugins: MBS SQL Plugin.
