SQLite turned 16

SQLite just turned 16 years old.

The first check-in of SQLite code occurred 16 years ago.
see sqlite.org/src/timeline?c=2000-05-29

Version 1 just had a few commands. Open database, close database, execute a statement. Code for recordsets didn't exist at that time and came later.

Congratulations to Richard Hipp and his team!

DynaPDF 4.0

Yesterday DynaForms GmbH released DynaPDF 4.0.

PDF/A conversion
The focus of development in DynaPDF 4.0 was the development of a new PDF/A 2b and PDF/A 3b converter. The new converter should be able to completely rebuild PDF files.
This requirement has lead to the development of a new content parser that is able to completely regenerate and optimize content streams. This makes it possible to apply much more extensive repairs. Since all content streams will be rebuild, also references of the .notdef character can be removed (in PDF/A 1 it was allowed to reference the .notdef character directly but this is no longer allowed in PDF/A 2 and 3).
This increases the conversion rate drastically and completely error free and optimized PDF files will be created which render and print faster. This is not only interesting for PDF/A conversion, PDF files can also be normalized or just optimized.
Not anything that is possible with the new content parser is already available in corresponding functions. For example, the parser is also the new base for the rendering engine. Since it can read and write page contents, the development of a PDF editor is no problem anymore. Especially images and vector graphics can be edited in addition to text, which was not possible before. In the coming months the new parser will replace the old code more and more.

The icons of text and file attachment annotations, as well as the pre-defined stamps can now dynamically created in German, French, and English. This is especially important when viewing PDF files since nothing could be shown if the icons or stamps are not embedded.

FileMaker, Xojo and Real Studio
The new plugin for DynaPDF 4.0 will be available in the next days. We include new options there for optimizer to reduce image sizes.

Austin and Koblenz

A few times I visited Austin, Texas already. Mostly because Xojo Inc. is there and I visit their conferences if possible.

Now I just learnt that Koblenz has a partner city in Texas and it's Austin.

And there is a whole community around visiting each other's city:

Now we have to see if we do another conference in Koblenz and get someone from Austin to come. As far as I know 4 employers of Xojo Inc. near in or near Austin.

PS: Also discovered years ago on a trip to Atlanta that Marietta, Georgia had a German partner city nearby my home town: Linz. So in both cities I saw signs about that partnership.

MBS FileMaker Plugin 6.2 for OS X/Windows

Nickenich, Germany - (May 24th, 2016) -- MonkeyBread Software today is pleased to announce MBS FileMaker Plugin 6.2 for Mac OS X or Windows, the latest update to their product that is easily the most powerful plugin currently available for FileMaker Pro. As the leading database management solution for Windows, Mac, and the web, the FileMaker Pro Integrated Development Environment supports a plugin architecture that can easily extend the feature set of the application. MBS FileMaker Plugin 6.2 has been updated and now includes over 3900 different functions, and the versatile plugin has gained more new functions:

Our latest plugin has been tested and optimized for latest FileMaker 15 release. While we support FileMaker 15 since version 6.0 already, a few issues have been found and fixed when using FileMaker 15. Finally as FileMaker 15 now runs 64-bit on Mac, we fixed a few issues related to 64-bit, too.

We got new functions for RSA signatures and encryption. You can generate a new private key and extract the public key. Using the private key you can sign some data and later check signature with public key. For encryption you can use either private or public key to encrypt. On the other side you decrypt using the other key. This way you can encrypt on one side using private key and decrypt on other side with public key.

Our new Events functions allow you to query calendars on Mac OS X for events and reminders. You can create, modify and delete entries as needed. Those new functions are 64-bit only. For 32-bit you can use existing Calendar functions.

For SQL we got new functions to convert BLOB to container value. New XML functions allow you to format XML or create a canonical version.

Our Mac Audio and Video recording can now provide a still photo on Mac. And the video exporter can merge several videos into one file while exporting.

The webviewer may block loading websites with invalid SSL certificate. We can put some hosts in the white list to load the website anyway. As the Webviewer on Windows doesn't accept the @ key with some keyboard layouts (e.g. German), we got a new function to send key events to Webviewer. This way you can send key strokes to Webviewer and press @ for the user if needed, including with @ as hotkey.

Our DynaPDF users can now extract text of only a rectangle part of the page. Our difference showing feature for PDF pages now handles transparent areas and recognizes smaller changes. You can define replacement ICC profiles for PDF/A creation.

