René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Clean up sqlite3.Connection APIs","articleBody":"# Feature or enhancement\r\n\r\n### Has this already been discussed elsewhere?\r\n\r\nhttps://discuss.python.org/t/clean-up-some-sqlite3-apis/32093\r\n\r\n### Links to previous discussion of this feature:\r\n\r\nhttps://github.com/python/cpython/issues/87260#issuecomment-1156275354\r\n\r\n### Proposal:\r\n\r\nThe sqlite3.Connection class has groups of similar APIs with inconsistent parameter specs.\r\n\r\nCreate user-defined function APIs:\r\n\r\n- `create_function(name, narg, func, *, deterministic=False)`\r\n- `create_aggregate(name, /, n_arg, aggregate_class)`\r\n- `create_window_function(name, num_params, aggregate_class, /)`\r\n- `create_collation(name, callable, /)`\r\n\r\nSet callback APIs:\r\n\r\n- `set_authorizer(authorizer_callback)`\r\n- `set_progress_handler(progress_handler, n)`\r\n- `set_trace_callback(trace_callback)`\r\n\r\nFor all APIs but `create_function`, I suggest to make all parameters positional-only; for `create_function`, I suggest to make the three first parameters positional-only:\r\n\r\nCreate user-defined function APIs:\r\n\r\n- `create_function(name, nargs, callable, /, *, deterministic=False)`\r\n- `create_aggregate(name, nargs, aggregate_class, /)`\r\n- `create_window_function(name, nargs, aggregate_class, /)`\r\n- `create_collation(name, callable, /)`\r\n\r\nSet callback APIs:\r\n\r\n- `set_authorizer(authorizer_callback, /)`\r\n- `set_progress_handler(progress_handler, /, n)`\r\n- `set_trace_callback(trace_callback, /)`\r\n\r\nObviously, `create_window_function` stays as it is.\r\n\r\n**UPDATE**: I noticed the docs are wrong about `create_collation`; it's signature is actually `create_collation(name, callable, /)`.\r\n\r\n\u003c!-- gh-linked-prs --\u003e\r\n### Linked PRs\r\n* gh-108281\r\n* gh-108632\n\u003c!-- /gh-linked-prs --\u003e\r\n","author":{"url":"https://github.com/erlend-aasland","@type":"Person","name":"erlend-aasland"},"datePublished":"2023-08-22T11:29:19.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":8},"url":"https://github.com/108278/cpython/issues/108278"}