René's URL Explorer Experiment


Title: feat(analyzer): Cache query analysis by kyleconroy · Pull Request #2889 · sqlc-dev/sqlc · GitHub

Open Graph Title: feat(analyzer): Cache query analysis by kyleconroy · Pull Request #2889 · sqlc-dev/sqlc

X Title: feat(analyzer): Cache query analysis by kyleconroy · Pull Request #2889 · sqlc-dev/sqlc

Description: When using managed databases, cache the query analysis if the query, schema and configuration file hasn't change. Also take into account the version of sqlc. Analysis can only be cached for managed databases as we can't know if a connected database has been changed.

Open Graph Description: When using managed databases, cache the query analysis if the query, schema and configuration file hasn't change. Also take into account the version of sqlc. Analysis can only be cached for man...

X Description: When using managed databases, cache the query analysis if the query, schema and configuration file hasn't change. Also take into account the version of sqlc. Analysis can only be cached for...

Opengraph URL: https://github.com/sqlc-dev/sqlc/pull/2889

X: @github

direct link

Domain: github.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:510b1c35-89b0-0178-ca46-ffaab5ca9da0
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idE34C:93CC4:99330A:D327EB:6A508852
html-safe-noncefb1dac9a95830e994ed59d75bf2979a331f3a7e55d893c4859a42251f3522f40
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFMzRDOjkzQ0M0Ojk5MzMwQTpEMzI3RUI6NkE1MDg4NTIiLCJ2aXNpdG9yX2lkIjoiNTk2NjgzMzEyNjQ4NzM5NDM4NiIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacaca5542dc4d25c82c51f6107c1643667820184e214521d8ef62ed744eaafaca0
hovercard-subject-tagpull_request:1565706015
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/sqlc-dev/sqlc/pull/2889/files
twitter:imagehttps://avatars.githubusercontent.com/u/34893?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/34893?s=400&v=4
og:image:altWhen using managed databases, cache the query analysis if the query, schema and configuration file hasn't change. Also take into account the version of sqlc. Analysis can only be cached for man...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noned6dc8294eb500fa36bbc57472d61fe87c522f9c3c1d64f70f4926f66a66a7efb
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/sqlc-dev/sqlc git https://github.com/sqlc-dev/sqlc.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id193160679
octolytics-dimension-repository_nwosqlc-dev/sqlc
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id193160679
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc
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
release7ac0ad2f2c7e4b9056617355fd9e33e22b0c8df9
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/sqlc-dev/sqlc/pull/2889/files#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fpull%2F2889%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub Copilot appDirect agents from issue to mergehttps://github.com/features/ai/github-app
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
View all resourceshttps://github.com/resources
GitHub SponsorsFund open source developershttps://github.com/open-source/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/open-source/accelerator
GitHub Starshttps://stars.github.com
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/enterprise/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%2Fsqlc-dev%2Fsqlc%2Fpull%2F2889%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=sqlc-dev%2Fsqlc
Reloadhttps://github.com/sqlc-dev/sqlc/pull/2889/files
Reloadhttps://github.com/sqlc-dev/sqlc/pull/2889/files
Reloadhttps://github.com/sqlc-dev/sqlc/pull/2889/files
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
sqlc-dev https://github.com/sqlc-dev
sqlchttps://github.com/sqlc-dev/sqlc
Notifications https://github.com/login?return_to=%2Fsqlc-dev%2Fsqlc
Fork 1.1k https://github.com/login?return_to=%2Fsqlc-dev%2Fsqlc
Star 18k https://github.com/login?return_to=%2Fsqlc-dev%2Fsqlc
Code https://github.com/sqlc-dev/sqlc
Issues 597 https://github.com/sqlc-dev/sqlc/issues
Pull requests 106 https://github.com/sqlc-dev/sqlc/pulls
Discussions https://github.com/sqlc-dev/sqlc/discussions
Actions https://github.com/sqlc-dev/sqlc/actions
Projects https://github.com/sqlc-dev/sqlc/projects
Security and quality 0 https://github.com/sqlc-dev/sqlc/security
Insights https://github.com/sqlc-dev/sqlc/pulse
Code https://github.com/sqlc-dev/sqlc
Issues https://github.com/sqlc-dev/sqlc/issues
Pull requests https://github.com/sqlc-dev/sqlc/pulls
Discussions https://github.com/sqlc-dev/sqlc/discussions
Actions https://github.com/sqlc-dev/sqlc/actions
Projects https://github.com/sqlc-dev/sqlc/projects
Security and quality https://github.com/sqlc-dev/sqlc/security
Insights https://github.com/sqlc-dev/sqlc/pulse
Sign up for GitHub https://github.com/signup?return_to=%2Fsqlc-dev%2Fsqlc%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fsqlc-dev%2Fsqlc%2Fissues%2Fnew%2Fchoose
kyleconroyhttps://github.com/kyleconroy
mainhttps://github.com/sqlc-dev/sqlc/tree/main
kyle/analyzer-cachehttps://github.com/sqlc-dev/sqlc/tree/kyle/analyzer-cache
Conversation 13 https://github.com/sqlc-dev/sqlc/pull/2889
Commits 4 https://github.com/sqlc-dev/sqlc/pull/2889/commits
Checks 0 https://github.com/sqlc-dev/sqlc/pull/2889/checks
Files changed https://github.com/sqlc-dev/sqlc/pull/2889/files
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
feat(analyzer): Cache query analysis https://github.com/sqlc-dev/sqlc/pull/2889/files#top
Show all changes 4 commits https://github.com/sqlc-dev/sqlc/pull/2889/files
32996a2 feat(analyzer): Cache query analysis kyleconroy Oct 19, 2023 https://github.com/sqlc-dev/sqlc/pull/2889/commits/32996a2f381b3c38051e39c8836273807f960494
9e8e89f Fix buf lint kyleconroy Oct 19, 2023 https://github.com/sqlc-dev/sqlc/pull/2889/commits/9e8e89f5d5b2856b73c6064afd9769399baad45d
ea2001b Address comments kyleconroy Oct 20, 2023 https://github.com/sqlc-dev/sqlc/pull/2889/commits/ea2001bdc589cc3c3d4dfea7cc2ed92ab875865c
16670c9 Fix additional comments kyleconroy Oct 20, 2023 https://github.com/sqlc-dev/sqlc/pull/2889/commits/16670c9183e348ee148703c9c3c32f4b85692ba2
Clear filters https://github.com/sqlc-dev/sqlc/pull/2889/files
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
analysis.pb.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-5ac9d639364079a8aabfc7b72a8ee3a906982cddae99664031289e87ef9af690
analysis_vtproto.pb.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-18258737d687fd9e3de04e1d1ccac2d7721f158ca950f8b74a2010400468ec40
analyzer.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b126d19c61b7249f14710696139d71e966aa643a9a363ad19e639e14cef6e41e
cache.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-113f0a3ddf486bd0f7ee93e06851fe642139355ce485bd7acd848729688962b2
analyze.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
engine.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-f370f4d820650f0d390e264f17247d7cf0741bba26851e2bd884075b66c60ff3
parse.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-6a800d9fb933dd05d4cfafe491c9a97f6caa7e5878098d4ab642860954d08ceb
analyze.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
wasm.go https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-23754f582b1b59bc3e57a4226f80c663d3491a7cc96ab6606adf9f52268d20dc
analysis.proto https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-bd0dc0d970f0ab3055c7b0c06a3d95d2e069f84e83932e460b867614077b0e7b
internal/analysis/analysis.pb.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-5ac9d639364079a8aabfc7b72a8ee3a906982cddae99664031289e87ef9af690
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/analysis/analysis.pb.go
Open in desktop https://desktop.github.com
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
internal/analysis/analysis_vtproto.pb.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-18258737d687fd9e3de04e1d1ccac2d7721f158ca950f8b74a2010400468ec40
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/analysis/analysis_vtproto.pb.go
Open in desktop https://desktop.github.com
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
internal/analyzer/analyzer.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b126d19c61b7249f14710696139d71e966aa643a9a363ad19e639e14cef6e41e
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/analyzer/analyzer.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/sqlc-dev/sqlc/pull/2889/{{ revealButtonHref }}
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b126d19c61b7249f14710696139d71e966aa643a9a363ad19e639e14cef6e41e
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
internal/cache/cache.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-113f0a3ddf486bd0f7ee93e06851fe642139355ce485bd7acd848729688962b2
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/cache/cache.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/sqlc-dev/sqlc/pull/2889/{{ revealButtonHref }}
internal/compiler/analyze.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/compiler/analyze.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/sqlc-dev/sqlc/pull/2889/{{ revealButtonHref }}
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-7f656a6efa542b1c8968e5dafa70f35f10cad66da4b7e1e43968c91654b33e9a
internal/compiler/engine.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-f370f4d820650f0d390e264f17247d7cf0741bba26851e2bd884075b66c60ff3
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/compiler/engine.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/sqlc-dev/sqlc/pull/2889/{{ revealButtonHref }}
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-f370f4d820650f0d390e264f17247d7cf0741bba26851e2bd884075b66c60ff3
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-f370f4d820650f0d390e264f17247d7cf0741bba26851e2bd884075b66c60ff3
internal/compiler/parse.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-6a800d9fb933dd05d4cfafe491c9a97f6caa7e5878098d4ab642860954d08ceb
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/compiler/parse.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/sqlc-dev/sqlc/pull/2889/{{ revealButtonHref }}
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-6a800d9fb933dd05d4cfafe491c9a97f6caa7e5878098d4ab642860954d08ceb
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-6a800d9fb933dd05d4cfafe491c9a97f6caa7e5878098d4ab642860954d08ceb
internal/engine/postgresql/analyzer/analyze.gohttps://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
View file https://github.com/sqlc-dev/sqlc/blob/16670c9183e348ee148703c9c3c32f4b85692ba2/internal/engine/postgresql/analyzer/analyze.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/sqlc-dev/sqlc/pull/2889/{{ revealButtonHref }}
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
https://github.com/sqlc-dev/sqlc/pull/2889/files#diff-b63e33e4a0f2f5909579da6bf50f7ba06f86698aace52319d5c24620e6564148
Please reload this pagehttps://github.com/sqlc-dev/sqlc/pull/2889/files
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.