René's URL Explorer Experiment


Title: Feat/pgvector numpy support by DavidHein96 · Pull Request #93 · sqlc-dev/sqlc-gen-python · GitHub

Open Graph Title: Feat/pgvector numpy support by DavidHein96 · Pull Request #93 · sqlc-dev/sqlc-gen-python

X Title: Feat/pgvector numpy support by DavidHein96 · Pull Request #93 · sqlc-dev/sqlc-gen-python

Description: This addresses #61 The default format is a a numpy float 32 to match pgvector numpy was chosen over pytorch tensor for the lighter dependencies This might need a special section in the docs though that to actually be able to do this you may need to coerce first to actually ensure the correct form. def _coerce_embedding(x: NDArray[np.floating]) -> NDArray[np.float32]: # pgvector elements are single-precision floats; enforce dtype + 1D arr = np.asarray(x, dtype=np.float32) if arr.ndim != 1: raise ValueError(f"embedding must be 1-D, got shape {arr.shape}") return arr As well as some kind of way of registering pgvector from sqlalchemy import event from pgvector.psycopg import register_vector @event.listens_for(engine, "connect") def _pgvector_connect(dbapi_connection, _): register_vector(dbapi_connection)

Open Graph Description: This addresses #61 The default format is a a numpy float 32 to match pgvector numpy was chosen over pytorch tensor for the lighter dependencies This might need a special section in the docs though...

X Description: This addresses #61 The default format is a a numpy float 32 to match pgvector numpy was chosen over pytorch tensor for the lighter dependencies This might need a special section in the docs though...

Opengraph URL: https://github.com/sqlc-dev/sqlc-gen-python/pull/93

X: @github

direct link

Domain: patch-diff.githubusercontent.com

