René's URL Explorer Experiment


Title: Use sharding for sqlite cache (16 shards) by JukkaL · Pull Request #21292 · python/mypy · GitHub

Open Graph Title: Use sharding for sqlite cache (16 shards) by JukkaL · Pull Request #21292 · python/mypy

X Title: Use sharding for sqlite cache (16 shards) by JukkaL · Pull Request #21292 · python/mypy

Description: Optional static typing for Python. Contribute to python/mypy development by creating an account on GitHub.

Open Graph Description: SQLite writes can become a major bottleneck for parallel runs, since only one write can be active at any time. Sharding helps a lot and was pretty easy to implement and reason about. We need to be ...

X Description: SQLite writes can become a major bottleneck for parallel runs, since only one write can be active at any time. Sharding helps a lot and was pretty easy to implement and reason about. We need to be ...

Opengraph URL: https://github.com/python/mypy/pull/21292

X: @github

direct link

Domain: github.com

react-profiling0
react-import-mapreact,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322
route-pattern/_view_fragments/voltron/pull_requests/show/:user_id/:repository/:id/pull_request_layout(.:format)
route-controllervoltron_pull_requests_fragments
route-actionpull_request_layout
fetch-noncev2:cad4e71d-983d-b758-2251-18f4c6171145
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idD5FE:5314B:2F85831:3ED175D:6B002B76
html-safe-nonce2aa2fac72ef16ab3cd2a9b8b97dc8deea68885fd4907c82f491771cc32674d94
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJENUZFOjUzMTRCOjJGODU4MzE6M0VEMTc1RDo2QjAwMkI3NiIsInZpc2l0b3JfaWQiOiI5MTEzNzg0MTg3MTU1OTE3Njg3IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac8a40ace4563e2d068efa43e5e9e7590534c644d62136c0f14ebe07f771acd17c
hovercard-subject-tagpull_request:3568556163
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///voltron/pull_requests_fragments/pull_request_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/voltron/pull_requests/show/python/mypy/21292/pull_request_layout
twitter:imagehttps://opengraph.githubassets.com/e3be0f4bb03460c572b4adadd8d8b1a96ed9bdc6981bbdb1e9faedba6dce0493/python/mypy/pull/21292
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/e3be0f4bb03460c572b4adadd8d8b1a96ed9bdc6981bbdb1e9faedba6dce0493/python/mypy/pull/21292
og:image:altSQLite writes can become a major bottleneck for parallel runs, since only one write can be active at any time. Sharding helps a lot and was pretty easy to implement and reason about. We need to be ...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernameJukkaL
hostnamegithub.com
expected-hostnamegithub.com
None7d0829bbde9e48b2486cb5dd6d147896eb01d32134627091f818958a935ef3f0
turbo-cache-controlno-cache
go-importgithub.com/python/mypy git https://github.com/python/mypy.git
octolytics-dimension-user_id1525981
octolytics-dimension-user_loginpython
octolytics-dimension-repository_id7053637
octolytics-dimension-repository_nwopython/mypy
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id7053637
octolytics-dimension-repository_network_root_nwopython/mypy
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
releasef3f3a43ca095cdea3abbb394112e971f9fdb94fa
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-namepull-requests

Links:

