15th birthday of MBS SQL Plugin
Over the years we got requests for alternative database plugin classes for use with Xojo (formerly REALbasic). In 2009 a client requested a native plugin for Microsoft SQL Server, so we started writing a SQL Plugin and got a deal with SQLAPI to use this C++ library as the base of the plugin. Over the years, we contributed lots of changes and bug fixes and helped funding adding CubeSQL and SQL Anywhere support to SQLAPI.
As of today, we support 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. Well received features include using named parameters for prepared statements, full unicode support, threaded connect & execution, bulk row transfer, streaming blob values, and offering database specific options for advanced features. And recently we got even edit/update support for RecordSet and newer RowSet classes. Yes RowSet is supported!
You can use our plugin with one of two interfaces and even mix them. SQLConnectionMBS is our native interface for using all the nice features and works in Xojo Lite. This includes SQLCommandMBS class for doing both statement preparation and handling the result set. With SQLDatabaseMBS class, we have a database subclass, which makes transition easier for existing Xojo developers and use PreparedStatement interface and RecordSet class.
If you check the release notes for this plugin, you find that we recently we added SQLiteFunctionMBS class so you can define your own custom functions for SQLite when using it in our plugin as well as Xojo's SQLiteDatabase class.
If you like to try the plugin, please check the website. Watch SQL Plugin presentation and read Xojo Developer Magazine article in issue 14.1.
See also
- Converting Xojo project to use MBS SQL Plugin
- RowSet in MBS Xojo SQL Plugin
- Connect to Oracle via MBS Xojo SQL Plugin
- Connect to Microsoft SQL Server with MBS Xojo SQL Plugin
- Accessing Microsoft SQL Database from Mac/Linux
- Edit and Update for SQLDatabaseMBS class