Special

Special Print Closeout!

We're clearing out the remainder of our print issues at fire sale prices -- as much as 75% off! Quantities are extremely limited and only available while supplies last. Hurry to take advantage of this one-time offer.

RBD Magazines

Once these printed back issues are gone, they are gone!

Article Preview


Buy Now

Print:
PDF:

Databases for Real

REALbasic 2005 New Database Features

A look at REALSQLDatabase and more

Issue: 4.1 (September/October 2005)
Article Description: No description available.
Article Length (in bytes): 3,026
Starting Page Number: 32
RBD Number: 4114
Resource File(s): None
Related Link(s): None
Known Limitations: 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.

...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