You can read though the impressive list about how to get a corrupted SQLite database.
We never had problems so far here, but we use a lot of SQLite databases. So maybe the day comes where a database is running crazy and needs a fix.
Whenever you open a SQLite database in your application, please remember to first send this command via SQL Execute:
PRAGMA cache_size = 10000
this will increase the cache. Default is 2000 pages and with a page size of 1024 bytes that's only 2 MB of cache. You can easily set it to 10000 or 20000 pages on modern computers. This way you increase SQLite performance a lot!
Over the years our plugin got bigger and bigger. This is typically no problem with modern hard discs and automatic installation through databases or auto update.
But for some people size matters. For example with our Filemaker Runtime Shrinker we got a couple of responses. People doing runtimes love this tool.
But when they use our MBS Filemaker Plugin, the plugin itself can be a problem in size. We are now close to 10 MB which is for some people a problem. So we offer now a new service for slimmed down plugins. When you are ready to deliver your runtime solution, you inform us with a list of the MBS functions you use and we compile you a special copy of the current plugin version with all other functions disabled. This way the size of the plugin can easily fall from 10 MB down to 2 MB.
It's hard to predict the size of the plugin you get for your function set as some functions need more code than others. And we have to charge for this as this takes time to build. We are going to charge 49 Euro for each customized plugin copy. if you are interested, please contact us.
Added WebView.SetCustomUserAgent and WebView.GetCustomUserAgent functions.
Added functions for container value encryption: Encryption.EncryptContainerBlowfish, Encryption.DecryptContainerBlowfish, Encryption.EncryptContainerAES and Encryption.DecryptContainerAES.
Added more LibXL functions.
Fixed CURL to reset input file pointer when uploading same file data to multiple locations.
Fixed crash when disabling the MBS Filemaker Plugin in Filemaker Preferences.
Fixed FileDialogWatcher.Install so you can't install it several times.
Added parameter to WebView.Reload to force reload.
Fixed Windows clipboard functions. Sometimes they had extra characters at the end of the text.
As you have probably seen today, we added PHP functions to both the Real Studio and the Filemaker plugin. The new plugin is based on the current stable PHP release, version 5.4.6. It allows you to load the php library and execute code there. Also you can set and get global variables. This allows you to easily pass in and out text data.
If you like you can compile your own copy of the PHP library. This way you can enable or disable extensions. The libraries we include on Mac has for example this extensions: Core, date, ereg, libxml, pcre, sqlite3, zlib, bcmath, bz2, calendar, ctype, curl, dom, hash, fileinfo, filter, ftp, SPL, json, session, PDO, pdo_sqlite, standard, posix, Reflection, Phar, SimpleXML, soap, sockets, exif, tokenizer, xml, xmlreader, xmlwriter and zip.
We had a couple of years ago a PHP plugin which we dropped. It was linked to PHP 5.3 and not compatible with newer versions. Well, with the new plugin we rewrote big parts. Still it heavily depends on the PHP source code and if there is a change on some global data structures, we'll have to update the plugin again. If you need the plugin to be updated to a newer PHP version, please contact us.
Update: The examples for OCR and PHP use a line to replace ".fp7" with the library extensions. This needs to be changed to ".fmp12". We'll fix the examples with next prerelease.