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