sqlite3: use 64-bit APIs where possible

[erlend-aasland]

Has this already been discussed elsewhere?

• I have already discussed this feature proposal on Discourse
• This is a minor feature, which does not need previous discussion elsewhere

Links to previous discussion of this feature:

Recently, I upgraded the SQLite version requirement for the sqlite3 extension module. We can now upgrade the code to use some of the 64-bit APIs that were introduced with SQLite 3.8.7. Excerpt from the changelog:

Added new interfaces with 64-bit length parameters: sqlite3_malloc64(), sqlite3_realloc64(), sqlite3_bind_blob64(), sqlite3_result_blob64(), sqlite3_bind_text64(), and sqlite3_result_text64().

Summary of proposal:

Use 64-bit SQLite APIs in sqlite3 where possible

Pitch:

Limitations of the current APIs:

• we cannot bind text strings parameters or fetch database text strings longer than INT_MAX bytes
• we cannot fetch database BLOBs longer than INT_MAX bytes

Linked PRs

• gh-108021: In sqlite3, use 64-bit APIs for binding and returning text and blobs #108075