René's URL Explorer Experiment


Title: Sqlite: better queries by bhansconnect · Pull Request #302 · roc-lang/basic-cli · GitHub

Open Graph Title: Sqlite: better queries by bhansconnect · Pull Request #302 · roc-lang/basic-cli

X Title: Sqlite: better queries by bhansconnect · Pull Request #302 · roc-lang/basic-cli

Description: A basic Command-Line Interface platform. Contribute to roc-lang/basic-cli development by creating an account on GitHub.

Open Graph Description: The better query ideas from https://roc.zulipchat.com/#narrow/channel/383402-API-design/topic/Sqlite.20APIs main! = \_args -> db_path = try Env.var! "DB_PATH" query_todos_by_s...

X Description: The better query ideas from https://roc.zulipchat.com/#narrow/channel/383402-API-design/topic/Sqlite.20APIs main! = \_args -> db_path = try Env.var! "DB_PATH" quer...

Opengraph URL: https://github.com/roc-lang/basic-cli/pull/302

X: @github

direct link

Domain: github.com

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:9da8406d-584d-a71f-c786-35a0c7c15a82
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idCDF6:E4031:37240E:4FFE81:6A4D0D0B
html-safe-nonceceaf1126acf5ac3e9247d20d069a65c70f720bbcff983ec8befafcee30fe1aa3
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDREY2OkU0MDMxOjM3MjQwRTo0RkZFODE6NkE0RDBEMEIiLCJ2aXNpdG9yX2lkIjoiODQwNTA3ODYzNDQyNzkxMTQzNSIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmacebd74ba47d28817a5054c10f1ba6f713d4e0f8bf5416f34acebdc0eb3b0731e1
hovercard-subject-tagpull_request:2258610749
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/roc-lang/basic-cli/302/pull_request_layout
twitter:imagehttps://opengraph.githubassets.com/ec78097a5f82e7bee196757149214d016ac42a7835f172bf9ef16886cbfb5519/roc-lang/basic-cli/pull/302
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/ec78097a5f82e7bee196757149214d016ac42a7835f172bf9ef16886cbfb5519/roc-lang/basic-cli/pull/302
og:image:altThe better query ideas from https://roc.zulipchat.com/#narrow/channel/383402-API-design/topic/Sqlite.20APIs main! = \_args -> db_path = try Env.var! "DB_PATH" query_todos_by_s...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamebhansconnect
hostnamegithub.com
expected-hostnamegithub.com
Nonebcb4661e6fb4fe8b394c51ea02ccdb2236d40dc59afc75a3bbba50bf6517134c
turbo-cache-controlno-cache
go-importgithub.com/roc-lang/basic-cli git https://github.com/roc-lang/basic-cli.git
octolytics-dimension-user_id63474338
octolytics-dimension-user_loginroc-lang
octolytics-dimension-repository_id570963058
octolytics-dimension-repository_nworoc-lang/basic-cli
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id570963058
octolytics-dimension-repository_network_root_nworoc-lang/basic-cli
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
releasefb70bd3c4b2bec429781b65419e912c66e2d5581
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/roc-lang/basic-cli/pull/302#start-of-content
https://github.com/
Sign in https://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Froc-lang%2Fbasic-cli%2Fpull%2F302
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/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/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/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%2Froc-lang%2Fbasic-cli%2Fpull%2F302
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%2Fpull_requests_fragments%2Fpull_request_layout&source=header-repo&source_repo=roc-lang%2Fbasic-cli
Reloadhttps://github.com/roc-lang/basic-cli/pull/302
Reloadhttps://github.com/roc-lang/basic-cli/pull/302
Reloadhttps://github.com/roc-lang/basic-cli/pull/302
Please reload this pagehttps://github.com/roc-lang/basic-cli/pull/302
roc-lang https://github.com/roc-lang
basic-clihttps://github.com/roc-lang/basic-cli
Notifications https://github.com/login?return_to=%2Froc-lang%2Fbasic-cli
Fork 42 https://github.com/login?return_to=%2Froc-lang%2Fbasic-cli
Star 116 https://github.com/login?return_to=%2Froc-lang%2Fbasic-cli
Code https://github.com/roc-lang/basic-cli
Issues 54 https://github.com/roc-lang/basic-cli/issues
Pull requests 9 https://github.com/roc-lang/basic-cli/pulls
Actions https://github.com/roc-lang/basic-cli/actions
Projects https://github.com/roc-lang/basic-cli/projects
Security and quality 0 https://github.com/roc-lang/basic-cli/security
Insights https://github.com/roc-lang/basic-cli/pulse
Code https://github.com/roc-lang/basic-cli
Issues https://github.com/roc-lang/basic-cli/issues
Pull requests https://github.com/roc-lang/basic-cli/pulls
Actions https://github.com/roc-lang/basic-cli/actions
Projects https://github.com/roc-lang/basic-cli/projects
Security and quality https://github.com/roc-lang/basic-cli/security
Insights https://github.com/roc-lang/basic-cli/pulse
bhansconnecthttps://github.com/bhansconnect
mainhttps://github.com/roc-lang/basic-cli/tree/main
sqlite-better-querieshttps://github.com/roc-lang/basic-cli/tree/sqlite-better-queries
Conversationhttps://github.com/roc-lang/basic-cli/pull/302
Commits4 (4)https://github.com/roc-lang/basic-cli/pull/302/commits
Checkshttps://github.com/roc-lang/basic-cli/pull/302/checks
Files changedhttps://github.com/roc-lang/basic-cli/pull/302/files
Sqlite: better querieshttps://github.com/roc-lang/basic-cli/pull/302#top
bhansconnecthttps://github.com/bhansconnect
mainhttps://github.com/roc-lang/basic-cli/tree/main
sqlite-better-querieshttps://github.com/roc-lang/basic-cli/tree/sqlite-better-queries
https://github.com/bhansconnect
bhansconnecthttps://github.com/bhansconnect
Jan 3, 2025https://github.com/roc-lang/basic-cli/pull/302#issue-2766855509
https://roc.zulipchat.com/#narrow/channel/383402-API-design/topic/Sqlite.20APIshttps://roc.zulipchat.com/#narrow/channel/383402-API-design/topic/Sqlite.20APIs
Please reload this pagehttps://github.com/roc-lang/basic-cli/pull/302
bhansconnecthttps://github.com/bhansconnect
January 2, 2025 16:54https://github.com/roc-lang/basic-cli/pull/302#commits-pushed-02a61c3
https://github.com/bhansconnect
add improved prepared querieshttps://github.com/roc-lang/basic-cli/pull/302/commits/02a61c3369969220b0b1e7ed81beafe768f6f901
02a61c3https://github.com/roc-lang/basic-cli/pull/302/commits/02a61c3369969220b0b1e7ed81beafe768f6f901
https://github.com/bhansconnect
add transaction prep and runninghttps://github.com/roc-lang/basic-cli/pull/302/commits/da7e97cef13cf6d089b6fcfc2aa817b116e8d15c
da7e97chttps://github.com/roc-lang/basic-cli/pull/302/commits/da7e97cef13cf6d089b6fcfc2aa817b116e8d15c
https://github.com/bhansconnect
bhansconnecthttps://github.com/bhansconnect
Jan 3, 2025 https://github.com/roc-lang/basic-cli/pull/302#pullrequestreview-2528467868
View reviewed changes https://github.com/roc-lang/basic-cli/pull/302/files/da7e97cef13cf6d089b6fcfc2aa817b116e8d15c
platform/Sqlite.rochttps://github.com/roc-lang/basic-cli/pull/302/files/da7e97cef13cf6d089b6fcfc2aa817b116e8d15c#diff-da205714b66f0f6d4a1d2960b608f65952f309a1830e2f2d399f68c83bbaa567
bhansconnecthttps://github.com/bhansconnect
Jan 3, 2025https://github.com/roc-lang/basic-cli/pull/302#discussion_r1901409440
Learn morehttps://docs.github.com/articles/managing-disruptive-comments/#hiding-a-comment
Please reload this pagehttps://github.com/roc-lang/basic-cli/pull/302
bhansconnecthttps://github.com/bhansconnect
January 2, 2025 17:50https://github.com/roc-lang/basic-cli/pull/302#commits-pushed-278a57e
https://github.com/bhansconnect
make types a bit nicerhttps://github.com/roc-lang/basic-cli/pull/302/commits/278a57ec804a2e30f250e641d621a4638f5b0e9a
278a57ehttps://github.com/roc-lang/basic-cli/pull/302/commits/278a57ec804a2e30f250e641d621a4638f5b0e9a
https://github.com/bhansconnect
simplify naming a bit morehttps://github.com/roc-lang/basic-cli/pull/302/commits/df278fe23568765ba40acd552057f49a69c3e84d
df278fehttps://github.com/roc-lang/basic-cli/pull/302/commits/df278fe23568765ba40acd552057f49a69c3e84d
https://github.com/gamebox
gameboxhttps://github.com/gamebox
Jan 19, 2025https://github.com/roc-lang/basic-cli/pull/302#issuecomment-2600850859
Please reload this pagehttps://github.com/roc-lang/basic-cli/pull/302
Please reload this pagehttps://github.com/roc-lang/basic-cli/pull/302
https://github.co/hiddenchars
https://github.com/roc-lang/basic-cli/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%2Froc-lang%2Fbasic-cli%2Fpull%2F302
Please reload this pagehttps://github.com/roc-lang/basic-cli/pull/302
https://github.com/bhansconnect
https://github.com/gamebox
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.