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:

Databases for REAL

SQLite Update

REALbasic 2009 Release 5

Issue: 8.2 (January/February 2010)
Article Description: No description available.
Article Length (in bytes): 4,113
Starting Page Number: 57
RBD Number: 8215
Resource File(s): None
Related Web Link(s):

http://www.sqlite.org/changes.html
http://www.sqlite.org/foreignkeys.html

Known Limitations: None

Excerpt of article text...

In December 2009, REAL Software shipped REALbasic 2009 Release 5.1. One of the big changes for Release 5 was that REALSQLDatabase (aka SQLite) was upgraded to SQLite 3.6.20. Additionally, the plugin that integrates SQLite into REALbasic was significantly rewritten.

Unfortunately, there were a few bugs related to these changes that made SQLite in Release 5 not really usable. Fortunately REAL Software quickly addressed these problems in Release 5.1.

Background

Up until REALbasic 2009 Release 5, REALbasic was using SQLite 3.4.2, which was released in August 2007. SQLite 3.6.20 was released in November 2009, so there have been more than two years worth of changes in between these two versions.

If you take a look at the complete list of changes at the SQLite web site (http://www.sqlite.org/changes.html), you will note that most of them make some mention of "performance improvements." So let's do some quick tests to see if performance is really improved and by how much.

Performance

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