SQLite Extended Result Code

[mvuc87]

Summary

I am having a report with error message mentioning SQLITE_IOERR. However, I cannot find the exact reason why application fails to use a database.

There are number of possibilities of what could went wrong in case of SQLITE_IOERR. The Extended Result Code List could provide more information about IO errors: https://www.sqlite.org/rescode.html#extended_result_code_list

Proposed implementation

When creating a Database object, provide a verbosity level for SQLite database errors.

For example

const database = new Database(file, {
  mode: OPEN_READWRITE,
  useExtendedResultCode: true
});

useExtendedResultCode has two possible values:

1. false (default) - primary result code is used
2. true - extended result code is used