René's URL Explorer Experiment


Title: Extensibility / Plugin Support · Issue #288 · sqlc-dev/sqlc · GitHub

Open Graph Title: Extensibility / Plugin Support · Issue #288 · sqlc-dev/sqlc

X Title: Extensibility / Plugin Support · Issue #288 · sqlc-dev/sqlc

Description: Add support for calling into plugins during code generation. One specific use case I have is to support automatic encryption/decryption of columns. To illustrate, here's very naive proposal: CREATE TABLE authors ( id BIGSERIAL PRIMARY KE...

Open Graph Description: Add support for calling into plugins during code generation. One specific use case I have is to support automatic encryption/decryption of columns. To illustrate, here's very naive proposal: CREATE...

X Description: Add support for calling into plugins during code generation. One specific use case I have is to support automatic encryption/decryption of columns. To illustrate, here's very naive proposal: CR...

Opengraph URL: https://github.com/sqlc-dev/sqlc/issues/288

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Extensibility / Plugin Support","articleBody":"Add support for calling into plugins during code generation. One specific use case I have is to support automatic encryption/decryption of columns. To illustrate, here's very naive proposal:\r\n\r\n```sql\r\nCREATE TABLE authors (\r\n          id   BIGSERIAL PRIMARY KEY,\r\n          name text      NOT NULL, -- :encrypted\r\n          bio  text -- :encrypted\r\n);\r\n```\r\n\r\nAdding the `:encrypted` annotation and having the `encryption` plugin enabled would cause sqlc to augment the generated code to look like the below:\r\n\r\n```go\r\n// db.go\r\ninterface Cipher {\r\n  Encrypt(s string) (string, error)\r\n  Decrypt(s string) (string, error)\r\n}\r\n\r\nfunc New(db DBTX) *Queries {\r\n\treturn &Queries{db: db, enc: &NoopCipher{}}\r\n}\r\n\r\nfunc NewWithEncryptor(db DBTX, ciph Cipher) *Queries {\r\n\treturn &Queries{db: db, ciph: ciph}\r\n}\r\n\r\ntype Queries struct {\r\n\tdb DBTX\r\n\tciph Cipher\r\n}\r\n\r\n// query.sql.go\r\nconst createAuthor = `-- name: CreateAuthor :one\r\nINSERT INTO authors (\r\n          name, bio\r\n) VALUES (\r\n  $1, $2\r\n)\r\nRETURNING id, name, bio\r\n`\r\n\r\ntype CreateAuthorParams struct {\r\n\tName string\r\n\tBio  sql.NullString\r\n}\r\n\r\nfunc (q *Queries) CreateAuthor(ctx context.Context, arg CreateAuthorParams) (Author, error) {\r\n\tvar err error\r\n\tvar i Author\r\n\r\n\targ.Name, err = q.ciph.Encrypt(arg.Bio)\r\n\tif err != nil {\r\n\t\treturn i, err\r\n\t}\r\n\targ.Bio, err = q.ciph.Encrypt(arg.Bio)\r\n\tif err != nil {\r\n\t\treturn i, err\r\n\t}\r\n\trow := q.db.QueryRowContext(ctx, createAuthor, arg.Name, arg.Bio)\r\n\terr := row.Scan(&i.ID, &i.Name, &i.Bio)\r\n\tif err != nil {\r\n\t\treturn i, err\r\n\t}\r\n\ti.Name, err = q.ciph.Decrypt(i.Name)\r\n\tif err != nil {\r\n\t\treturn i, err\r\n\t}\r\n\ti.Bio, err = q.ciph.Decrypt(i.Bio)\r\n\tif err != nil {\r\n\t\treturn i, err\r\n\t}\r\n\r\n\treturn i, err\r\n}\r\n```\r\n\r\nThe `Cipher` is be an interface dictated by the plugin that the user would have to provide.\r\n\r\nThis proposal leaves a lot to answer and is just an example of what we can do with plugins. `sqlc` having an understanding of the schema and being able to parse annotations (comments) makes it a great place to hook into this automated code for translating. I don't think this is achievable simply with a custom type, since the `Cipher` needs to be initialized with secret key material to perform the encryption/decryption.\r\n\r\nI don't know how exactly you would do a plugin with sqlc. Maybe make it easy to create a custom build of the `sqlc` CLI, and adding support to the library for code generation hooks. Or, maybe invoking external binaries that communicate over grpc (a pattern in the Go community nowadays), but that could result in a complex protocol and you'd have to describe the AST and in-memory models in protobuf.\r\n\r\nI think this could be a really powerful feature though. Curious what your thoughts are.","author":{"url":"https://github.com/mightyguava","@type":"Person","name":"mightyguava"},"datePublished":"2020-01-22T19:32:13Z","url":"https://github.com/sqlc-dev/sqlc/issues/288"}

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/issues/show/:user_id/:repository/:id/issue_layout(.:format)
route-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:96d90b59-59da-ae67-fd83-93afac707c4d
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idC520:B1B84:1C6C45B:2419825:6B0195E2
html-safe-nonce95170c359bf4a76ea09aff50ea08753d9cbaa1cd768f6bb2438242533d60fd09
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDNTIwOkIxQjg0OjFDNkM0NUI6MjQxOTgyNTo2QjAxOTVFMiIsInZpc2l0b3JfaWQiOiI4ODQ3Mjc1ODE0MjYyMjQ4OTMwIiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmaca661ecbd11075109f3393cbef82b4c19ab25d15c0db23f25c660cd16c66edcc2
hovercard-subject-tagissue:553747752
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlc-dev/sqlc/288/issue_layout
twitter:imagehttps://opengraph.githubassets.com/c1bfc675d0a3bd73bd1875f9922834da9184d83efa0335b23cab0022442757f4/sqlc-dev/sqlc/issues/288
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/c1bfc675d0a3bd73bd1875f9922834da9184d83efa0335b23cab0022442757f4/sqlc-dev/sqlc/issues/288
og:image:altAdd support for calling into plugins during code generation. One specific use case I have is to support automatic encryption/decryption of columns. To illustrate, here's very naive proposal: CREATE...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamemightyguava
hostnamegithub.com
expected-hostnamegithub.com
Nonecc5dfdd32f62ebd3223cab3af3aa2b268d3605218237326a48a99d1efd89495c
turbo-cache-controlno-preview
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
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release8c77c9e8439031ad54c75a250694842892f693e1
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlc-dev/sqlc/issues/288#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc%2Fissues%2F288
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%2Fsqlc-dev%2Fsqlc%2Fissues%2F288
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%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlc-dev%2Fsqlc
Reloadhttps://github.com/sqlc-dev/sqlc/issues/288
Reloadhttps://github.com/sqlc-dev/sqlc/issues/288
Reloadhttps://github.com/sqlc-dev/sqlc/issues/288
sqlc-devhttps://github.com/sqlc-dev
sqlchttps://github.com/sqlc-dev/sqlc
Codehttps://github.com/sqlc-dev/sqlc
Issues600 (600)https://github.com/sqlc-dev/sqlc/issues
Pull requests132 (132)https://github.com/sqlc-dev/sqlc/pulls
Discussionshttps://github.com/sqlc-dev/sqlc/discussions
Actionshttps://github.com/sqlc-dev/sqlc/actions
Projectshttps://github.com/sqlc-dev/sqlc/projects
Security and qualityhttps://github.com/sqlc-dev/sqlc/security
Insightshttps://github.com/sqlc-dev/sqlc/insights
https://github.com/sqlc-dev/sqlc
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/288
New issuehttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/288
#1578https://github.com/sqlc-dev/sqlc/pull/1578
Extensibility / Plugin Supporthttps://github.com/sqlc-dev/sqlc/issues/288#top
#1578https://github.com/sqlc-dev/sqlc/pull/1578
futureIn the year 3000...https://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22future%22
https://github.com/mightyguava
mightyguavahttps://github.com/mightyguava
on Jan 22, 2020https://github.com/sqlc-dev/sqlc/issues/288#issue-553747752
kyleconroyhttps://github.com/kyleconroy
futureIn the year 3000...https://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22future%22
on Jan 24, 2020https://github.com/sqlc-dev/sqlc/issues/288#event-2975776292
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Jan 24, 2020https://github.com/sqlc-dev/sqlc/issues/288#issuecomment-577945515
kyleconroyhttps://github.com/kyleconroy
completedhttps://github.com/sqlc-dev/sqlc/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Jan 24, 2020https://github.com/sqlc-dev/sqlc/issues/288#event-2975783155
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Feb 5, 2022https://github.com/sqlc-dev/sqlc/issues/288#issuecomment-1030566335
#1414https://github.com/sqlc-dev/sqlc/pull/1414
https://github.com/kyleconroy
kyleconroyhttps://github.com/kyleconroy
on Jun 25, 2022https://github.com/sqlc-dev/sqlc/issues/288#issuecomment-1166237494
#1684https://github.com/sqlc-dev/sqlc/pull/1684
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlc-dev/sqlc/issues/288
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlc-dev/sqlc/issues/288
futureIn the year 3000...https://github.com/sqlc-dev/sqlc/issues?q=state%3Aopen%20label%3A%22future%22
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.