René's URL Explorer Experiment


Title: bpo-44958: Only reset `sqlite3` statements when needed by erlend-aasland · Pull Request #27844 · python/cpython · GitHub

Open Graph Title: bpo-44958: Only reset `sqlite3` statements when needed by erlend-aasland · Pull Request #27844 · python/cpython

X Title: bpo-44958: Only reset `sqlite3` statements when needed by erlend-aasland · Pull Request #27844 · python/cpython

Description: https://bugs.python.org/issue44958

Open Graph Description: https://bugs.python.org/issue44958

X Description: https://bugs.python.org/issue44958

Opengraph URL: https://github.com/python/cpython/pull/27844

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:a2c4866b-b2d6-dd7c-097f-3339853b55dd
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD8A4:AA16D:63D83A:8BB387:696A1C01
html-safe-noncebc2002a9f66eb28eb0cc390b44c423cc94d0f77f2ef3ee6fe45e673ae6a20828
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJEOEE0OkFBMTZEOjYzRDgzQTo4QkIzODc6Njk2QTFDMDEiLCJ2aXNpdG9yX2lkIjoiNjIwODMwODc1OTIyMjY4ODc2OSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac66e9cc81ea17ce9a2a4d38607068dd3f8d48dcdb3cd5f006e86773fee7aad96b
hovercard-subject-tagpull_request:716225290
github-keyboard-shortcutsrepository,pull-request-list,pull-request-conversation,pull-request-files-changed,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///pull_requests/show/files
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/python/cpython/pull/27844/files
twitter:imagehttps://avatars.githubusercontent.com/u/13780613?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/13780613?s=400&v=4
og:image:althttps://bugs.python.org/issue44958
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None34a52bd10bd674f68e5c1b6b74413b79bf2ca20c551055ace3f7cdd112803923
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/python/cpython git https://github.com/python/cpython.git
octolytics-dimension-user_id1525981
octolytics-dimension-user_loginpython
octolytics-dimension-repository_id81598961
octolytics-dimension-repository_nwopython/cpython
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id81598961
octolytics-dimension-repository_network_root_nwopython/cpython
turbo-body-classeslogged-out env-production page-responsive full-width
disable-turbotrue
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releasee8bd37502700f365b18a4d39acf7cb7947e11b1a
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/python/cpython/pull/27844/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F27844%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
MCP RegistryNewIntegrate external toolshttps://github.com/mcp
ActionsAutomate any workflowhttps://github.com/features/actions
CodespacesInstant dev environmentshttps://github.com/features/codespaces
IssuesPlan and track workhttps://github.com/features/issues
Code ReviewManage code changeshttps://github.com/features/code-review
GitHub Advanced SecurityFind and fix vulnerabilitieshttps://github.com/security/advanced-security
Code securitySecure your code as you buildhttps://github.com/security/advanced-security/code-security
Secret protectionStop leaks before they starthttps://github.com/security/advanced-security/secret-protection
Why GitHubhttps://github.com/why-github
Documentationhttps://docs.github.com
Bloghttps://github.blog
Changeloghttps://github.blog/changelog
Marketplacehttps://github.com/marketplace
View all featureshttps://github.com/features
Enterpriseshttps://github.com/enterprise
Small and medium teamshttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
App Modernizationhttps://github.com/solutions/use-case/app-modernization
DevSecOpshttps://github.com/solutions/use-case/devsecops
DevOpshttps://github.com/solutions/use-case/devops
CI/CDhttps://github.com/solutions/use-case/ci-cd
View all use caseshttps://github.com/solutions/use-case
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
View all industrieshttps://github.com/solutions/industry
View all solutionshttps://github.com/solutions
AIhttps://github.com/resources/articles?topic=ai
Software Developmenthttps://github.com/resources/articles?topic=software-development
DevOpshttps://github.com/resources/articles?topic=devops
Securityhttps://github.com/resources/articles?topic=security
View all topicshttps://github.com/resources/articles
Customer storieshttps://github.com/customer-stories
Events & webinarshttps://github.com/resources/events
Ebooks & reportshttps://github.com/resources/whitepapers
Business insightshttps://github.com/solutions/executive-insights
GitHub Skillshttps://skills.github.com
Documentationhttps://docs.github.com
Customer supporthttps://support.github.com
Community forumhttps://github.com/orgs/community/discussions
Trust centerhttps://github.com/trust-center
Partnershttps://github.com/partners
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
Archive Programhttps://archiveprogram.github.com
Topicshttps://github.com/topics
Trendinghttps://github.com/trending
Collectionshttps://github.com/collections
Enterprise platformAI-powered developer platformhttps://github.com/enterprise
GitHub Advanced SecurityEnterprise-grade security featureshttps://github.com/security/advanced-security
Copilot for BusinessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/premium-support
Pricinghttps://github.com/pricing
Search syntax tipshttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
documentationhttps://docs.github.com/search-github/github-code-search/understanding-github-code-search-syntax
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fpull%2F27844%2Ffiles
Sign up https://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fpull_requests%2Fshow%2Ffiles&source=header-repo&source_repo=python%2Fcpython
Reloadhttps://github.com/python/cpython/pull/27844/files
Reloadhttps://github.com/python/cpython/pull/27844/files
Reloadhttps://github.com/python/cpython/pull/27844/files
python https://github.com/python
cpythonhttps://github.com/python/cpython
Please reload this pagehttps://github.com/python/cpython/pull/27844/files
Notifications https://github.com/login?return_to=%2Fpython%2Fcpython
Fork 33.9k https://github.com/login?return_to=%2Fpython%2Fcpython
Star 71.1k https://github.com/login?return_to=%2Fpython%2Fcpython
Code https://github.com/python/cpython
Issues 5k+ https://github.com/python/cpython/issues
Pull requests 2.1k https://github.com/python/cpython/pulls
Actions https://github.com/python/cpython/actions
Projects 31 https://github.com/python/cpython/projects
Security Uh oh! There was an error while loading. Please reload this page. https://github.com/python/cpython/security
Please reload this pagehttps://github.com/python/cpython/pull/27844/files
Insights https://github.com/python/cpython/pulse
Code https://github.com/python/cpython
Issues https://github.com/python/cpython/issues
Pull requests https://github.com/python/cpython/pulls
Actions https://github.com/python/cpython/actions
Projects https://github.com/python/cpython/projects
Security https://github.com/python/cpython/security
Insights https://github.com/python/cpython/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fpython%2Fcpython%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fpython%2Fcpython%2Fissues%2Fnew%2Fchoose
pablogsalhttps://github.com/pablogsal
python:mainhttps://github.com/python/cpython/tree/main
erlend-aasland:sqlite-optimise-resetshttps://github.com/erlend-aasland/cpython/tree/sqlite-optimise-resets
Conversation 25 https://github.com/python/cpython/pull/27844
Commits 16 https://github.com/python/cpython/pull/27844/commits
Checks 0 https://github.com/python/cpython/pull/27844/checks
Files changed https://github.com/python/cpython/pull/27844/files
Please reload this pagehttps://github.com/python/cpython/pull/27844/files
bpo-44958: Only reset sqlite3 statements when needed https://github.com/python/cpython/pull/27844/files#top
Show all changes 16 commits https://github.com/python/cpython/pull/27844/files
99adc05 bpo-44958: Only reset sqlite3 statements when needed Aug 19, 2021 https://github.com/python/cpython/pull/27844/commits/99adc054bbe35a9f681cf3e39b631d9140028b0a
2f8cb23 We don't use the return value of pysqlite_statement_reset Aug 20, 2021 https://github.com/python/cpython/pull/27844/commits/2f8cb23768c8e33aec76c58cb86601632e5a85cc
e6e4973 If possible, avoid resetting unused statements Aug 20, 2021 https://github.com/python/cpython/pull/27844/commits/e6e4973f08cc77fbdd6abf955d6e42104f6970f5
df769c3 SQLITE_STMTSTATUS_RUN is available from 3.20.0 and onwards Aug 20, 2021 https://github.com/python/cpython/pull/27844/commits/df769c32595711a5b5453773b29cfd4b0777d115
cbcd640 Use sqlite3_stmt pointer iso. deref'ing self when calling sqlite3_reset Aug 20, 2021 https://github.com/python/cpython/pull/27844/commits/cbcd64085536890a1477050402bb22f86aaa6e2a
fe0fd6f Merge branch 'main' into sqlite-optimise-resets Aug 22, 2021 https://github.com/python/cpython/pull/27844/commits/fe0fd6ff7eb93e62cb78562f59c77846acaee6da
0633095 Sync with 'main' bco. GH-27884 Aug 25, 2021 https://github.com/python/cpython/pull/27844/commits/0633095bde1709f81fce095ec4a8e224307507e9
06e242c pysqlite_statement_reset result() is never used => return void Aug 25, 2021 https://github.com/python/cpython/pull/27844/commits/06e242c37686d4a8b33979552481821bfb701a25
747000c Sync with `main` bco. GH-27942 Aug 25, 2021 https://github.com/python/cpython/pull/27844/commits/747000c1b06d983cebd7736e3f9fd8ce862bc3c8
4ad7e99 Make sure we reset statements both at cursor dealloc and when the Sep 6, 2021 https://github.com/python/cpython/pull/27844/commits/4ad7e99b38b7e32a15be39324181f740e7672f11
1bbb31f Harden test_type_map_usage() Sep 6, 2021 https://github.com/python/cpython/pull/27844/commits/1bbb31f04f1264b6176a58ad6cba1e3061ae9deb
73e1ddb Add regression tests for stmt exit from cursor Sep 6, 2021 https://github.com/python/cpython/pull/27844/commits/73e1ddb20d635faf4e627c9fc95de94e5d1ec8ac
9684593 Merge branch 'main' into sqlite-optimise-resets Sep 6, 2021 https://github.com/python/cpython/pull/27844/commits/9684593e4fbdc9c6f30324d1025e6072b614a4c1
41410e0 Merge branch 'main' into sqlite-optimise-resets Sep 14, 2021 https://github.com/python/cpython/pull/27844/commits/41410e0acf201283adf74c05b3a7653c9191332f
ebebdb7 Merge branch 'main' into sqlite-optimise-resets Sep 20, 2021 https://github.com/python/cpython/pull/27844/commits/ebebdb7a7d31d14038d2b6da162a813b231a6307
c84311e Test that datamodifying select queries are marked readonly Sep 20, 2021 https://github.com/python/cpython/pull/27844/commits/c84311e8a3655b4037459db2925c2f03861f074a
Clear filters https://github.com/python/cpython/pull/27844/files
Please reload this pagehttps://github.com/python/cpython/pull/27844/files
Please reload this pagehttps://github.com/python/cpython/pull/27844/files
test_regression.py https://github.com/python/cpython/pull/27844/files#diff-73c740f84907ad2327f97eceb2af5aa22b67a079ca5a2159504fb1eabf2b7c23
cursor.c https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
statement.c https://github.com/python/cpython/pull/27844/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
statement.h https://github.com/python/cpython/pull/27844/files#diff-fe50e985937cb268938f994ef6d640f829565a8db6b538200c81823bc5e5d738
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L578
Lib/sqlite3/test/test_regression.pyhttps://github.com/python/cpython/pull/27844/files#diff-73c740f84907ad2327f97eceb2af5aa22b67a079ca5a2159504fb1eabf2b7c23
View file https://github.com/erlend-aasland/cpython/blob/c84311e8a3655b4037459db2925c2f03861f074a/Lib/sqlite3/test/test_regression.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27844/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27844/files#diff-73c740f84907ad2327f97eceb2af5aa22b67a079ca5a2159504fb1eabf2b7c23
https://github.com/python/cpython/pull/27844/files#diff-73c740f84907ad2327f97eceb2af5aa22b67a079ca5a2159504fb1eabf2b7c23
https://github.com/python/cpython/pull/27844/files#diff-73c740f84907ad2327f97eceb2af5aa22b67a079ca5a2159504fb1eabf2b7c23
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L580
Modules/_sqlite/cursor.chttps://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
View file https://github.com/erlend-aasland/cpython/blob/c84311e8a3655b4037459db2925c2f03861f074a/Modules/_sqlite/cursor.c
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27844/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
Please reload this pagehttps://github.com/python/cpython/pull/27844/files
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/pull/27844/files#diff-7209d2a9e4167e7aefe9b52e03d1d291f2e078cbfac7652c747d91f90fbacb82
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L580
Modules/_sqlite/statement.chttps://github.com/python/cpython/pull/27844/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
View file https://github.com/erlend-aasland/cpython/blob/c84311e8a3655b4037459db2925c2f03861f074a/Modules/_sqlite/statement.c
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27844/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27844/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/pull/27844/files#diff-517a9c73ccad12dd55f0beb930416fee87cade1b2abbb84a73ed8e39cc696c39
https://github.com/python/cpython/blob/main/.github/CODEOWNERS#L580
Modules/_sqlite/statement.hhttps://github.com/python/cpython/pull/27844/files#diff-fe50e985937cb268938f994ef6d640f829565a8db6b538200c81823bc5e5d738
View file https://github.com/erlend-aasland/cpython/blob/c84311e8a3655b4037459db2925c2f03861f074a/Modules/_sqlite/statement.h
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/python/cpython/pull/27844/{{ revealButtonHref }}
https://github.com/python/cpython/pull/27844/files#diff-fe50e985937cb268938f994ef6d640f829565a8db6b538200c81823bc5e5d738
https://github.com/python/cpython/pull/27844/files#diff-fe50e985937cb268938f994ef6d640f829565a8db6b538200c81823bc5e5d738
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width

URLs of crawlers that visited me.