SQLite3ProfessionalPlugin is no longer for sale. This page and the download are for the convenience of our current customers.
SQLite3ProfessionalPlugin is a REALbasic plugin that gives your REALbasic projects low level access to the SQLite 3 database engine. 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 aren't 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 does have built-in Database and RecordSet classes but in addition to this, it supports a lot more sqlite 3 specific methods. 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.
These are the results of the test:
| SQLite3Professional | REALSQLDatabase |
| Memory usage: | 44 Bytes | 200 MB |
| Query Time (sec.): | 0.0001 | 15.879 |
| Time to scan RecordSet (sec.): | 4.331 | 0.037 |
| Total Time (sec.): | 4.331 | 15.916 |
|
As you can see SQLite3ProfessionalPlugin is always 300% / 400% faster than REALSQLDatabase and it requires about near null memory.
You can run this test yourself, just download the full REALbasic project here
(12KB - RB2006 syntax)
|
With this new plugin you can also extends the sqlite engine with functions and collation sequences written directly in
REALbasic, so for example you can write a query like:
SELECT rblen(a) FROM table WHERE ...
where rblen is a REALbasic routine.
With SQLite3Professional you can you create, open and manipulate any SQLite 3 database. You can also create in-memory databases and work with them exactly as if they were file-based databases. SQLite databases are fully cross-platform. Any database created on a Mac can be opened and manipulated on Windows, Linux, Solaris, Irix, and many other OSes.
SQLite3Professional supports REALbasic 2005 or higher on all platforms on which REALbasic runs (Mac OS X, Windows, and Linux).
Please note that you can also purchase the source code of this plugin.
Upgrades:
- Registered users of the 1.x version can upgrade to any 2.x version for free.
What's new in version 2.1:
- The SQLCachedSelect method now supports in-memory databases as source db
- Fixed an incorrect behavior (not really a bug) related to the db.Error and db.ErrorCode properties
- Fixed some bugs in the SQLiteRecordSet classes
- Fixed a bug that occurs when retrieving BLOB fields using the RB API
- Updated sqlite library to version 3.3.10 (patch 2)
- Added support for experimental FT2 module
- Added support for database located on shared volumes in OSX (beta code)
- Updated some examples
- Other small fixes and optimizations
