René's URL Explorer Experiment


Title: Added support for Bit objects with Psycopg 2 and pg8000 by astroknot-sheep · Pull Request #170 · pgvector/pgvector-python · GitHub

Open Graph Title: Added support for Bit objects with Psycopg 2 and pg8000 by astroknot-sheep · Pull Request #170 · pgvector/pgvector-python

X Title: Added support for Bit objects with Psycopg 2 and pg8000 by astroknot-sheep · Pull Request #170 · pgvector/pgvector-python

Description: Fixes #169 Bit objects can be passed as query parameters with Psycopg 3, but not with Psycopg 2 or pg8000. This adds: pgvector/psycopg2/bit.py with a BitAdapter, matching HalfvecAdapter / SparsevecAdapter, registered in register_vector a Bit out adapter for pg8000 using to_text(), alongside the existing Vector one asyncpg is unchanged (asyncpg.BitString per #110). Tests: test_bit_class for Psycopg 2 and pg8000 (both fail on master). Full suite passes locally (527 passed, Postgres 17), plus mypy and ty check. Written with AI assistance; I have reviewed and tested the changes.

Open Graph Description: Fixes #169 Bit objects can be passed as query parameters with Psycopg 3, but not with Psycopg 2 or pg8000. This adds: pgvector/psycopg2/bit.py with a BitAdapter, matching HalfvecAdapter / Sparseve...

X Description: Fixes #169 Bit objects can be passed as query parameters with Psycopg 3, but not with Psycopg 2 or pg8000. This adds: pgvector/psycopg2/bit.py with a BitAdapter, matching HalfvecAdapter / Sparseve...

Opengraph URL: https://github.com/pgvector/pgvector-python/pull/170

X: @github

direct link

Domain: github.com

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/:user_id/:repository/pull/:id/files(.:format)
route-controllerpull_requests
route-actionfiles
fetch-noncev2:f5cea435-1d11-e5c0-6771-e62e3e1ebb90
current-catalog-service-hashae870bc5e265a340912cde392f23dad3671a0a881730ffdadd82f2f57d81641b
request-idCE04:329923:CB1899:113C44C:6AFE8857
html-safe-nonce07c9c5818c09c0c6f8d8823c224627dc9701ba43e1db743797f1b8d431bfc35e
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDRTA0OjMyOTkyMzpDQjE4OTk6MTEzQzQ0Qzo2QUZFODg1NyIsInZpc2l0b3JfaWQiOiI0OTg4NDQ3NDA2MTk1Mzc4MjY0IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmace267e7c651c33e7b6cc596cd8fb2c042cd0ded1a98704b7315fbf034c81d40a9
hovercard-subject-tagpull_request:4958831190
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/pgvector/pgvector-python/pull/170/files
twitter:imagehttps://avatars.githubusercontent.com/u/105595392?s=400&v=4
twitter:cardsummary_large_image
og:imagehttps://avatars.githubusercontent.com/u/105595392?s=400&v=4
og:image:altFixes #169 Bit objects can be passed as query parameters with Psycopg 3, but not with Psycopg 2 or pg8000. This adds: pgvector/psycopg2/bit.py with a BitAdapter, matching HalfvecAdapter / Sparseve...
og:site_nameGitHub
og:typeobject
hostnamegithub.com
expected-hostnamegithub.com
Noneb3c0f155eafc27e60db6e254d1ffff0e072e9ab3b4018a5ee518797c19d89f86
turbo-cache-controlno-preview
diff-viewunified
go-importgithub.com/pgvector/pgvector-python git https://github.com/pgvector/pgvector-python.git
octolytics-dimension-user_id98363230
octolytics-dimension-user_loginpgvector
octolytics-dimension-repository_id376300726
octolytics-dimension-repository_nwopgvector/pgvector-python
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id376300726
octolytics-dimension-repository_network_root_nwopgvector/pgvector-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
release4a10310af51a1bfffbedc4fd81cb582acf0cb0ff
ui-targetfull
theme-color#1e2327
color-schemelight dark

