The purpose of this article is to point out some of the special features of the SQLite Database that you might not know exist, or, if you know they exist, you might not know how best to make use of them. I’m assuming that readers of this article are comfortable working with Xojo’s database classes, and with the older REAL SQL Database. If you aren’t yet comfortable with Xojo’s database classes, then you might want to consider starting with ‘Databases for N00bs’ article, which is also available from RbLibrary.com.
The topics I cover in this article include in-memory databases, using SQLite’s built-in functions, attaching one database to another database, and making use of the special sqlite_master table. My hope is that this article will give you some ideas for how to incorporate one or more of the REAL SQL Database’s extra features in your own REALbasic projects. Some of the features I’ll be discussing can be useful in any project, even those that aren’t specifically database projects. Updated Feb 7, 2015 for the newer Sqlite Database.