Tech Week 2024: Xojo + MongoDB

Xojo can be a fantastic front end or basis for data-focused solutions. But what about MongoDB?

MongoDB is a noSQL, document based database based on JSON like documents. MongoDB databases include one or more collections, which are groups of MongoDB documents that are associated with each other. A collection is roughly equivalent to a table, except that MongoDB does not require any overall schema, allowing each document to have its own internal structure.

PROS	CONS
You need support for a lot of unstructured data You need data distribution You need to be able to restructure you data as you go along	You need ACID Compliance You need (classic) Stored Procedures You need the structure

For Xojo developers, being able to work with MongoDB opens the doors to a fast moving current of internal and custom projects in the field of document-based database management. During MongoDB Week (August 11, 2024-August 17, 2024), we will introduce you to three of them.

Valentina Reports for MongoDB

Valentina Reports supports MongoDB! The Reports toolbox can convert MongoDB JSON objects into native expressions in JavaScript and Python. You can accomplish this right within the Report Designer within Valentina Studio PRO. Omegabundle for Xojo includes versions of Valentina Reports ADK for compiling apps to macOS, Windows & Linux. You can also use the Reports Server in Valentina Server Unlimited, also included in Omegabundle for Xojo 2024, to work with MongoDB Server.

MBS MongoDB Plugin

As a noSQL database, MongoDB provides within it something which is the equivalent of stored procedures, but if you are communicating from an external app such as you might build with Xojo, you are usually stuck with the MongoDB implementation of ODBC. Fortunately, Monkeybread Software provides you with a plugin and 11 base classes for working with MongoDB, as a part of MBS Plugin Complete.

Valentina Studio PRO for MongoDB

Unlike many other database management tools on the market, Paradigma Software's Valentina Studio PRO does not divide support for specific data sources into separate products. MongoDB is the second noSQL database supported by Valentina Studio (the first being Paradigma Software's own ValentinaDB). As a noSQL and document-based database, some of the paradigms of relational databases do not work for MongoDB. For that reason, Valentina Studio PRO supports MongoDB conventions by providing similar user interface tools adapted for MongoDB, including

MongoDB Connection Dialog. Includes specific login options under the Advanced Tab
MongoDB Server Administration. Very similar to handling of users and databases and general 'health' of the server
MongoDB Command Editor. Analogous to the Valentina SQL Editor, but designed to work with MongoDB Collections and Documents
MongoDB Data Editor. Analogous to the Valentina Data Editor, offering common view paradigms, filtering, sorting and more
MongoDB Collection Editor. Edit Collections and Documents and view them in different modes

Learn more about this topic.