Database – Page 7 – Xojo Programming Blog

Guest Post: Managing Database Schema Control Over Multiple Versions

Published December 6, 2014 by Xojo

Wayne Golding has been a Xojo developer since 2005. He operates two IT companies, a Network/Systems services co & DRNine11 an offsite backup & DR co. Though he primarily uses Xojo for internal management systems and utilities, Wayne’s hobby is robotics where he uses Xojo to communicate with Arduino devices.

When distributing applications with a database component you will undoubtedly upgrade your database schema as your application matures. So how do you manage the schema within your application?

Comments closed

Working with Databases

Published July 8, 2014 by Paul Lefebvre

I hear a lot from people that want to make database apps using Xojo but don’t know where to get started.

Comments closed

Using Firebird with Xojo

Published April 14, 2014 by Paul Lefebvre

Firebird is a completely free (cost and license), cross-platform database with some interesting features.

Comments closed

Full Text Search with SQLite

Published March 14, 2014 by Paul Lefebvre

SQLite has the ability to do full text searching and this feature is available with Xojo. Read on to learn how to best use it!

Comments closed

Database Transactions

Published December 20, 2013 by Paul Lefebvre

I am often asked when it makes sense to use Commit with your database code. The answer is always “it depends”. To go into more detail, let’s talk a bit about transactions.

Comments closed

Renaming Columns in SQLite Tables

Published December 4, 2013 by Paul Lefebvre

The SQLite ALTER TABLE command is somewhat limited. For one thing, it cannot be used to rename an existing column on a table. But there is a workaround.

Comments closed

The Xojo Plugins Folder

Published November 13, 2013 by Xojo

Xojo ships with 5 database plugins in the Plugins folder. These plugins are what you use to connect to the following database servers and ODBC:

Microsoft SQL Server
MySQL
Oracle
PostgreSQL

The ODBC database plugin allows you to connect to any database engine that supports ODBC connections.

Comments closed

PostgreSQL SSL Connection

Published August 30, 2013 by Paul Lefebvre

Your Xojo apps can connect to many different databases, including PostgreSQL, MySQL, Oracle, Microsoft SQL Server and ODBC. Learn more about connecting to different database servers here.

We get all sorts of questions about connecting your apps to specific databases. Recently, a developer asked about connecting his app to the PostgreSQL database using SSL for a secure connection. In Xojo this is simple.

Comments closed

Database Connectivity with Xojo

Published June 19, 2013 by Paul Lefebvre

Xojo can connect to a wide variety of databases, including: SQLite, PostgreSQL, MySQL, Oracle, Microsoft SQL Server and pretty much anything else using ODBC. A must-read for anyone building their first database application.

Comments closed

Category: Database