Our dialog functions got updated to show an icon on Windows. We added options for timeout and custom buttons. The parent window is now set for Windows, so the FileMaker window stays behind the dialog.

The print dialog modifications on Mac OS X can now set options for copies, first/last/all pages. You can query last options as XML and set/get any options by name.

When working with files and folders, we can now query the size of a folder efficiently. On Mac we can set/get the Finder comment and the label color.

We also have improved list functions, query scrolling position, more CURL options, you can automatically click buttons or press keys with delay.

Finally we updated DynaPDF to version, libJPEG auf 9b, SQLAPI++ auf 4.1.9, libSSH auf 1.7.0, CURL auf 7.47.1, OpenSSL to version 1.0.2f and SQLite to version 3.13.0.

See release notes for a complete list of changes.

FileMaker conferences and meetings

As you know I collect on my events page a list of FileMaker related events. Beside DevCon from FileMaker, there are a couple of user organized events and from time to time I invite for dinner meetings:
  • FileMaker Developer Meeting, 30th May 2016 in Stockholm, Sweden, see mbsplugins.de (Register)
  • .fmp[x]Berlin, English, 2nd to 4th June 2016 in Berlin, Germany, see dotfmp.com
  • FileMaker Developer Meeting, 13rd June 2016 in Kopenhagen, Denmark, see mbsplugins.de (Register)
  • FileMaker Bärencamp, German, 7th to 9th July 2016 in Leinefelde-Worbis, Germany, see mkv.de
  • FileMaker DevCon, English, 18th to 21st July 2016 in Las Vegas, USA, see filemaker.com/developers/devcon/
  • FileMaker Conference, English, 10th to 11th October 2016 in ?, UK
  • FM Summit, Dutch, 10th to 11th October 2016 in Antwerpen, Belgium, see fmsummit.info
  • FileMaker Conference, Italian, 11th to 13rd October 2016 in Bolonga, Italy, see fmdevcon.com
  • MBS FileMaker Plugin Workshop, 12th October 2016 in Salzburg, Austria, see mbsplugins.de (Register)
  • FileMaker Konferenz, German, 13rd to 15th October 2016 in Salzburg, Austria, see filemaker-konferenz.com
  • FileMaker Conference, Swedish, 17th to 18th October 2016 in ?, Sweden
  • FM Conférence, French, 19th to 21st October 2016 in Avignon, France, see fmconf.com
  • MBS Workshop, German, 3rd November 2016 in Hofheim (Taunus), Germany, see denkform.net (Register)
If you have information about other events, please tell me.

Developer Meetings for Sweden and Denmark

We organize Xojo and FileMaker developer meetings for Kopenhagen, Denmark and Stockholm, Sweden:

If you like to join, please contact me soon:

29th May 2016, Stockholm
We meet with a couple of Xojo developers in a nice restaurant on the Alviks beach.
Topics will include current Xojo release, MBS Plugins and Xojo conferences.

30th May 2016, Stockholm
We meet with a couple of FileMaker developers in a nice restaurant on the Alviks beach.
Topics will include recent FileMaker 15 release, MBS Plugins and the upcoming conferences.

13rd June 2016, Kopenhagen
We meet with a couple developers in downtown Kopenhagen.
Topics will include the WWDC keynote from Apple, recent plugin changes and what's new in Xojo/FileMaker world.

Of course you can attend all the meetings if you like. We meet normally at 18 o'clock, but of course you can come later.
Joining is free of cost except for your own traveling, food and beverages.

MBS FileMaker Plugin, version 6.2pr10

New in this prerelease of the 6.2 plugins:
  • Added XML.Canonical and XML.Format.
  • Fixed bug in DynaPDF.SetReplaceICCProfile.
  • Added Webview.AllowsAnyHTTPSCertificateForHost to allow ignoring bad SSL certificates.
  • Updated SQLite to 3.13.0.
  • Updated libJPEG to version 9b.
  • Added SQL.GetFieldAsContainer and SQL.GetParamAsContainer.
  • Added Files.GetFinderLabel and Files.SetFinderLabel.
  • Added mode to Window.RemoveMenu to clear menu.
  • Added Menubar.RemoveMenuCommand function.
  • Added CURL.GetDebugWithData, CURL.GetDebugWithTime, CURL.SetDebugWithData and CURL.SetDebugWithTime.
  • Changed SerialPort.List to return on Mac the full device name which may include an ID to make it unique if you have several devices with same name. The SerialPort.Open function accepts full name and shorter name.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

