10th birthday of MBS SQL Plugin

Our MBS SQL Plugin turns 10 years old today.

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, 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.

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. 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 like to try the plugin, please check the website. Watch SQL Plugin presentation and read Xojo Developer Magazine article in issue 14.1.

Happy birthday for your plugin Christain

Thank you for the hard work and fast support. This plugin has sustained much of my work for the past 10 years.

As recently a few people started to use it and found a few issues, the 19.2 update will improve a couple of things a lot :slight_smile:

Support and updates from Christian’s team have been amazing over the years. I don’t know how many times I’ve asked Christian for something and by the time I woke up the next day, it’s already implemented. A-M-A-Z-I-N-G. Thank you, Christian.

I have sent him a question when it is some unruly-hour in Germany, and within minutes I have a clear, well thought out response. I think he and his team doesnt sleep.

Great work!

Thanks for all your plugins and all your hard work.
–sb

Your MBS SQL Plugin was a real lifesaver for me a few weeks ago. I’m working on a custom API that provides access to data in a Microsoft SQL Server database. Your plugin not only made this possible, but incredibly easy as well.

I can’t thank you enough for all of your plugins, and how much you’ve supported the Xojo community.

Thanks Christian!