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 23 in printed book and digital formats -- plus a one-year subscription (beginning with 24.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 short, so hurry today and order this special bundle before the offer goes away!

Article Preview


Buy Now

Issue 24.5 ('LiDAR')
Instant purchase and download via GumRoad!

COLUMN

The MBS Xojo SQL Plugin in Action

Connecting to a PostgreSQL Database

Issue: 24.5 (September/October 2026)
Author: Stefanie Juchmes-Simonis
Author Bio: Stefanie studied computer science at the university in Bonn. She came into contact 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): 34,536
Starting Page Number: 61
Article Number: 24508
Resource File(s):

Download Icon project24508.zip Updated: 2026-08-31 13:09:07

Related Link(s): None

Excerpt of article text...

Anyone who works with Xojo will sooner or later encounter databases. In addition to Xojo's own database functions, the MBS Xojo SQL Plugin offers you additional options. For example, the plugin allows you to connect to databases such as CubeSQL, Centura SQLBase, DB2, DuckDB, Firebird, Informix, InterBase, MariaDB, Microsoft Access, Microsoft SQL Server, MySQL, ODBC, Oracle Database Server, PostgreSQL, SQL Anywhere, SQLite, SQLCipher, and Sybase. Not only is the range of supported databases enormous, but the plugin also stands out for its performance and additional features, such as improved prepared statements. In this article, I'd like to show how easy it is to connect to a PostgreSQL database using the MBS Xojo SQL Plugin and how we can work with such a database.

Preparation

First, we need a PostgreSQL server. For our example, simply download the app from the PostgreSQL website and install it on your system (https://postgresapp.com/). You can then start your server inside the app.

When you double-click on one of the databases, a prompt window opens, and you can begin creating your database. First, we'd like to create a table in our database and add a few records. To do this, we can use the following lines of code:

CREATE TABLE users (id INT, username VARCHAR(255), email VARCHAR(255), is_active boolean, created_at TIMESTAMP);

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