Which is the format of err?

[alexandercerutti]

Hello, I'm writing here to get explanations about err callback's parameter for the methods which have it.
It is an object (typeof err; // object) but contains something "else" other than the simple keys.
I.e., it is (on ad hoc error case)

{ Error: SQLITE_ERROR: near "TABLA": syntax error errno: 1, code: 'SQLITE_ERROR' }

but its keys are

Object.keys(err); // ['errno', 'code']

So, what is the first part? Those informations should be "placed" also as Object keys, like:

{
"Error": "near 'TABLA': syntax error",
"code": "SQLITE_ERROR",
"errno": 1,
}

Can this be done on the next release? Thank you.

I had pretty much the same experience as you.

error.message will return the error string, not sure why that isn't made apparent anywhere.

[neorefraction]

I'm TOO late, but here is an sqlite error documentation page. Perhaps the best way to manage error is using the errno property, which is associated to SQLite error codes. It could be great if contributors add this info to the wiki to avoid confusion.

PD: Hope this help to somebody in 2025 or later 🙃