Migrate to SQLite3 trace v2 API

[erlend-aasland]

BPO	40318
Nosy	@berkerpeksag, @pablogsal, @erlend-aasland, @SamuelMarks
PRs	bpo-40318: Migrate to SQLite3 trace v2 API #19581 [3.9] bpo-40318: Migrate to SQLite3 trace v2 API (GH-19581) #23102 [3.8] bpo-40318: Migrate to SQLite3 trace v2 API (GH-19581) #23103
Files	0002-Use-new-sqlite3_trace_v2-API-if-possible.patch

^{Note: these values reflect the state of the issue at the time it was migrated and might not reflect the current state.}

Show more details

GitHub fields:

assignee = None
closed_at = <Date 2020-09-05.20:43:58.769>
created_at = <Date 2020-04-18.11:56:10.577>
labels = ['type-feature', 'library', '3.10']
title = 'Migrate to SQLite3 trace v2 API'
updated_at = <Date 2020-11-02.09:54:05.762>
user = 'https://github.com/erlend-aasland'

bugs.python.org fields:

activity = <Date 2020-11-02.09:54:05.762>
actor = 'samuelmarks'
assignee = 'none'
closed = True
closed_date = <Date 2020-09-05.20:43:58.769>
closer = 'pablogsal'
components = ['Library (Lib)']
creation = <Date 2020-04-18.11:56:10.577>
creator = 'erlendaasland'
dependencies = []
files = ['49073']
hgrepos = []
issue_num = 40318
keywords = ['patch']
message_count = 2.0
messages = ['366702', '376444']
nosy_count = 5.0
nosy_names = ['ghaering', 'berker.peksag', 'pablogsal', 'erlendaasland', 'samuelmarks']
pr_nums = ['19581', '23102', '23103']
priority = 'normal'
resolution = 'fixed'
stage = 'resolved'
status = 'closed'
superseder = None
type = 'enhancement'
url = 'https://bugs.python.org/issue40318'
versions = ['Python 3.10']

[erlend-aasland]

Currently, we're using the sqlite3_trace() for tracing statements. This API was been superseded by sqlite3_trace_v2() in SQLite3 v3.14 back in August 2016. Proposing to migrate to the new API, which allows more fine grained control over what to trace, and also opens up the door to stuff like prepared statement status variables.

See https://sqlite.org/c3ref/trace_v2.html, https://sqlite.org/c3ref/c_trace.html, https://sqlite.org/c3ref/c_stmtstatus_counter.html, and https://sqlite.org/c3ref/experimental.html.

Attached patch (against master) uses the new API if available. Make test completes without failures.

[pablogsal]

New changeset 7f331c8 by Erlend Egeberg Aasland in branch 'master':
bpo-40318: Migrate to SQLite3 trace v2 API (GH-19581)
7f331c8