Monkeybread Software - The MBS Xojo SQL Plugin

The MBS Xojo SQL Plugin

All plugins Documentation Download Mailing list
Order SQL Plugin license Plugin Content Release Notes

Access SQL Databases

This plugin is included in our plugin archive:

Download the MBS Xojo Plugins

macOS

MBS-Xojo-Plugins250.dmg
( 1.0G )

Windows

MBS-Xojo-Plugins250.zip
( 1.0G )

Linux

MBS-Xojo-Plugins250.zip
( 1.0G )

Documentation

Installation

Presentations Prerelease

Individual files Libraries

All archives contain the same content.

MBS SQL Plugin.pdf

1.4M

You can order a license here: Order

This plugin part is not included if you order a Complete set license. You can use it independend of all the other plugins.

Our MBS Xojo SQL Plugin is an alternative database interface to Xojo. It can be used either with the database class (via SQLDatabaseMBS class) or with our own SQLConnectionMBS class which gives more options.

Connect to 14 different database systems directly without the need for ODBC.
- Access databases where no plugin comes with Xojo: DB2, Sybase, SQL Anywhere, Informix, DuckDB, Firebird and Interbase.
- Connect to SQL databases in multithreaded mode for better GUI responsibility.
- Connect to MongoDB via the mysql interface of MongoDB Connector for BI or check out our MongoDB plugin classes.
- Use MySQL with Enterprise, Community or embedded libraries.
- Connect to Microsoft SQL Server without installing native client using OLEDB option.
- Use your own copy of the native connector library.
- Use SQLCipher library with Xojo, a version of SQLite with built in encryption.
- Built-in SQLite library with SQLite Encryption Extension. Compatible to Xojo's encrypted databases and offering AES 128, 256 and RC4 encryption.
- Built-in CubeSQL client library with SSL and AES support.
Prepared Statements improved
- Bind parameters to prepared statements by name instead of index.
- Binding type is optional on prepared statements.
- Bind using variants or dictionary with values.
- Inspect bound values in debugger.
Improved performance
- Depending on what you do with your database our plugins can be magnitudes faster!
- Transfer rows in bulk mode to reduce network traffic and increase speed.
- Perform SQL queries and SQL commands in multithreaded mode for better GUI responsibility.
- Handle blob values with more than one GB of size by streaming in chunks.
Integrated for Xojo
- Works with Xojo with iOS, Web, Desktop and Console.
- Can provide RecordSets for use with Xojo reports engine.
Extra features
- Use SpatiaLite library with Xojo.
- Use API for online Backups in SQLite.
- Supports moving forward/backword, first and last in result sets.
- We ping the servers regularly to keep connection alive.

This plugin uses the SQLAPI++ Library and if you use this plugin, read also their documentation for the details on connecting to database servers.

Xojo Developer Magazine

You can read an article about the MBS SQL Plugin in the Xojo Developer Magazine, issue 14.1. See website.

Xojo Lite

If you have Xojo Lite, you can only use SQLConnectionMBS and SQLCommandMBS classes. You can't touch anything with DatabaseRow, RowSet or Database class.

You need a Desktop, Web iOS, Pro or Pro Plus license for Xojo to get database access. Then you can use the Database, DatabaseRow and RowSet classes with our plugin, e.g. using SQLDatabaseMBS class. Of course you can also use SQLConnectionMBS or SQLCommandMBS classes if you prefer these.

SQL Interfaces

The MBS Xojo SQL Plugin is a Xojo plugin for accessing multiple SQL databases (CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase). It uses native APIs of target DBMS so applications developed with this plugin run swiftly and efficiently. The product also provides a low-level interface that allows developers to access database-specific features. By encapsulating a vendor's API, the plugin acts as middleware and delivers database portability. See details on supporting SQL database servers on different platforms:

Server	Windows	MacOS and Linux
Oracle Database Server	Supported (OCI)	Supported (OCI)
Microsoft SQL Server	Supported (DB-Library, OLE DB)	FreeTDS ODBC driver should be used
Sybase	Supported (Open Client, ASE & ASA)	Supported (Open Client, ASE & ASA)
DB2	Supported (DB2 CLI)	Supported (DB2 CLI)
Informix	Supported (Informix CLI)	Supported (Informix CLI)
Firebird	Supported	Supported
InterBase	Supported	Supported
Centura (formerly Gupta) SQLBase	Supported (CAPI)	Supported (CAPI)
MySQL / MariaDB	Supported (MySQL C API)	Supported (MySQL C API)
PostgreSQL	Supported (libpq)	Supported (libpq)
ODBC	Supported	Supported (iODBC, see www.iodbc.org)
SQLite	Supported	Supported
SQLite Encrypted	Supported	Supported
SQL Anywhere	Supported	Supported
CubeSQL	Supported	Supported

Connect to Microsoft Access, Claris FileMaker Server (or Pro), Microsoft Visual FoxPro and others via ODBC. Connect to MongoDB via the mysql interface of MongoDB Connector for BI or check out our MongoDB plugin classes.

We have two interfaces in this plugin. SQLConnectionMBS is the native one and gives more flexibility. There is also SQLDatabaseMBS for easier porting of existing projects to our SQL Plugin. As SQLDatabaseMBS class is a subclass of the Database class, it may require a Xojo Database Server license to use (this depends on the exact rules Xojo, Inc. sets).

As with Xojo, the SQLConnectionMBS class works without a Database Server license. For the SQLDatabaseMBS class you need the Database Server license as it is a subclass for the database class.

Works with MacOS, iOS, Windows and Linux for Desktop, Mobile, Console and Web.

You do not need to compile or provide your own SQLAPI library as the plugin contains SQLAPI. You may need database access libraries from the database vendors.

For your information:
The MBS Xojo SQL Plugin license includes a cross-platform unlimited license of SQLAPI++ which costs 299 USD for a C/C++ developer. Of course this bundled license works only inside the plugin. If you want to develop with SQLAPI in C/C++, please order a separate license from SQLAPI.com website.

For using JDBC (Java Database Connection) for connecting to database using a java driver, please use our MBS Xojo Java Plugin With the JavaDatabaseMBS class.

Release notes

See also our SQLite Extension, which adds extra commands for use in SQLite databases.