Links:

Skip to contenthttps://github.com/pgvector/pgvector-python/pull/170/files#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fpgvector%2Fpgvector-python%2Fpull%2F170%2Ffiles
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%2Fpgvector%2Fpgvector-python%2Fpull%2F170%2Ffiles
Sign uphttps://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=pgvector%2Fpgvector-python
Reloadhttps://github.com/pgvector/pgvector-python/pull/170/files
Reloadhttps://github.com/pgvector/pgvector-python/pull/170/files
Reloadhttps://github.com/pgvector/pgvector-python/pull/170/files
pgvectorhttps://github.com/pgvector
pgvector-pythonhttps://github.com/pgvector/pgvector-python
Codehttps://github.com/pgvector/pgvector-python
Issues2 (2)https://github.com/pgvector/pgvector-python/issues
Pull requests8 (8)https://github.com/pgvector/pgvector-python/pulls
Actionshttps://github.com/pgvector/pgvector-python/actions
Security and qualityhttps://github.com/pgvector/pgvector-python/security
Insightshttps://github.com/pgvector/pgvector-python/insights
Sign up for GitHub https://github.com/signup?return_to=%2Fpgvector%2Fpgvector-python%2Fissues%2Fnew%2Fchoose
terms of servicehttps://docs.github.com/terms
privacy statementhttps://docs.github.com/privacy
Sign inhttps://github.com/login?return_to=%2Fpgvector%2Fpgvector-python%2Fissues%2Fnew%2Fchoose
astroknot-sheephttps://github.com/astroknot-sheep
pgvector:masterhttps://github.com/pgvector/pgvector-python/tree/master
astroknot-sheep:bit-adapters-psycopg2-pg8000https://github.com/astroknot-sheep/pgvector-python/tree/bit-adapters-psycopg2-pg8000
Conversation 0 https://github.com/pgvector/pgvector-python/pull/170
Commits 1 https://github.com/pgvector/pgvector-python/pull/170/commits
Checks 0 https://github.com/pgvector/pgvector-python/pull/170/checks
Files changed https://github.com/pgvector/pgvector-python/pull/170/files
Please reload this pagehttps://github.com/pgvector/pgvector-python/pull/170/files
Added support for Bit objects with Psycopg 2 and pg8000 https://github.com/pgvector/pgvector-python/pull/170/files#top
Show all changes 1 commit https://github.com/pgvector/pgvector-python/pull/170/files
4764b5b Added support for Bit objects with Psycopg 2 and pg8000 astroknot-sheep Oct 21, 2026 https://github.com/pgvector/pgvector-python/pull/170/commits/4764b5bc1a64fb0fa8f9be7934e5e19e50d3eaa9
Clear filters https://github.com/pgvector/pgvector-python/pull/170/files
Please reload this pagehttps://github.com/pgvector/pgvector-python/pull/170/files
Please reload this pagehttps://github.com/pgvector/pgvector-python/pull/170/files
register.py https://github.com/pgvector/pgvector-python/pull/170/files#diff-87f7f628e6082dcb193c9de51b0f32a00185e921708ed951dfba89afd6508c0a
bit.py https://github.com/pgvector/pgvector-python/pull/170/files#diff-cf50c3f2615779ef20b4efbe28412718bc02be7f484493cceee8d3a0ad08ab3e
register.py https://github.com/pgvector/pgvector-python/pull/170/files#diff-98d656fd4619b1ab99581d8434512f65bdf00b30963fe52fa5c194d98f4785e9
test_pg8000.py https://github.com/pgvector/pgvector-python/pull/170/files#diff-402334513ae7cc02b183c503a8f09c3e61198a04c0999e149a48593832f45378
test_psycopg2.py https://github.com/pgvector/pgvector-python/pull/170/files#diff-760bb0f52ca0238727ca88e31fa923366f53f57a1d9e1309aad8ae6f4816d234
pgvector/pg8000/register.pyhttps://github.com/pgvector/pgvector-python/pull/170/files#diff-87f7f628e6082dcb193c9de51b0f32a00185e921708ed951dfba89afd6508c0a
View file https://github.com/pgvector/pgvector-python/blob/4764b5bc1a64fb0fa8f9be7934e5e19e50d3eaa9/pgvector/pg8000/register.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/pgvector/pgvector-python/pull/170/{{ revealButtonHref }}
https://github.com/pgvector/pgvector-python/pull/170/files#diff-87f7f628e6082dcb193c9de51b0f32a00185e921708ed951dfba89afd6508c0a
https://github.com/pgvector/pgvector-python/pull/170/files#diff-87f7f628e6082dcb193c9de51b0f32a00185e921708ed951dfba89afd6508c0a
pgvector/psycopg2/bit.pyhttps://github.com/pgvector/pgvector-python/pull/170/files#diff-cf50c3f2615779ef20b4efbe28412718bc02be7f484493cceee8d3a0ad08ab3e
View file https://github.com/pgvector/pgvector-python/blob/4764b5bc1a64fb0fa8f9be7934e5e19e50d3eaa9/pgvector/psycopg2/bit.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/pgvector/pgvector-python/pull/170/{{ revealButtonHref }}
pgvector/psycopg2/register.pyhttps://github.com/pgvector/pgvector-python/pull/170/files#diff-98d656fd4619b1ab99581d8434512f65bdf00b30963fe52fa5c194d98f4785e9
View file https://github.com/pgvector/pgvector-python/blob/4764b5bc1a64fb0fa8f9be7934e5e19e50d3eaa9/pgvector/psycopg2/register.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/pgvector/pgvector-python/pull/170/{{ revealButtonHref }}
https://github.com/pgvector/pgvector-python/pull/170/files#diff-98d656fd4619b1ab99581d8434512f65bdf00b30963fe52fa5c194d98f4785e9
https://github.com/pgvector/pgvector-python/pull/170/files#diff-98d656fd4619b1ab99581d8434512f65bdf00b30963fe52fa5c194d98f4785e9
tests/test_pg8000.pyhttps://github.com/pgvector/pgvector-python/pull/170/files#diff-402334513ae7cc02b183c503a8f09c3e61198a04c0999e149a48593832f45378
View file https://github.com/pgvector/pgvector-python/blob/4764b5bc1a64fb0fa8f9be7934e5e19e50d3eaa9/tests/test_pg8000.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/pgvector/pgvector-python/pull/170/{{ revealButtonHref }}
https://github.com/pgvector/pgvector-python/pull/170/files#diff-402334513ae7cc02b183c503a8f09c3e61198a04c0999e149a48593832f45378
https://github.com/pgvector/pgvector-python/pull/170/files#diff-402334513ae7cc02b183c503a8f09c3e61198a04c0999e149a48593832f45378
https://github.com/pgvector/pgvector-python/pull/170/files#diff-402334513ae7cc02b183c503a8f09c3e61198a04c0999e149a48593832f45378
tests/test_psycopg2.pyhttps://github.com/pgvector/pgvector-python/pull/170/files#diff-760bb0f52ca0238727ca88e31fa923366f53f57a1d9e1309aad8ae6f4816d234
View file https://github.com/pgvector/pgvector-python/blob/4764b5bc1a64fb0fa8f9be7934e5e19e50d3eaa9/tests/test_psycopg2.py
Open in desktop https://desktop.github.com
https://github.co/hiddenchars
https://github.com/pgvector/pgvector-python/pull/170/{{ revealButtonHref }}
https://github.com/pgvector/pgvector-python/pull/170/files#diff-760bb0f52ca0238727ca88e31fa923366f53f57a1d9e1309aad8ae6f4816d234
https://github.com/pgvector/pgvector-python/pull/170/files#diff-760bb0f52ca0238727ca88e31fa923366f53f57a1d9e1309aad8ae6f4816d234
https://github.com/pgvector/pgvector-python/pull/170/files#diff-760bb0f52ca0238727ca88e31fa923366f53f57a1d9e1309aad8ae6f4816d234
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.