Release Notes for the GM - SQLite ODBC Driver

Version 1.0.0 released, 03.01.2024

• Fast, stable native code (build with freePascal).
• Thread safe. All objects inside the driver are internally secured by critical sections, so they can safely accessed by multiple threads.
• Conforms to ODBC standard 3.5.
• Unicode: The internal string type of the driver is Unicode (Utf-16). It exports only the SQLXxxxxW functions. But it converts string data to ANSI if an application wants character data as SQL_C_CHAR (instead of SQL_C_WCHAR).
• Support for Date, Time and Datetime datatypes.
• All important SQLite flags can be specified in the Connection strings.
• Easy to use dialog to create or change ODBC data source entries in the ODBC management of the system.
• Supports SQLSetPos with operations SQL_ADD, SQL_UPDATE, SQL_DELETE and SQL_REFRESH for tables with primary keys, when all primary key columns are in the select list of the statement.
• Automatic data type conversions for almost all possible type combinations: application buffer datatype <=> database column datatype.
• SQLite DLL's included in the installer.