The module InternalSQLiteLibraryMBS

Online Documentation   -   Statistics   -   FAQ   -   Plugin Parts (All, Dependencies)   -   Class hierarchy

New in Version 22.2 22.3 22.4 22.5 23.0 23.1 23.2 23.3 23.4 23.5 24.0 24.1

The list of the   topics,   classes,   interfaces,   controls,   modules,   global methods by category,   global methods by name,   screenshots,   licenses   and   examples.

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
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

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.

Some examples which use this module:

Blog Entries

Xojo Developer Magazine

Release notes


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


💬 Ask a question or report a problem