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 14 in printed book and digital formats -- plus a one-year subscription 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

PDF:

Feature

One Last Look

Exploring database connectivity options

Issue: 10.3 (March/April 2012)
Author: Paul Lefebvre
Article Description: No description available.
Article Length (in bytes): 4,150
Starting Page Number: 71
RBD Number: 10311
Resource File(s): None
Related Link(s): None
Known Limitations: None

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.

Article copyrighted by REALbasic Developer magazine. All rights reserved.


 


|

 


Weblog Commenting and Trackback by HaloScan.com