Webviewer certificate overwrite

The FileMaker Webviewer on Mac OS X checks SSL certificates. All browser do the same. If the browser encounters a certificate mismatch, it will show a warning dialog and you can decide what to do:

In the browser you can click continue and see the website. Someone may read your traffic and the connection is not secure. Of course you can request the website to install a properly certificate file or add the used certificate to the keychain and accept it always. In FileMaker the webview will show an error about the SSL certificate and not load the page. That is bad for us when we just want to grab some values for lookup. In some cases an insecure connection is better for us than no connection.

Now with our new function Webview.AllowsAnyHTTPSCertificateForHost we can allow specific domains to ignore the certificate problem. We can add the domains to the white list and connect anyway. This allows the solution to grab the data from the website. On the long run we request the website to fix the certificate, but for today we are good.

The new function will be in 6.2pr10 in the next days. Please email us if you want to try it today.

PS: For Xojo you can use the NSURLRequestCertificateFilterMBS class to do the same.

Podcast with Dr Hipp: SQLite history, success and funding

Interesting podcast about SQLite history:

#201: SQLite with Richard Hipp
This week we talked with Richard Hipp, the creator of SQLite, about its history, where it came from, why it succeeded as a database, how it's development is sustainably funded, and how it's the most widely deployed database engine in the world.

see changelog.com/201/

MBS FileMaker Plugin, version 6.2pr9

New in this prerelease of the 6.2 plugins:
  • Added RightShift, RightOption and RightControl for hotkey registration as modifiers.
  • Added Webview.PressKey function to press @ key on Windows. Works also on Mac/Win to press other keys.
  • Updated DynaPDF to version
  • Changed Files.ListRecursive on Mac to include trailing slash in folder paths.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

FileMaker Webviewer and @ key

In several languages the typing of an @ symbol is by using AltGr key. The FileMaker Webviewer on Windows in FileMaker 12, 13, 14 and 15 does not allow you typing anything with AltGr key. At least in my testings.

You can read about the bug on the FileMaker community (here and here). We know FileMaker has probably more urgent bugs to fix, but we hope this gets fixed eventually.

With MBS FileMaker Plugin we can offer a workaround. Our new WebView.PressKey function can be used to send a key event to the webviewer. You can specify which webviewer and pass any key you like to be pressed. Now that is great and you can make a button to press @ key of your user.

If you combine this with our hotkey feature, you can create a hotkey on Windows for alt-q (for German keyboard) to trigger a script or an evaluate. There you can press @ for the user and it appears to the user like the bug is fixed.

This will be available soon with 6.2pr9. If you like to try, send me an email for a test plugin today.

MBS Plugin Schulungen und Workshops auf Deutsch

Auch 2017 biete ich wieder eine MBS FileMaker Schulung auf Deutsch an.
Am Tag vor der FileMaker Konferenz in Salzburg, am 11. Oktober 2017 (Mittwoch) von ca. 9 bis 17 Uhr.

  • Neues im MBS Plugin.
  • Rundgang durch Beispiele
  • MBS Plugin verwenden mit FileMaker Cloud
  • MBS Plugin verwenden mit dem FileMaker iOS SDK
  • Erweiterungen im Skript Workspace
  • Beliebte Pluginfunktionen
    • FTP/SFTP Up/Download
    • Webservices einbinden
    • Bildbearbeitung
    • Barcodes generieren und erkennen
    • Arbeiten mit dem Webviewer
    • SQL Anfragen in FIleMaker oder an andere Datenbanksysteme
  • Zeit für Fragen
Anmeldung bei mir. Kosten 99 Euro + MWSt. inklusive Mittagessen und Kaffeepausen.
Bitte Umsatzsteuer ID angeben bei der Anmeldung.

Alternativ können Sie gerne auch zum MBS Workshop bei der Denkform kommen am 2. März und 7. Dezember 2017 in Hofheim (Taunus) in der Nähe von Frankfurt.

Reading CURL logs

Today we look into a CURL log and explain the messages. The following log is from sending an email, so let's check it:

Rebuilt URL to: smtp://sslout.df.eu/

This shows the URL we really connect to. This URL may be rewritten/fixed by CURL from what you passed.


