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