MBS SQL Plugin
$149.00
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.
Features
-
- 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
- Built-in CubeSQL client library
