The 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 the SQLConnectionMBS class which gives more options.
Connect to 14 different database systems, including CubeSQL, Centura SQLBase, DB2, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher and Sybase.
Connect to Microsoft Access, FileMaker Server (or Pro), Microsoft Visual FoxPro and others via ODBC
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 by streaming in chunks
Access databases where no plugin comes with Xojo: DB2, Sybase, SQL Anywhere, Informix, Firebird and Interbase
Use MySQL with Enterprise, Community or embedded libraries
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 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
Connect to Microsoft SQL Server without installing native client using OLEDB option
Can provide RecordSets for use with Xojo reports engine
Supports moving forward/backwords, 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
