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.