SQLite3Professional 1.2

SQLite3Professional is a plugin for REALBasic that gives you full low level access to sqlite 3 databases. Starting from RB2005, the sqlite3 engine is include in every version of REALbasic, but due to the way it is exposed to the end user, a lot of its power and its speed arent availables. SQLite3ProfessionalPlugin has been designed to take advantage of all the real speed and real power that the new sqlite3 engine can offer.

SQLite3ProfessionalPlugin is very different from the built-in REALbasic database engine, it doesnt have built-in Database and RecordSet classes (even if its easy to create a wrapper for these classes). It is a near 1 to 1 map to the sqlite3 C api, so you can have access to every sqlite3 routine, so for example, you can interact directly with the virtual machine or you can create your own sql functions, and much more. These are very powerful concepts that cannot be added to the current REALSQLDatabase plugin.

The audience for this plugin are professional database users, that, for example, can take advantage of the sqlite3 progress handler routine to give time to other threads or to update the REALbasic GUI while a complex sql operation is in place, or that can use the sqlite3 virtual machine to build a query system with zero delay time and near zero memory requirements even if millions of rows are returned from a query.

As a real world test, we have created an sqlite 3 database with 10 columns and 200,000 rows (database size is about 200MB), and we have execute a "SELECT * from test" query.