Article Preview
Buy Now
COLUMN
REALbasic 2005 New Database Features
A look at REALSQLDatabase and more
Issue: 4.1 (September/October 2005)
Author Bio: Paul Lefebvre is President and Chief Software Architect of LogicalVue Software, producers of SQLVue, RBUnit and other products.
Article Description: No description available.
Article Length (in bytes): 4,347
Starting Page Number: 32
Article Number: 4114
Related Link(s): None
Excerpt of article text...
Welcome back! This month we'll be going over some of the database-related changes included in REALbasic 2005.
REALSQLDatabase
The biggest change is that REAL Software has added yet another built-in database format. This new format, REALSQLDatabase, is based on SQLite 3 and SQLite Plugin Pro. SQLite Plugin Pro used to sell for $120 just by itself. Now it is included in REALbasic 2005 for free!
REALSQLDatabase is supported on Mac OS X, Windows and Linux, but it is not supported on Mac Classic so you'll need to keep using the older REALDatabase there.
SQLite is different than most databases in that it is not really type-specific. Although you can specify a type when defining columns (referred to as its "affinity" in the REALbasic Language Reference), you can pretty much store anything you want in any column. REALbasic attempts to be smart about this so that a column defined to store integers will attempt to have data converted accordingly, but there is nothing that prevents you from storing a string in an integer column. There is also no specific date column type.
SQLite supports more SQL than REALDatabase does and also has the ability to have views.
...End of Excerpt. Please purchase the magazine to read the full article.