SQL API Changes

SQL User Authentication
New PRAGMAs
Internal Berkeley DB Messages
Updated SQL Version

SQL User Authentication

TThe SQL user authentication extension now requires encryption to ensure security.

New PRAGMAs

  • PRAGMA bdbsql_upgrade, which upgrades the connected database.

  • PRAGMA statistics, which prints out statistics about a database and its environment.

  • PRAGMA statistics_files, which redirects statistics about a database and its environment to a file.

Internal Berkeley DB Messages

Internal Berkeley DB messages are now redirected to the same file where internal Berkeley DB error messages are redirected.

Updated SQL Version

The Berkeley DB SQL API has been updated to be compatible with SQLite 3.18.2. For information on SQLite release history, see: https://www.sqlite.org/changes.html