[issue45243] [sqlite3] add support for changing connection limits

Change by Erlend E. Aasland : -- resolution: -> fixed stage: patch review -> resolved status: open -> closed ___ Python tracker ___

[issue45243] [sqlite3] add support for changing connection limits

Serhiy Storchaka added the comment: New changeset 3d42cd9461e60c7427f3793f640cd975fbd99289 by Erlend Egeberg Aasland in branch 'main': bpo-45243: Use connection limits to simplify `sqlite3` tests (GH-29356) https://github.com/python/cpython/commit/3d42cd9461e60c7427f3793f640cd975fbd99289

[issue45243] [sqlite3] add support for changing connection limits

Erlend E. Aasland added the comment: Steve, do you think it is worth it adding an audit hook for setting connection limits? Most of the limits are harmless, but limits that control recursion are more interesting. SQLITE_LIMIT_EXPR_DEPTH: Maximum Depth Of An Expression Tree SQLite

[issue45243] [sqlite3] add support for changing connection limits

Change by Erlend E. Aasland : -- pull_requests: +27616 pull_request: https://github.com/python/cpython/pull/29356 ___ Python tracker ___

[issue45243] [sqlite3] add support for changing connection limits

Pablo Galindo Salgado added the comment: New changeset b6b38a82267ff70d2abaf2a8371327268887c97d by Erlend Egeberg Aasland in branch 'main': bpo-45243: Add support for setting/getting `sqlite3` connection limits (GH-28463)

[issue45243] [sqlite3] add support for changing connection limits

Change by Erlend E. Aasland : -- pull_requests: +27123 pull_request: https://github.com/python/cpython/pull/28790 ___ Python tracker ___

[issue45243] [sqlite3] add support for changing connection limits

Change by Erlend E. Aasland : -- keywords: +patch pull_requests: +26864 stage: -> patch review pull_request: https://github.com/python/cpython/pull/28463 ___ Python tracker

[issue45243] [sqlite3] add support for changing connection limits

Erlend E. Aasland added the comment: Christian, how about adding an audit event for something like sqlite3.Connection.setlimit()? My initial thought is: yes. -- nosy: +christian.heimes ___ Python tracker

[issue45243] [sqlite3] add support for changing connection limits

New submission from Erlend E. Aasland : I propose to add wrappers for the SQLite sqlite3_limit() C API. Using this API, it is possible to query and set limits on a connection basis. This will make it easier (and faster) to test various corner cases in the test suite without relying on