Special

Introducing the “Welcome to Xojo” Bundle!

New to Xojo and looking for guidance? We've put together a terrific bundle to welcome you! Xojo Bundle

This bundle includes six back issues of the magazine -- all of year 21 in printed book and digital formats -- plus a one-year subscription (beginning with 22.1) so you'll be learning all about Xojo for the next year. It's the perfect way to get started programming with Xojo. And you save as much as $35 over the non-bundle price!

This offer is only available for a limited time as supplies are limited, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 21.1 ('Xojo Eliza')
Instant purchase and download via GumRoad!

COLUMN

A Database That Connects

A Mongo DB photo database used with FileMaker and Xojo

Issue: 21.1 (January/February 2023)
Author: Stefanie Juchmes
Author Bio: Stefanie studied computer science at the university in Bonn. She came in touch with Xojo due to the work of her brother-in-law and got a junior developer position in early 2019 at Monkeybread Software.
Article Description: No description available.
Article Length (in bytes): 20,321
Starting Page Number: 88
Article Number: 21109
Resource File(s):

Download Icon project21109.zip Updated: 2023-01-03 09:08:44

Related Link(s): None

Excerpt of article text...

The MBS Xojo plugins might be known to many Xojo users, but did you know that MBS develops a plugin for the FileMaker environment, too? Today I want to show you how you can connect a FileMaker solution with a Xojo application using MongoDB. In this example, we first build an application with FileMaker that stores images in a MongoDB database, which are then assigned categories and the images can then be searched in the Xojo application using the categories. The result is then displayed in the application together with the categories.

The special thing about MongoDB is that it is not a relational database based on tables and relationships, but its data has a JSON-like structure. This allows you to make queries that were previously not possible due to the restriction of relationships or table boundaries. The use of MongoDB under FileMaker is possible with the MBS FileMaker Plugin since version 12.3 and under Xojo with the MBS Xojo Plugins in version 22.3. The functionalities of MongoDB used here, find no matter whether in Xojo or FileMaker used, usually the suitable equivalent on the other side. If you want to follow the example, you need a MongoDB server. How to install a local and free version on Mac you can see in this video:

https://www.mbsplugins.com/MongoDBen.shtml

Let's start with the FileMaker part first, because this way we can feed the database with data that we can read out later with Xojo (see Figure 1).

...End of Excerpt. Please purchase the magazine to read the full article.