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 10.3 ('Hashes')
Instant purchase and download via GumRoad!

COLUMN

One Last Look

Exploring database connectivity options

Issue: 10.3 (March/April 2012)
Author: Paul Lefebvre
Author Bio: Paul Lefebvre is the Real Software Developer Evangelist. He has been using Real Studio for over 10 years.
Article Description: No description available.
Article Length (in bytes): 5,074
Starting Page Number: 71
Article Number: 10311
Related Web Link(s):

http://www.sqlite.org
http://www.actualtech.com/
http://www.monkeybreadsoftware.de/realbasic/plugins.shtml
http://www.valentina-db.com/
http://studiostable.com/Database/
http://www.sqlabs.com/cubesql.php

Excerpt of article text...

I have been writing the Databases column in Real Studio Developer magazine since its second issue. With my new role as Real Software Developer Evangelist, I'll be retiring this column in place of a new column whose name has yet to be determined, but will cover Real Studio more broadly.

If you are intested in taking on a database column for the magazine, be sure to get in touch with Marc Zeedar. I'm sure he would love to hear from you!

In this last column, I'd like to recap the database connectivity options provided by Real Studio and 3rd parties.

Built-in Database Options

Real Studio has some wonderful database support that is built-in: RealSQLDatabase, the bundled single-user database engine, is actually SQLite under the hood. As I've written about before, SQLite, is a proven database engine and is quite likely the most used database engine in the world. It is fast, forgiving and easy to work with.

Real Studio includes plugins to connect to other databases, including the popular open-source databases MySQL and PostgreSQL. Of the two, I greatly prefer PostgreSQL, even if it is a bit more difficult to set up and configure. MySQL is not terrible, but you do have to be sure you understand its rather complicated licensing.

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