SQLite3Professional is a plugin that allows users to have complete low-level control of sqlite 3 databases.
Unlike the built-in REALbasic database engine, SQLite3ProfessionalPlugin doesn't have built-in Database and RecordSet classes. However, it is compatible with these classes and easy to create class wrappers. It maps almost 1 to 1 with the sqlite3 C api, offering users access to every sqlite3 routine. This allows users to interact directly with the virtual machine or create their own sql functions, among other things. These are powerful concepts that can't be integrated into the current REALSQLDatabase plugin.
This plugin is aimed at professional users who require advanced database manipulation. For example, with the sqlite3 progress handler routine, users can give time to other threads or update the REALbasic GUI while a complex sql operation is underway. Users can also use the sqlite3 virtual machine to create a query system with zero delay time and minimal memory requirements, even when millions of rows are returned from a query.
To demonstrate the impressive capabilities of the plugin, a real-world test has been conducted. An sqlite 3 database with 10 columns and 200,000 rows was created (with a database size of about 200MB), and a "SELECT * from test" query was executed.
SQLite3ProfessionalPlugin requires REALbasic 5.5 or higher. The latest release includes a number of small bug fixes and optimizations, such as fixing a crash bug that occurred when PEF version was used with multiprocessor Macs, improving concurrency with InstantQuery, and enhancements to the included examples.
In conclusion, SQLite3ProfessionalPlugin unlocks the true potential of sqlite3 and offers unparalleled power and speed for professional database users. The plugin is highly recommended for developers looking for advanced database manipulation capabilities.
Version 1.2: N/A