route-pattern/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:95f4793a-504e-64f1-b60a-814b8dcd61fb
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idB970:260E1A:41E361:5BC546:696F589A
html-safe-nonce6d91660bb811b97e2578cc3702db1ce17d7a11d9f8ceccd2598cc72d847d78b4
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJCOTcwOjI2MEUxQTo0MUUzNjE6NUJDNTQ2OjY5NkY1ODlBIiwidmlzaXRvcl9pZCI6IjQwODMzOTM3MDQwNzQ2MzEzMjIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ==
visitor-hmaca7ca53ad41d3aa5ff76840b41f1c6b1c465d6ed3b7f49b1ca61138b48430632b
hovercard-subject-tagpull_request:3108212148
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-gen-python/pull/93/files
twitter:imagehttps://avatars.githubusercontent.com/u/58490167?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/58490167?s=400&v=4
og:image:altThis addresses #61 The default format is a a numpy float 32 to match pgvector numpy was chosen over pytorch tensor for the lighter dependencies This might need a special section in the docs though...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
None49bb2ee76ae1b4ec758faefafda636ff20b05a9708bb290d28422cdf542ae979
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/sqlc-dev/sqlc-gen-python git https://github.com/sqlc-dev/sqlc-gen-python.git
octolytics-dimension-user_id136738596
octolytics-dimension-user_loginsqlc-dev
octolytics-dimension-repository_id548530161
octolytics-dimension-repository_nwosqlc-dev/sqlc-gen-python
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id548530161
octolytics-dimension-repository_network_root_nwosqlc-dev/sqlc-gen-python
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
release036f37fe552777ac9c6ee661957f947285aab936
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#start-of-content
https://patch-diff.githubusercontent.com/
Sign in https://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc-gen-python%2Fpull%2F93%2Ffiles
GitHub CopilotWrite better code with AIhttps://github.com/features/copilot
GitHub SparkBuild and deploy intelligent appshttps://github.com/features/spark
GitHub ModelsManage and compare promptshttps://github.com/features/models
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
GitHub SponsorsFund open source developershttps://github.com/sponsors
Security Labhttps://securitylab.github.com
Maintainer Communityhttps://maintainers.github.com
Acceleratorhttps://github.com/accelerator
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://patch-diff.githubusercontent.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlc-dev%2Fsqlc-gen-python%2Fpull%2F93%2Ffiles
Sign up https://patch-diff.githubusercontent.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-gen-python
Reloadhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Reloadhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Reloadhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
sqlc-dev https://patch-diff.githubusercontent.com/sqlc-dev
sqlc-gen-pythonhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python
Notifications https://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python
Fork 46 https://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python
Star 304 https://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python
Code https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python
Issues 33 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/issues
Pull requests 13 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulls
Actions https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/actions
Projects 0 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/projects
Security Uh oh! There was an error while loading. Please reload this page. https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/security
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Insights https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulse
Code https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python
Issues https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/issues
Pull requests https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulls
Actions https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/actions
Projects https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/projects
Security https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/security
Insights https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pulse
Sign up for GitHub https://patch-diff.githubusercontent.com/signup?return_to=%2Fsqlc-dev%2Fsqlc-gen-python%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://patch-diff.githubusercontent.com/login?return_to=%2Fsqlc-dev%2Fsqlc-gen-python%2Fissues%2Fnew%2Fchoose
DavidHein96https://patch-diff.githubusercontent.com/DavidHein96
sqlc-dev:mainhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/tree/main
DavidHein96:feat/pgvector-numpy-supporthttps://patch-diff.githubusercontent.com/DavidHein96/sqlc-gen-python/tree/feat/pgvector-numpy-support
Conversation 0 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93
Commits 2 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/commits
Checks 0 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/checks
Files changed https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Feat/pgvector numpy support https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#top
Show all changes 2 commits https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
6235819 chore: bump README to 1.3.0 devstein Jan 23, 2025 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/commits/62358198a993860ef002f150b2b13fba4d636401
277ec54 feat: add pgvector support with typed numpy arrays DavidHein96 Dec 17, 2025 https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/commits/277ec542b98d9167ffb3643bbcc371ab954b6c41
Clear filters https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
Please reload this pagehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files
.gitignore https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947
README.md https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-b335630551682c19a781afebcf4d07bf978fb1f8ac04c6bf87428ed5106870f5
models.py https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-b2defb5db62a33bdf0bf5a5bde15e26b0287ac1cc1e353fc69ec65e69e3bea76
query.py https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-656db112a237997f492ab8cd72f923cf4ef59ddc6c91609a9a5ab9266b86c91a
query.sql https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-c319e581aed76ad3c5103be0fed543ff48947bf87101ff8f6a1489c23c5ff3ae
schema.sql https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-6626f4c8420d7c3459a0e87e23acf7a669237ffa267cee388452c5e0af6e512f
sqlc.yaml https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-84f2f321867b89bf1fa5e984883c6f48383ad331fae1d991837a639ff79bec59
imports.go https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-753b226be70bd4bcb9177ab0628593fcfa6a32d3d3d4dea5a35871dee9bbdc30
postgresql_type.go https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-f09311d7e86aa983371fe295292e1dbba439f593200a2bac19b628ce58813ad6
.gitignorehttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/.gitignore
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-bc37d034bad564583790a46f19d807abfe519c5671395fd494d8cce506c42947
README.mdhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-b335630551682c19a781afebcf4d07bf978fb1f8ac04c6bf87428ed5106870f5
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/README.md
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-b335630551682c19a781afebcf4d07bf978fb1f8ac04c6bf87428ed5106870f5
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-b335630551682c19a781afebcf4d07bf978fb1f8ac04c6bf87428ed5106870f5
internal/endtoend/testdata/emit_numpy_array/python/models.pyhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-b2defb5db62a33bdf0bf5a5bde15e26b0287ac1cc1e353fc69ec65e69e3bea76
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/endtoend/testdata/emit_numpy_array/python/models.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
internal/endtoend/testdata/emit_numpy_array/python/query.pyhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-656db112a237997f492ab8cd72f923cf4ef59ddc6c91609a9a5ab9266b86c91a
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/endtoend/testdata/emit_numpy_array/python/query.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
internal/endtoend/testdata/emit_numpy_array/query.sqlhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-c319e581aed76ad3c5103be0fed543ff48947bf87101ff8f6a1489c23c5ff3ae
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/endtoend/testdata/emit_numpy_array/query.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
internal/endtoend/testdata/emit_numpy_array/schema.sqlhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-6626f4c8420d7c3459a0e87e23acf7a669237ffa267cee388452c5e0af6e512f
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/endtoend/testdata/emit_numpy_array/schema.sql
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
internal/endtoend/testdata/emit_numpy_array/sqlc.yamlhttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-84f2f321867b89bf1fa5e984883c6f48383ad331fae1d991837a639ff79bec59
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/endtoend/testdata/emit_numpy_array/sqlc.yaml
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
internal/imports.gohttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-753b226be70bd4bcb9177ab0628593fcfa6a32d3d3d4dea5a35871dee9bbdc30
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/imports.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-753b226be70bd4bcb9177ab0628593fcfa6a32d3d3d4dea5a35871dee9bbdc30
internal/postgresql_type.gohttps://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-f09311d7e86aa983371fe295292e1dbba439f593200a2bac19b628ce58813ad6
View file https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/blob/277ec542b98d9167ffb3643bbcc371ab954b6c41/internal/postgresql_type.go
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/{{ revealButtonHref }}
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-f09311d7e86aa983371fe295292e1dbba439f593200a2bac19b628ce58813ad6
https://patch-diff.githubusercontent.com/sqlc-dev/sqlc-gen-python/pull/93/files#diff-f09311d7e86aa983371fe295292e1dbba439f593200a2bac19b628ce58813ad6
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.