The MBS Xojo SQL Plugin
Access SQL Databases
|MBS SQL Plugin.pdf||1.4M|
|MBS SQL Plugin.zip||39M|
|MBS SQL Plugin.dmg||40M|
You can order a license here: Order
This plugin part is not included if you buy 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.
- Bind parameters to prepared statements by name instead of index.
- Binding type is optional on prepared statements.
- Connect to SQL databases in multithreaded mode for better GUI responsibility.
- Depending on what you do with your database our plugins can be magnitudes faster!
- Handle blob values with more than one GB of size.
- Read and write to blob field values in small blocks.
- Access databases where no plugin comes with Xojo: DB2, Sybase, SQL Anywhere, Informix and Interbase.
- Use MySQL with Enterprise, Community or embedded libraries.
- Use parameters in SQL commands.
- 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.
- Use data consumer to read blob data or data producer to write blob data continuously.
- Use SpatiaLite library with Xojo.
- Use API for online Backups in SQLite.
- Use your own copy of the native connector library.
- Works with Xojo. Works with Web, Desktop and Console.
- Works with MySQL Bit data type. (Feedback case 16547)
- Connect to Microsoft SQL Server without installing native client using OLEDB option.
- Can provide RecordSets for use with Xojo reports engine.
- Supports moving forward/backword, first and last in result sets.
- Use SQLCipher library with Xojo, a version of SQLite with built in encryption.
- With version 15.3 supports internal SQLite library built into the plugin with SQLite Encryption Extension. Compatible to Xojo's encrypted databases and offering AES 128, 256 and RC4 encryption.
The MBS Xojo SQL Plugin is a Xojo plugin for accessing multiple SQL databases (Centura SQLBase, DB2, 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||Mac OS X 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)|
|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)|
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 Mac OS X, Windows and Linux for Desktop, 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.
Watch tutorial videos:
|MBS SQL Plugin Presentation|
MBS Xojo tutorial videos