We got an IP for the domain and now try to connect. Depending if your OS prefers IPv4 or IPv6, it may be the preferred IP type.

Connected to sslout.df.eu ( port 587 (#0)

We are connected. Here you see the IP and port we did connect to.

220 smtprelay01.ispgateway.de ESMTP dfex

The server is greeting us, shows the name it's configured with. (more)

MBS Plugin for FileMaker 15

FileMaker 15 was released today by FileMaker Inc.

Our MBS Plugin supports FileMaker 15 for a few months already.
Version 6.0 was updated to support FileMaker 15 by using the latest Plugin SDK.
The upcoming release 6.2 will include a few little bug fixes we will find now when testing with final FileMaker 15 version.

So please update to version 6.x if you haven't already.

MBS Workshop zur FileMaker Konferenz in Salzburg

Am Tag vor der FileMaker Konferenz in Salzburg bieten wir einen MBS Workshop an. Kommen Sie einfach einen Tag früher zur Konferenz und nehmen Sie am 12. Oktober 2016 an einer eintägigen Schulung teilnehmen. Lernen Sie die über 3500 Funktionen einmal näher kennen und wie Sie sie effektiv einsetzen. Sammeln Sie Ideen und verbessern Sie ihre FileMaker Lösungen durch den Einsatz unseres Plugins.

Das Monkeybread Software Plugin für FileMaker stellt eine vielseitige Erweiterung der eigenen Datenbank dar. Der Kurs bietet nicht nur einen tiefgreifenden Überblick in die Benutzung und Entwicklung, sondern bietet auch die Chance das Plugin günstiger zu erstehen.
  • Einführung in das MBS Plugin
  • Überblick über die Funktionsbereiche
  • Neues im MBS Plugin dieses Jahr
  • Rundgang durch ausgewählte Beispiele
  • Gemeinsames Implementieren von Plugin Funktionen in eine Datenbank:
  • Upload/Download mit CURL auf einen HTTP/FTP Server
  • Ausfüllen eines Formulares auf einer Webseite
  • Bilder bearbeiten
  • PDF Verarbeitung
  • Druckerfunktionen
  • Adressbuch und Kontakte abfragen bei Mac OS X.
  • Fragen und Antworten
Die Teilnahme kostet 99 Euro zuzügl. MWSt.. Veranstaltungsort ist das Crown Plaza Hotel (gleiches wie Konferenz).
Wir beginnen gegen 9:00 Uhr und die Schulung geht bis 17 Uhr. Natürlich können Sie auch früher gehen. Mittagessen und Kaffeepausen sind inklusive. Anmeldung hier.
(Mindestteilnehmerzahl erreicht. Die Schulung findet definitiv statt.)

MBS FileMaker Plugin, version 6.2pr7

New in this prerelease of the 6.2 plugins:
  • Fixed an issue with ODBC and SQL functions read CLOB fields.
  • Fixed an issue in WordFile functions to handle more special cases.
  • Fixed XML.Import.Cancel to clear the insert command list, too.
  • Updated SQLAPI++ 4.1.9.
  • Added AVRecorder.CaptureStillPhoto function.
  • Added Dictionary.SetList function.
  • Added PrintDialog.ClearOption, PrintDialog.ClearOptions, PrintDialog.GetLastSettings, PrintDialog.GetOption, PrintDialog.SetOption to set low level print options.
  • Added DynaPDF.ExtractPageRectText function.
  • Fixed a text encoding problem on Mac with Log method. Now umlauts show properly.
Download at monkeybreadsoftware.de/filemaker/files/Prerelease/ or ask for being added to the dropbox shared folder.

MBS FileMaker iOS SDK Extension 0.1

Nickenich, Germany - (May 4th, 2016) -- MonkeyBread Software today is pleased to announce MBS FileMaker iOS SDK Extension 0.1, the first extension available for FileMaker's iOS SDK used to create branded iOS apps based on FileMaker Go.

Currently we have no plugin SDK for FileMaker iOS SDK or FileMaker Go, so we can't port our MBS FileMaker Plugin with over 3900 functions to iOS. But we created a different way to add a few useful functions for iOS SDK. The result is this new library for you!

By installing our library into your iOS app, you can now use 4 new commands:

version: Shows version of the extension.
events.authorize: Asks iOS for permissions to access calendars.
events.newevent: Creates a new calendar event for the calendar on iOS.
events.newreminder: Creates a new reminder.

We may add more commands in the future based on feedback of users.
So far this works fine for creating events/reminders in our iOS SDK based solutions.

Download MBS FileMaker iOS SDK Extension.dmg

Please try and provide your feedback to use. If you need assistants, help of custom functions, we are available for hire. This extension is currently provided as-is without cost.

FileMaker DevCon 2016

Join us at FileMaker DevCon in Las Vegas, July 18-21, 2016.

Developer Meetings for Sweden

Later in May we have Xojo and FileMaker developer meetings in Stockholm, Sweden. Maybe you want to join me for a dinner event?

Xojo Meeting, Sunday 29th May 2016

FileMaker Meeting, Monday 30th May 2016

Location is not yet decided and will be emailed to the registered people on my lists before the event. If you want to join, please contact me soon.
The meetings are planned for time range 18 to 22 o'clock. Of course you can come later or leave earlier.

If you are interested in private time for consulting, training or discussion MBS or Xojo topics, we can of course schedule a meeting. Please contact me if interested.

See you there!

PS: we probably have some price to raffle :-)


May 2024
Apr 2024
Mar 2024
Feb 2024
Jan 2024
Dec 2023
Nov 2023
Oct 2023
Sep 2023
Aug 2023
Jul 2023
Jun 2023
May 2023
Apr 2023
Mar 2023
Feb 2023
Jan 2023
Dec 2022
Nov 2022
Oct 2022
Sep 2022
Aug 2022
Jul 2022
Jun 2022
May 2022
Apr 2022
Mar 2022
Feb 2022
Jan 2022
Dec 2021
Nov 2021
Oct 2021
Sep 2021
Aug 2021
Jul 2021
Jun 2021
May 2021
Apr 2021
Mar 2021
Feb 2021
Jan 2021
Dec 2020
Nov 2020
Oct 2020
Sep 2020
Aug 2020
Jul 2020
Jun 2020
May 2020
Apr 2020
Mar 2020
Feb 2020
Jan 2020
Dec 2019
Nov 2019
Oct 2019
Sep 2019
Aug 2019
Jul 2019
Jun 2019
May 2019
Apr 2019
Mar 2019
Feb 2019
Jan 2019
Dec 2018
Nov 2018
Oct 2018
Sep 2018
Aug 2018
Jul 2018
Jun 2018
May 2018
Apr 2018
Mar 2018
Feb 2018
Jan 2018
Dec 2017
Nov 2017
Oct 2017
Sep 2017
Aug 2017
Jul 2017
Jun 2017
May 2017
Apr 2017
Mar 2017
Feb 2017
Jan 2017
Dec 2016
Nov 2016
Oct 2016
Sep 2016
Aug 2016
Jul 2016
Jun 2016
May 2016
Apr 2016
Mar 2016
Feb 2016
Jan 2016
Dec 2015
Nov 2015
Oct 2015
Sep 2015
Aug 2015
Jul 2015
Jun 2015
May 2015
Apr 2015
Mar 2015
Feb 2015
Jan 2015
Dec 2014
Nov 2014
Oct 2014
Sep 2014
Aug 2014
Jul 2014
Jun 2014
May 2014
Apr 2014
Mar 2014
Feb 2014
Jan 2014
Dec 2013
Nov 2013
Oct 2013
Sep 2013
Aug 2013
Jul 2013
Jun 2013
May 2013
Apr 2013
Mar 2013
Feb 2013
Jan 2013
Dec 2012
Nov 2012
Oct 2012
Sep 2012
Aug 2012
Jul 2012
Jun 2012
May 2012
Apr 2012
Mar 2012
Feb 2012
Jan 2012
Dec 2011
Nov 2011
Oct 2011
Sep 2011
Aug 2011
Jul 2011
Jun 2011
May 2011
Apr 2011
Mar 2011
Feb 2011
Jan 2011
Dec 2010
Nov 2010
Oct 2010
Sep 2010
Aug 2010
Jul 2010
Jun 2010
May 2010
Apr 2010
Mar 2010
Feb 2010
Jan 2010
Dec 2009
Nov 2009
Oct 2009
Sep 2009
Aug 2009
Jul 2009
Apr 2009
Mar 2009
Feb 2009
Dec 2008
Nov 2008
Oct 2008
Aug 2008
May 2008
Apr 2008
Mar 2008
Feb 2008