--- title: PostgreSQL adapter for Python | daily.dev description: Psycopg 3 beta 1 is now available on PyPI, marking a complete rewrite of the popular PostgreSQL adapter for Python. It keeps the same libpq wrapper... canonical: https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: PostgreSQL adapter for Python | daily.dev og:description: Psycopg 3 beta 1 is now available on PyPI, marking a complete rewrite of the popular PostgreSQL adapter for Python. It keeps the same libpq wrapper... og:url: https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9 og:image: https://api.daily.dev/og/posts/jy7UDfRl9.png og:image:alt: PostgreSQL adapter for Python og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # PostgreSQL adapter for Python **[Psycopg](https://daily.dev/sources/psycopg)** · 2 min read · 0 upvotes · 0 comments ## Summary Psycopg 3 beta 1 is now available on PyPI, marking a complete rewrite of the popular PostgreSQL adapter for Python. It keeps the same libpq wrapper architecture and DB-API interface as Psycopg 2, but adds asyncio-based concurrency, static typing support, and better Python idioms. On the PostgreSQL side it adds server-side parameters, prepared statements, binary parameters, and improved COPY support. The project thanks its sponsors, including Postgres Professional and Command Prompt, and invites developers to test the beta and give feedback ahead of a stable 3.0 release. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### What new features does Psycopg 3 add compared to Psycopg 2? Psycopg 3 adds asyncio-based concurrency and static typing support on the Python side, while keeping the same libpq wrapper architecture and DB-API interface as Psycopg 2. On the PostgreSQL side, it adds server-side parameters, prepared statements, binary parameters, and improved COPY operation support. It is a complete rewrite aimed at being simpler and more idiomatic to use. _Developers evaluating async database drivers can track library changes like this on daily.dev._ ### How do I install the Psycopg 3 beta release? Install it with pip using 'pip install -U pip' followed by 'pip install --pre psycopg[binary]', since it is a pre-release beta package published on PyPI. The beta has already seen use in some production environments, and real world feedback has helped refine its interface and functionality ahead of the stable 3.0 release. _Teams testing pre-release database libraries can follow updates like this on daily.dev._ ## Similar posts on daily.dev - [PostgreSQL: Psycopg 3.3 released](https://daily.dev/posts/postgresql-psycopg-3-3-released-ewfhnirnz) · PostgreSQL · 1 upvotes · 0 comments --- Tags: [#python](https://daily.dev/tags/python), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"PostgreSQL adapter for Python","url":"https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9"},"datePublished":"2026-08-23T12:21:33.290Z","dateModified":"2026-08-23T12:39:52.830Z","description":"Psycopg 3 beta 1 is now available on PyPI, marking a complete rewrite of the popular PostgreSQL adapter for Python. It keeps the same libpq wrapper...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b0cbd2ac8948f96ab39fa6a90db7464f?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/b0cbd2ac8948f96ab39fa6a90db7464f?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Psycopg","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Psycopg","logo":"https://media.daily.dev/image/upload/s--5N-KNNWk--/f_auto,q_auto/v1787487485/logos/psycopg?_a=BAMAMicg0","url":"https://daily.dev/sources/psycopg"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"python,postgresql","timeRequired":"PT2M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Psycopg","item":"https://daily.dev/sources/psycopg"},{"@type":"ListItem","position":3,"name":"PostgreSQL adapter for Python"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/postgresql-adapter-for-python-jy7udfrl9#faq","mainEntity":[{"@type":"Question","name":"What new features does Psycopg 3 add compared to Psycopg 2?","acceptedAnswer":{"@type":"Answer","text":"Psycopg 3 adds asyncio-based concurrency and static typing support on the Python side, while keeping the same libpq wrapper architecture and DB-API interface as Psycopg 2. On the PostgreSQL side, it adds server-side parameters, prepared statements, binary parameters, and improved COPY operation support. It is a complete rewrite aimed at being simpler and more idiomatic to use. Developers evaluating async database drivers can track library changes like this on daily.dev."}},{"@type":"Question","name":"How do I install the Psycopg 3 beta release?","acceptedAnswer":{"@type":"Answer","text":"Install it with pip using 'pip install -U pip' followed by 'pip install --pre psycopg[binary]', since it is a pre-release beta package published on PyPI. The beta has already seen use in some production environments, and real world feedback has helped refine its interface and functionality ahead of the stable 3.0 release. Teams testing pre-release database libraries can follow updates like this on daily.dev."}}]} ```