Some way to get extended error codes

[micampe]

Currently LighterError includes errcode, but sometimes it's useful to have access to extended error codes, either as part of LigherError or with an option to enable them with sqlite3_extended_result_codes().

[helje5]

Looks like they should always be enabled on the connection level, e.g. in the SimplePool. The sole reason they seem to exist is backwards compat?

I guess I need to check whether we explicitly use error codes, but I suspect not

• old codes
• ext codes

https://www.sqlite.org/rescode.html
https://www.sqlite.org/c3ref/extended_result_codes.html

[micampe]

The sole reason they seem to exist is backwards compat?

My understanding of the documentation is the opposite: they default to off for compatibility.

The extended result codes are disabled by default for historical compatibility.

[helje5]

Yes, that's what I meant. The sole reason for the non-extended codes is backwards compatibility w/ code <2006. I think it would be OK to always enable them in Lighter, specifically.