SQLDatabase sample

We recently got an example project for SQLite with MBS Xojo SQL Plugin and let's explain a bit on how it works.

First you decide which database client library to use. For SQLite this can be a sqlite3.dll/dylib/so library to load or you use the built-in library inside our plugin. The one in InternalSQLiteLibraryMBS module includes various extensions and encryption support, so we can activate it with the Use method.

Create a database connection object with SQLDatabaseMBS class. That is our MBS class subclasses from Database, so it supports the database interface in Xojo. But alternatively we also have the SQLConnectionMBS class, which implements the our own interface and works with Xojo Lite. Which side you use doesn't matter much as both can do about the same things.

MBS Xojo Developer Conference Update

Ten months until our MBS Xojo conference in Andernach.

First registrations are coming in and we have already the first 10 attendees from 5 countries: 🇩🇪, 🇳🇱, 🇵🇱, 🇬🇧 and 🇨🇭.

Over the summer, we are looking for interesting presentations, so if you like to become a speaker or maybe a sponsor, please contact us.

MBS Xojo Plugins, version 25.3pr4

• Updated mongo-c-driver to version 1.30.5.
• Updated DynaPDF to version 4.0.102.290.
• Updated Unikey Plugin to newer version.
• Added Linux 64-bit ARM support for UnikeyMBS class.

You can subscribe to our Xojo mailing list to get notified for new pre-release and release versions.

Rosetta timeline

Apple announced some changes for their Intel support. Version 26 is the last one to run on Macs with Intel CPUs. And for at least version 27, the Rosetta translation layer is supported. After that it may continue to run older software like games, which may never get recompiled.

MBS Xojo QuickLook Extension

For years we had a QuickLook plugin to provide a preview into Xojo projects and show the version number. I don't know about you, but I have current 12 different Xojo versions installed.

Our extension shows the version number of Xojo projects and if space is available, we show the type (Binary, Text or XML) below the number. (more)

MBS Xojo Plugins, version 25.3pr3

• Updated DynaPDF to version 4.0.102.288.
• Added SetActiveSigField function for DynaPDFMBS class.
• Added isTahoe method to SystemInformationMBS module.
• Improved DumpToStrings method to InternalSQLiteLibraryMBS module.
• Updated SQLite to version 3.50.1.
• Added DataTypeInt8 constant for MLMultiArrayMBS class.
• Updated CURL library to version 8.14.1.
• Added OptionSSLSignatureAlgorithms property to CURLSMBS class.
• Added kWebSocketNoAutoPong constant to CURLSMBS class.
• Improved loading LDAP library on Linux to work on Ubuntu 22 and 24.
• Added CGDirectDisplayID property to NSScreenMBS class.
• Added neutralValue property to NSSliderMBS class.
• Added prefersCompactControlSizeMetrics to NSViewMBS class.
• Added ControlSizeExtraLarge constant to NSControlMBS class.
• Added backgroundTintColor and style properties to NSToolbarItemMBS class.
• Added NSWritingToolsResultPresentationIntent constant to NSTextViewMBS class.
• Added NSEventTypeMouseCancelled constant to NSEventMBS class.
• Added placeholderStrings and placeholderAttributedStrings methods to NSTextFieldMBS class.
• Added constants to NSButtonCellMBS class.

You can subscribe to our Xojo mailing list to get notified for new pre-release and release versions.

Base64 function for SQLite

For the MBS Xojo SQL Plugin 25.5, we add a few extensions and include UUID, Base64 and CSV. The base64 extension allows us to make an base64 encoding in a SQL query as the extension adds the base64() function. It converts BLOB to base64 encoded text or back.

To use it in your Xojo application, you need to set the Base64ExtensionEnabled property in the InternalSQLiteLibraryMBS module to true. Then we enable the internal library with the Use method.

SQLite UUID extension

For the MBS Xojo SQL Plugin 25.5, we add a few extensions and include UUID, Base64 and CSV. The uuid extension allows us to make an uuid in a SQL query as the extension adds these functions:

Let's use this in an example project:

MBS Xojo Plugins, version 25.3pr2

• Added uuid and base64 extensions for the built-in SQLite library in InternalSQLiteLibraryMBS module.
• Added UUIDExtensionEnabled and Base64ExtensionEnabled properties to InternalSQLiteLibraryMBS module.
• Fixed PatchFromDiff function in JSONMBS class to do the copy key feature again, broken with jsoncons update in version 25.1.
• Fixed TidyDocumentMBS class properties to not crash. Removed a few old properties removed in tidy library.
• Added CSV extension for the built-in SQLite library in InternalSQLiteLibraryMBS module.
• Added DumpToStrings method to InternalSQLiteLibraryMBS module.
• Added pitch property to VNFaceObservationMBS class.

You can subscribe to our Xojo mailing list to get notified for new pre-release and release versions.

MBS Xojo Plugins, version 25.3pr1

• Added BeginMarkedContent and EndMarkedContent events to DynaPDFParseInterfaceMBS class.
• Added DispatchDataMBS or DispatchIOMBS classes.
• Added LoadedClasses method to JavaVMMBS class.
• Added Methods and Fields methods to JavaClassMBS class.
• Added more properties to AVCaptureStillImageOutputMBS class.
• Added more properties to VNDetectBarcodesRequestMBS and VNDetectedObjectObservationMBS classes.
• Added new methods to NSPasteboardMBS and NSPasteboardItemMBS classes to handle access behavior.
• Added objectForKey and removeObjectForKey methods to NSPrintInfoMBS class.
• Added Poll for the WindowsProcessMBS class.
• Added ProviderNames function to OpenSSLMBS module.
• Added RawResult to DeclareFunctionMBS class.
• Added WhisperMBS module for using Whisper library in Xojo for audio to text conversion.
• Added WindowDisplayAffinityMBS property to window class.
• Changed handle properties in AUPlayerMBS class to be read only.
• Changed properties for NSPrinterMBS class to be debugger visible.
• Changed VNDetectBarcodesRequestMBS to detect OS version and set newest revision automatically.
• Fixed DrawRoundRect and FillRoundRect in PageGraphics for DynaPDFMBS class to reduce the arc to make it more look like Xojo's drawing.
• Improved DynaPDF printing to keep object reference longer in case dialog shows.
• Improved ValidationMBS to look for en1, if en0 is missing as a network interface.
• Updated DynaPDF to version 4.0.101.287.
• Updated Saxon library to version 12.7. Download
• Updated SQLAPI to version 5.3.7.
• Updated to Xcode 16.4.

You can subscribe to our Xojo mailing list to get notified for new pre-release and release versions.