Platforms to show: All Mac Windows Linux Cross-Platform

The module InternalSQLiteLibraryMBS

module InternalSQLiteLibraryMBS
Type Topic Plugin Version macOS Windows Linux iOS Targets
module SQL MBS SQL Plugin 15.2 ✅ Yes ✅ Yes ✅ Yes ✅ Yes All
Function: The module for our internal SQLite3 engine.
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
Notes: 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.
  • 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:

Blog Entries

Xojo Developer Magazine


The items on this page are in the following plugins: MBS SQL Plugin.

Feedback: Report problem or ask question.

The biggest plugin in space...


Start Chat