Library Version 18.1.40

SQL API Changes
Prev | Chapter 8. Upgrading Berkeley DB 12.1.6.2 applications to Berkeley DB 18.1 | Next

## SQL API Changes

### 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

Prev | Up | Next
New Utility Command Line Option | Home | Changed Visual Studio Support