Skip to contenthttps://github.com/python/mypy/pull/21292#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fmypy%2Fpull%2F21292
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
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
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://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/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fmypy%2Fpull%2F21292
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=python%2Fmypy
Reloadhttps://github.com/python/mypy/pull/21292
Reloadhttps://github.com/python/mypy/pull/21292
Reloadhttps://github.com/python/mypy/pull/21292
pythonhttps://github.com/python
mypyhttps://github.com/python/mypy
Codehttps://github.com/python/mypy
Issues2.7k (2.7k)https://github.com/python/mypy/issues
Pull requests547 (547)https://github.com/python/mypy/pulls
Actionshttps://github.com/python/mypy/actions
Projectshttps://github.com/python/mypy/projects
Wikihttps://github.com/python/mypy/wiki
Security and qualityhttps://github.com/python/mypy/security
Insightshttps://github.com/python/mypy/insights
https://github.com/python/mypy
JukkaLhttps://github.com/JukkaL
masterhttps://github.com/python/mypy/tree/master
sqlite-shardinghttps://github.com/python/mypy/tree/sqlite-sharding
Conversationhttps://github.com/python/mypy/pull/21292
Commits17 (17)https://github.com/python/mypy/pull/21292/commits
Checkshttps://github.com/python/mypy/pull/21292/checks
Files changedhttps://github.com/python/mypy/pull/21292/files
Use sharding for sqlite cache (16 shards)https://github.com/python/mypy/pull/21292#top
JukkaLhttps://github.com/JukkaL
masterhttps://github.com/python/mypy/tree/master
sqlite-shardinghttps://github.com/python/mypy/tree/sqlite-sharding
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
Apr 22, 2026https://github.com/python/mypy/pull/21292#issue-4310591014
#21215https://github.com/python/mypy/issues/21215
Please reload this pagehttps://github.com/python/mypy/pull/21292
JukkaLhttps://github.com/JukkaL
April 22, 2026 15:13https://github.com/python/mypy/pull/21292#commits-pushed-dc48791
https://github.com/JukkaL
WIP shard sqlite cachehttps://github.com/python/mypy/pull/21292/commits/dc487914a11b648533aaddd6243aab80df929781
dc48791https://github.com/python/mypy/pull/21292/commits/dc487914a11b648533aaddd6243aab80df929781
https://github.com/JukkaL
Fix missing commithttps://github.com/python/mypy/pull/21292/commits/93bbeb9b06efa1ea5a534d6c195fb39d671e08a9
93bbeb9https://github.com/python/mypy/pull/21292/commits/93bbeb9b06efa1ea5a534d6c195fb39d671e08a9
https://github.com/JukkaL
WIP use autocommithttps://github.com/python/mypy/pull/21292/commits/494c8adbe59688bb9610b88a198a0ec726f5fdfe
494c8adhttps://github.com/python/mypy/pull/21292/commits/494c8adbe59688bb9610b88a198a0ec726f5fdfe
https://github.com/JukkaL
Strip extensionhttps://github.com/python/mypy/pull/21292/commits/fbcea0e0e3f7e9839451d1d9d322cfba6a850257
fbcea0ehttps://github.com/python/mypy/pull/21292/commits/fbcea0e0e3f7e9839451d1d9d322cfba6a850257
https://github.com/JukkaL
One commit per module (instead of per insertion, or per SCC)https://github.com/python/mypy/pull/21292/commits/c176f29dd63a5c3c4cd26c9054580cd6185e8727
c176f29https://github.com/python/mypy/pull/21292/commits/c176f29dd63a5c3c4cd26c9054580cd6185e8727
https://github.com/JukkaL
Fix sharding issuehttps://github.com/python/mypy/pull/21292/commits/0bbb7ed988991fadddcc1ffe2cc3a348359843c0
0bbb7edhttps://github.com/python/mypy/pull/21292/commits/0bbb7ed988991fadddcc1ffe2cc3a348359843c0
https://github.com/JukkaL
Use a mypyc optimized hashing algorithmhttps://github.com/python/mypy/pull/21292/commits/13ba5622db241ec4ce2d35e18a6f7ed9f1ba0442
13ba562https://github.com/python/mypy/pull/21292/commits/13ba5622db241ec4ce2d35e18a6f7ed9f1ba0442
https://github.com/JukkaL
Improve hash used for shardinghttps://github.com/python/mypy/pull/21292/commits/224d5bbfe202b5527eeea8bbeb34f0efd74568f2
224d5bbhttps://github.com/python/mypy/pull/21292/commits/224d5bbfe202b5527eeea8bbeb34f0efd74568f2
https://github.com/JukkaL
Default to 16 shards and make shard count configurable (hidden option)https://github.com/python/mypy/pull/21292/commits/1e45e93e3a7071bf52f3c773dc7f3f111b8a5209
1e45e93https://github.com/python/mypy/pull/21292/commits/1e45e93e3a7071bf52f3c773dc7f3f111b8a5209
https://github.com/JukkaL
Refactor a bithttps://github.com/python/mypy/pull/21292/commits/a2aa9e8906fe526bdda9ac716fbb63fe9b57e1ca
a2aa9e8https://github.com/python/mypy/pull/21292/commits/a2aa9e8906fe526bdda9ac716fbb63fe9b57e1ca
https://github.com/JukkaL
Fixhttps://github.com/python/mypy/pull/21292/commits/76602c31c9c2c70934cbc01fe379d99ebbd2a3e8
76602c3https://github.com/python/mypy/pull/21292/commits/76602c31c9c2c70934cbc01fe379d99ebbd2a3e8
https://github.com/JukkaL
Fixhttps://github.com/python/mypy/pull/21292/commits/4c40915117f30e75b16c466b42e301ad49ccc894
4c40915https://github.com/python/mypy/pull/21292/commits/4c40915117f30e75b16c466b42e301ad49ccc894
https://github.com/JukkaL
Polishhttps://github.com/python/mypy/pull/21292/commits/3d76f07bf143f115abc9a0ff870412fe2f122008
3d76f07https://github.com/python/mypy/pull/21292/commits/3d76f07bf143f115abc9a0ff870412fe2f122008
https://github.com/JukkaL
Use final constant for shard counthttps://github.com/python/mypy/pull/21292/commits/171d8ac50a6035a13714f8f0228e608a62c50ea0
171d8achttps://github.com/python/mypy/pull/21292/commits/171d8ac50a6035a13714f8f0228e608a62c50ea0
https://github.com/JukkaL
Update cache diff scriptshttps://github.com/python/mypy/pull/21292/commits/0ce0136bdf955ece29a622f04f88cbe071390be9
0ce0136https://github.com/python/mypy/pull/21292/commits/0ce0136bdf955ece29a622f04f88cbe071390be9
https://github.com/JukkaL
Fix testhttps://github.com/python/mypy/pull/21292/commits/81170c0e4b3e7f16359355258c0454924e16c034
81170c0https://github.com/python/mypy/pull/21292/commits/81170c0e4b3e7f16359355258c0454924e16c034
https://github.com/JukkaL
Update convert-cache.pyhttps://github.com/python/mypy/pull/21292/commits/65f2cb95d69d8d0cddeedad6410fb81e5098ad74
65f2cb9https://github.com/python/mypy/pull/21292/commits/65f2cb95d69d8d0cddeedad6410fb81e5098ad74
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
ilevkivskyihttps://github.com/ilevkivskyi
April 22, 2026 17:01https://github.com/python/mypy/pull/21292#event-24764794994
https://github.com/apps/github-actions
github-actionshttps://github.com/apps/github-actions
Apr 22, 2026https://github.com/python/mypy/pull/21292#issuecomment-4298482212
mypy_primerhttps://github.com/hauntsaninja/mypy_primer
Please reload this pagehttps://github.com/python/mypy/pull/21292
https://github.com/ilevkivskyi
ilevkivskyihttps://github.com/ilevkivskyi
Apr 22, 2026 https://github.com/python/mypy/pull/21292#pullrequestreview-4156680774
View reviewed changes https://github.com/python/mypy/pull/21292/files/65f2cb95d69d8d0cddeedad6410fb81e5098ad74
ilevkivskyihttps://github.com/ilevkivskyi
https://github.com/python/mypy/pull/21292#pullrequestreview-4156680774
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
mypy/build.pyhttps://github.com/python/mypy/pull/21292/files/65f2cb95d69d8d0cddeedad6410fb81e5098ad74#diff-ea1209369af1f6691068ac958d46d42ed5ab3a6d1529f63d891ca9cab58e3998
ilevkivskyihttps://github.com/ilevkivskyi
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3125778634
Please reload this pagehttps://github.com/python/mypy/pull/21292
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
JukkaLhttps://github.com/JukkaL
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3125994656
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
ilevkivskyihttps://github.com/ilevkivskyi
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3126933011
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
https://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.isolation_levelhttps://docs.python.org/3/library/sqlite3.html#sqlite3.Connection.isolation_level
@hauntsaninjahttps://github.com/hauntsaninja
Please reload this pagehttps://github.com/python/mypy/pull/21292
ilevkivskyihttps://github.com/ilevkivskyi
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3127021241
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
hauntsaninjahttps://github.com/hauntsaninja
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3127123711
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
JukkaLhttps://github.com/JukkaL
Apr 23, 2026https://github.com/python/mypy/pull/21292#discussion_r3129641164
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
ilevkivskyihttps://github.com/ilevkivskyi
Apr 23, 2026https://github.com/python/mypy/pull/21292#discussion_r3129703312
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
mypy/util.pyhttps://github.com/python/mypy/pull/21292/files/65f2cb95d69d8d0cddeedad6410fb81e5098ad74#diff-c5edcfc3c53fb5caee266e3df073504e99c876a4de33367d71591cc205ecf0ec
ilevkivskyihttps://github.com/ilevkivskyi
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3125788276
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
JukkaLhttps://github.com/JukkaL
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3125977071
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
ilevkivskyihttps://github.com/ilevkivskyi
Apr 22, 2026https://github.com/python/mypy/pull/21292#discussion_r3126871784
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/python/mypy/pull/21292
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
Apr 22, 2026https://github.com/python/mypy/pull/21292#issuecomment-4298786739
Please reload this pagehttps://github.com/python/mypy/pull/21292
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
Apr 22, 2026https://github.com/python/mypy/pull/21292#event-24767118917
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
Apr 23, 2026https://github.com/python/mypy/pull/21292#issuecomment-4303734848
Please reload this pagehttps://github.com/python/mypy/pull/21292
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
ee9c9e1https://github.com/python/mypy/commit/ee9c9e1ac9a805952949173677b8695ef70856c4
Apr 23, 2026https://github.com/python/mypy/pull/21292#event-24792263527
Please reload this pagehttps://github.com/python/mypy/pull/21292
https://github.com/JukkaL
JukkaLhttps://github.com/JukkaL
April 23, 2026 10:44https://github.com/python/mypy/pull/21292#event-24792264512
https://github.com/cburroughs
cburroughshttps://github.com/cburroughs
May 14, 2026 https://github.com/python/mypy/pull/21292#ref-issue-4448636261
evaluate options for reacting to new mypy db sharding options pantsbuild/pants#23352 https://github.com/pantsbuild/pants/issues/23352
https://github.co/hiddenchars
https://github.com/python/mypy/pull/{{ revealButtonHref }}
Sign up for freehttps://github.com/join?source=comment-repo
Sign in to commenthttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fmypy%2Fpull%2F21292
https://github.com/ilevkivskyi
ilevkivskyi https://github.com/ilevkivskyi
https://github.com/python/mypy/pull/21292/files/65f2cb95d69d8d0cddeedad6410fb81e5098ad74
https://github.com/hauntsaninja
hauntsaninja https://github.com/hauntsaninja
https://github.com/python/mypy/pull/21292/files/65f2cb95d69d8d0cddeedad6410fb81e5098ad74
Please reload this pagehttps://github.com/python/mypy/pull/21292
Please reload this pagehttps://github.com/python/mypy/pull/21292
https://github.com/JukkaL
https://github.com/ilevkivskyi
https://github.com/hauntsaninja
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.