| react-profiling | 0 |
| react-import-map | react,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/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:8482c59c-ba63-deca-46d8-bc3223e372a4 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 9E64:3B07B3:9B2CB9:C275FA:6B021B32 |
| html-safe-nonce | 406534d42dcf7792302d21146c181053313188c95dc6ab3fd3a659d80a12dda6 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5RTY0OjNCMDdCMzo5QjJDQjk6QzI3NUZBOjZCMDIxQjMyIiwidmlzaXRvcl9pZCI6IjY1ODY0MDk0OTY0MTM4NzA4OTgiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | 96e43bd88b6b9f603dab7ad79149202811d17f294ad002fb9fa5a4582fb910d7 |
| hovercard-subject-tag | issue:1345982684 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | ///voltron/issues_fragments/issue_layout |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/python/cpython/96165/issue_layout |
| twitter:image | https://opengraph.githubassets.com/edbb1664bedd098bcdae4ab4fffb0214faa2e9eefcffa65d57c76b9b07dd65bc/python/cpython/issues/96165 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/edbb1664bedd098bcdae4ab4fffb0214faa2e9eefcffa65d57c76b9b07dd65bc/python/cpython/issues/96165 |
| og:image:alt | Some examples use the following SQL trick: # setup code; we only need a "dummy" connection import sqlite3 cx = sqlite3.connect(":memory:") # returns one row with one column: ("a",) row = cx.execute... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | erlend-aasland |
| hostname | github.com |
| expected-hostname | github.com |
| None | 87e774ee7c6b3bee0490394e4d3e57ec9dbc956f74b87ea685dc8996c1676456 |
| turbo-cache-control | no-preview |
| go-import | github.com/python/cpython git https://github.com/python/cpython.git |
| octolytics-dimension-user_id | 1525981 |
| octolytics-dimension-user_login | python |
| octolytics-dimension-repository_id | 81598961 |
| octolytics-dimension-repository_nwo | python/cpython |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 81598961 |
| octolytics-dimension-repository_network_root_nwo | python/cpython |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 423dbb54c5e7bfecc838eb387c1435eb3d0e760d |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
| Skip to content | https://github.com/python/cpython/issues/96165#start-of-content |
| https://github.com/ |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fissues%2F96165 |
| GitHubRepository hosting, code review, and collaboration | https://github.com/platform |
| CopilotAI coding agent for tasks, projects, and automated work | https://github.com/features/copilot |
| ActionsCI/CD and automation | https://github.com/features/actions |
| Code QualityQuality analysis, fixes, and enforcement | https://github.com/features/code-quality |
| CodespacesCloud development environments | https://github.com/features/codespaces |
| Code SecurityVulnerability detection and remediation | https://github.com/security/advanced-security/code-security |
| Secret ProtectionSecret scanning and leak prevention | https://github.com/security/advanced-security/secret-protection |
| All Features | https://github.com/features |
| Documentation | https://docs.github.com/en |
| Training | https://learn.github.com/skills |
| Certifications | https://learn.github.com/credentials |
| Build with Copilot | https://github.com/features/ai |
| Customize Copilot | https://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview |
| Integrations | https://github.com/marketplace |
| Trending repos | https://github.com/trending |
| GitHub Sponsors | https://github.com/open-source/sponsors |
| Developer articles | https://github.com/resources/articles |
| ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place. | https://github.blog/changelog/ |
| Enterprises | https://github.com/enterprise |
| Team | https://github.com/team |
| Startups | https://github.com/enterprise/startups |
| Nonprofits | https://github.com/solutions/industry/nonprofits |
| Healthcare | https://github.com/solutions/industry/healthcare |
| Financial services | https://github.com/solutions/industry/financial-services |
| Manufacturing | https://github.com/solutions/industry/manufacturing |
| Government | https://github.com/solutions/industry/government |
| See all industries | https://github.com/solutions/industry |
| Why GitHub | https://github.com/why-github |
| Customer Stories | https://github.com/customer-stories |
| Business insights | https://github.com/solutions/executive-insights |
| Trust Center | https://github.com/trust-center |
| GitHub Advanced SecurityEnterprise-grade code security | https://github.com/security/advanced-security |
| Copilot for businessEnterprise-grade AI features | https://github.com/features/copilot/copilot-business |
| Premium SupportEnterprise-grade 24/7 support | https://github.com/enterprise/premium-support |
| Documentation | https://docs.github.com/en |
| Resource center | https://github.com/resources |
| Blog | https://github.blog/ |
| Events & webinars | https://github.com/resources/events |
| Community Forum | https://github.com/orgs/community/discussions |
| Customer Stories | https://github.com/customer-stories |
| Integrations | https://github.com/marketplace |
| Customer support | https://help.github.com/ |
| Training | https://learn.github.com/skills |
| GitHub Status | https://www.githubstatus.com/ |
| About | https://github.com/about |
| Partners | https://github.com/partners |
| Changelog | https://github.blog/changelog/ |
| GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub. | https://githubuniverse.com/ |
| Pricing | https://github.com/pricing |
| Sign in | https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpython%2Fcpython%2Fissues%2F96165 |
| 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%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=python%2Fcpython |
| Reload | https://github.com/python/cpython/issues/96165 |
| Reload | https://github.com/python/cpython/issues/96165 |
| Reload | https://github.com/python/cpython/issues/96165 |
| python | https://github.com/python |
| cpython | https://github.com/python/cpython |
| Code | https://github.com/python/cpython |
| Issues5k+ (5k+) | https://github.com/python/cpython/issues |
| Pull requests2.4k (2.4k) | https://github.com/python/cpython/pulls |
| Actions | https://github.com/python/cpython/actions |
| Projects | https://github.com/python/cpython/projects |
| Security and quality | https://github.com/python/cpython/security |
| Insights | https://github.com/python/cpython/insights |
| https://github.com/python/cpython |
| New issue | https://github.com/login?return_to=https://github.com/python/cpython/issues/96165 |
| New issue | https://github.com/login?return_to=https://github.com/python/cpython/issues/96165 |
| sqlite3 docs: explain SELECT-with-literals trick | https://github.com/python/cpython/issues/96165#top |
| docsDocumentation in the Doc dir | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22docs%22 |
| topic-sqlite3 | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22topic-sqlite3%22 |
| type-featureA feature request or enhancement | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22type-feature%22 |
| https://github.com/erlend-aasland |
| erlend-aasland | https://github.com/erlend-aasland |
| on Aug 22, 2022 | https://github.com/python/cpython/issues/96165#issue-1345982684 |
| @erlend-aasland | https://github.com/erlend-aasland |
| #96122 (comment) | https://github.com/python/cpython/pull/96122#discussion_r951115951 |
| gh-96165: Clarify passing ":memory:" in sqlite3.connect(). #106451 | https://github.com/python/cpython/pull/106451 |
| gh-96165: Clarify omitting the FROM clause in SQLite queries. #106513 | https://github.com/python/cpython/pull/106513 |
| [3.12] gh-96165: Clarify omitting the FROM clause in SQLite queries (GH-106513) #106645 | https://github.com/python/cpython/pull/106645 |
| [3.11] gh-96165: Clarify omitting the FROM clause in SQLite queries (GH-106513) #106646 | https://github.com/python/cpython/pull/106646 |
| [3.12] gh-96165: Clarify passing ":memory:" in sqlite3.connect() (GH-106451) #106647 | https://github.com/python/cpython/pull/106647 |
| [3.11] gh-96165: Clarify passing ":memory:" in sqlite3.connect() (GH-106451) #106648 | https://github.com/python/cpython/pull/106648 |
| erlend-aasland | https://github.com/erlend-aasland |
| type-featureA feature request or enhancement | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22type-feature%22 |
| docsDocumentation in the Doc dir | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22docs%22 |
| topic-sqlite3 | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22topic-sqlite3%22 |
| on Aug 22, 2022 | https://github.com/python/cpython/issues/96165#event-7230333677 |
| erlend-aasland | https://github.com/erlend-aasland |
| sqlite3 issues | https://github.com/orgs/python/projects/23 |
| on Aug 22, 2022 | https://github.com/python/cpython/issues/96165#event-15231236873 |
| https://github.com/erlend-aasland |
| erlend-aasland | https://github.com/erlend-aasland |
| on Aug 22, 2022 | https://github.com/python/cpython/issues/96165#issuecomment-1221992465 |
| @CAM-Gerlach | https://github.com/CAM-Gerlach |
| @ezio-melotti | https://github.com/ezio-melotti |
| https://github.com/ezio-melotti |
| ezio-melotti | https://github.com/ezio-melotti |
| on Aug 22, 2022 | https://github.com/python/cpython/issues/96165#issuecomment-1222030771 |
| https://github.com/CAM-Gerlach |
| CAM-Gerlach | https://github.com/CAM-Gerlach |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165#issuecomment-1223561806 |
| CAM-Gerlach | https://github.com/CAM-Gerlach |
| completed | https://github.com/python/cpython/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165#event-7238506260 |
| CAM-Gerlach | https://github.com/CAM-Gerlach |
| sqlite3 issues | https://github.com/orgs/python/projects/23 |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165 |
| CAM-Gerlach | https://github.com/CAM-Gerlach |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165#event-7238507830 |
| https://github.com/CAM-Gerlach |
| CAM-Gerlach | https://github.com/CAM-Gerlach |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165#issuecomment-1223575749 |
| Get the user started | https://diataxis.fr/tutorials/#get-the-user-started |
| unnecessary explaination | https://diataxis.fr/tutorials/#offer-only-minimum-necessary-explanation |
| @ezio-melotti | https://github.com/ezio-melotti |
| @ezio-melotti | https://github.com/ezio-melotti |
| https://github.com/erlend-aasland |
| erlend-aasland | https://github.com/erlend-aasland |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165#issuecomment-1223691950 |
| https://github.com/erlend-aasland |
| erlend-aasland | https://github.com/erlend-aasland |
| on Aug 23, 2022 | https://github.com/python/cpython/issues/96165#issuecomment-1223694067 |
| erlend-aasland | https://github.com/erlend-aasland |
| sqlite3 issues | https://github.com/orgs/python/projects/23 |
| on Dec 30, 2022 | https://github.com/python/cpython/issues/96165 |
| felixxm | https://github.com/felixxm |
| on Jul 5, 2023 | https://github.com/python/cpython/issues/96165#event-9730744288 |
| pythongh-96165: Clarify passing ":memory:" in sqlite3.connect(). | https://github.com/felixxm/cpython/commit/9dd799081ed809b09907cc5c30d24cadfa0158b0 |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| 9dd7990 | https://github.com/felixxm/cpython/commit/9dd799081ed809b09907cc5c30d24cadfa0158b0 |
| pythongh-96165: Clarify omitting the FROM clause in SQLite queries. | https://github.com/felixxm/cpython/commit/cdc98692c180c6c4d559659fa2895ace05408203 |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| cdc9869 | https://github.com/felixxm/cpython/commit/cdc98692c180c6c4d559659fa2895ace05408203 |
| pythongh-96165: Clarify omitting the FROM clause in SQLite queries. | https://github.com/felixxm/cpython/commit/182c3a3b45a37cd7d668ca65d884ec1fe28717b2 |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| 182c3a3 | https://github.com/felixxm/cpython/commit/182c3a3b45a37cd7d668ca65d884ec1fe28717b2 |
| erlend-aasland | https://github.com/erlend-aasland |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#event-9791831891 |
| gh-96165: Clarify omitting the FROM clause in SQLite queries (#106513) | https://github.com/python/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598 |
| gh-96165 | https://github.com/python/cpython/issues/96165 |
| #106513 | https://github.com/python/cpython/pull/106513 |
| fc7ff1a | https://github.com/python/cpython/commit/fc7ff1af457e27b7d9752600b3436641be90f598 |
| miss-islington | https://github.com/miss-islington |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#event-9791837340 |
| pythongh-96165: Clarify omitting the FROM clause in SQLite queries (p… | https://github.com/miss-islington/cpython/commit/8c80fd15409614fee524e43b65a767b6c1f2352e |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| p… | https://github.com/python/cpython/pull/106513 |
| 8c80fd1 | https://github.com/miss-islington/cpython/commit/8c80fd15409614fee524e43b65a767b6c1f2352e |
| pythongh-96165: Clarify omitting the FROM clause in SQLite queries (p… | https://github.com/miss-islington/cpython/commit/5bcfc155d008f5e235cae3338ec1173e78e6b40c |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| p… | https://github.com/python/cpython/pull/106513 |
| 5bcfc15 | https://github.com/miss-islington/cpython/commit/5bcfc155d008f5e235cae3338ec1173e78e6b40c |
| erlend-aasland | https://github.com/erlend-aasland |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#event-9791906347 |
| gh-96165: Clarify passing ":memory:" in sqlite3.connect() (#106451) | https://github.com/python/cpython/commit/f520804b039df0d87fb9df6f1fed2a9bc9df8d61 |
| gh-96165 | https://github.com/python/cpython/issues/96165 |
| #106451 | https://github.com/python/cpython/pull/106451 |
| f520804 | https://github.com/python/cpython/commit/f520804b039df0d87fb9df6f1fed2a9bc9df8d61 |
| miss-islington | https://github.com/miss-islington |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#event-9791907223 |
| pythongh-96165: Clarify passing ":memory:" in sqlite3.connect() (pyth… | https://github.com/miss-islington/cpython/commit/2205c4b6f78686b79023a9811f904db525b5dd04 |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| pyth… | https://github.com/python/cpython/pull/106451 |
| 2205c4b | https://github.com/miss-islington/cpython/commit/2205c4b6f78686b79023a9811f904db525b5dd04 |
| pythongh-96165: Clarify passing ":memory:" in sqlite3.connect() (pyth… | https://github.com/miss-islington/cpython/commit/0d1d572b429ccead4b7263d80c362bc80e7954da |
| pythongh-96165 | https://github.com/python/cpython/issues/96165 |
| pyth… | https://github.com/python/cpython/pull/106451 |
| 0d1d572 | https://github.com/miss-islington/cpython/commit/0d1d572b429ccead4b7263d80c362bc80e7954da |
| erlend-aasland | https://github.com/erlend-aasland |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#event-9792001495 |
| [3.11] gh-96165: Clarify omitting the FROM clause in SQLite queries (G… | https://github.com/python/cpython/commit/6d8662381d73982f53d3cc71bf435aa82def8eab |
| gh-96165 | https://github.com/python/cpython/issues/96165 |
| G… | https://github.com/python/cpython/pull/106513 |
| 6d86623 | https://github.com/python/cpython/commit/6d8662381d73982f53d3cc71bf435aa82def8eab |
| [3.12] gh-96165: Clarify omitting the FROM clause in SQLite queries (G… | https://github.com/python/cpython/commit/bf7e92583dd33aa7e83d5929f2138c5d6957f571 |
| gh-96165 | https://github.com/python/cpython/issues/96165 |
| G… | https://github.com/python/cpython/pull/106513 |
| bf7e925 | https://github.com/python/cpython/commit/bf7e92583dd33aa7e83d5929f2138c5d6957f571 |
| [3.12] gh-96165: Clarify passing ":memory:" in sqlite3.connect() (GH-… | https://github.com/python/cpython/commit/e248ba7b72adad794399d7b55116862fa31471fd |
| gh-96165 | https://github.com/python/cpython/issues/96165 |
| GH-… | https://github.com/python/cpython/pull/106451 |
| e248ba7 | https://github.com/python/cpython/commit/e248ba7b72adad794399d7b55116862fa31471fd |
| [3.11] gh-96165: Clarify passing ":memory:" in sqlite3.connect() (GH-… | https://github.com/python/cpython/commit/247f0500b88bb881f563792c7db535e91259b90c |
| gh-96165 | https://github.com/python/cpython/issues/96165 |
| GH-… | https://github.com/python/cpython/pull/106451 |
| 247f050 | https://github.com/python/cpython/commit/247f0500b88bb881f563792c7db535e91259b90c |
| https://github.com/erlend-aasland |
| erlend-aasland | https://github.com/erlend-aasland |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#issuecomment-1631472641 |
| @felixxm | https://github.com/felixxm |
| erlend-aasland | https://github.com/erlend-aasland |
| completed | https://github.com/python/cpython/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165#event-9792023767 |
| github-project-automation | https://github.com/apps/github-project-automation |
| sqlite3 issues | https://github.com/orgs/python/projects/23 |
| on Jul 11, 2023 | https://github.com/python/cpython/issues/96165 |
| Sign up for free | https://github.com/signup?return_to=https://github.com/python/cpython/issues/96165 |
| Sign in to comment | https://github.com/login?return_to=https://github.com/python/cpython/issues/96165 |
| docsDocumentation in the Doc dir | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22docs%22 |
| topic-sqlite3 | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22topic-sqlite3%22 |
| type-featureA feature request or enhancement | https://github.com/python/cpython/issues?q=state%3Aopen%20label%3A%22type-feature%22 |
| sqlite3 issues | https://github.com/orgs/python/projects/23 |
|
| https://github.com |
| Terms | https://docs.github.com/site-policy/github-terms/github-terms-of-service |
| Privacy | https://docs.github.com/site-policy/privacy-policies/github-privacy-statement |
| Security | https://github.com/security |
| Status | https://www.githubstatus.com/ |
| Community | https://github.community/ |
| Docs | https://docs.github.com/ |
| Contact | https://support.github.com?tags=dotcom-footer |