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