CINXE.COM
The Psycopg 3 project — Psycopg
<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta name="description" content="Python adapter for PostgreSQL" /> <meta name="keywords" content="python, postgresql, adapter, driver, psycopg, psycopg2, database" /> <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="/css/syntax.css?h=8242465b"> <link rel="stylesheet" href="/css/psycopg.css?h=a6123e9d"> <title>The Psycopg 3 project — Psycopg</title> </head> <body> <header> <div id="logoContainer" class="container"> <div id="logo"><h1><a href="/">psycopg</a></h1></div> <div style="clear: left"></div> </div> <nav id="menu" class="navbar navbar-expand-sm navbar-dark"> <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#collapsibleNavbar"> <span class="navbar-toggler-icon"></span> </button> <div class="collapse navbar-collapse" id="collapsibleNavbar"> <ul class="navbar-nav"> <li class="nav-item"> <a class="nav-link" href="/">Home</a> </li> <li class="nav-item"> <a class="nav-link" href="/features/">Features</a> </li> <li class="nav-item"> <a class="nav-link" href="/install/">Install</a> </li> <li class="nav-item"> <a class="nav-link" href="/articles/tag/news/">News</a> </li> <li class="nav-item"> <a class="nav-link" href="/articles/tag/recipe/">Recipes</a> </li> <li class="nav-item active"> <a class="nav-link" href="/psycopg3/">psycopg3</a> </li> <li class="nav-item"> <a class="nav-link" href="/sponsors/">Sponsors</a> </li> </ul> </div> </nav> </header> <div id="site" class="container" style="margin-top:30px"> <div class="row"> <div id="content" class="offset-sm-1 col-sm-10"> <h1>The Psycopg 3 project</h1> <p>Psycopg 3 is the new implementation of the most used, reliable and feature-rich PostgreSQL adapter for Python.</p> <div class="splash-icons docutils container"> <div class="splash-icon docutils container"> <object class="icon" data="../img/handshake.svg" type="image/svg+xml">../img/handshake.svg</object> <p>A familiar DBAPI interface or an <tt class="docutils literal">asyncio</tt>-based interface</p> </div> <div class="splash-icon docutils container"> <object class="icon" data="../img/async.svg" type="image/svg+xml">../img/async.svg</object> <p>Asynchronous communication with both Python and the database</p> </div> <div class="splash-icon docutils container"> <object class="icon" data="../img/adapt.svg" type="image/svg+xml">../img/adapt.svg</object> <p>Rich and flexible adaptation system, optionally using binary format for efficient data transfer</p> </div> <div class="splash-icon docutils container"> <object class="icon" data="../img/mbuto.svg" type="image/svg+xml">../img/mbuto.svg</object> <p>High performance data loading using COPY directly from Python objects</p> </div> </div> <p>Psycopg 3 design emerges from the experience of more than 10 years of development and support of psycopg2. It embraces the new possibilities offered by the more modern generations of the Python language and the PostgreSQL database and addresses the challenges offered by the current patterns in software development and deployment.</p> <div class="section" id="project-funding-i-class-fa-fa-heart-i"> <h2>Project funding <span class="raw-html"><i class="fa fa-heart"></i></span></h2> <p>Psycopg 3 is currently <a class="reference external" href="https://www.psycopg.org/psycopg3/docs/">in version 3.2</a>. If you are interested, the development has been documented in a series of <a class="reference external" href="https://www.varrazzo.com/blog/tag/psycopg/">blog articles</a>.</p> <p>The project is stable and ready to be used, but the code still needs to grow. There are several features planned to improve and expand the functionality.</p> <p>Funding this project would enable full-time work and more frequent releases. If you are interested in sponsoring the development of Psycopg 3, you are encouraged to <a class="reference external" href="https://github.com/sponsors/dvarrazzo/">contribute</a>.</p> <p>Any and all kinds of support are gratefully received and very much appreciated.</p> </div> <div class="section" id="project-links"> <h2>Project links</h2> <ul class="simple"> <li><a class="reference external" href="/psycopg3/docs/">Documentation</a></li> <li><a class="reference external" href="/articles/tag/psycopg3/">Articles, news</a></li> <li><a class="reference external" href="https://www.varrazzo.com/blog/tag/psycopg/">Developers' ramblings</a></li> <li><a class="reference external" href="https://github.com/sponsors/dvarrazzo/">Sponsor</a> <span class="raw-html"><i class="fa fa-heart"></i></span></li> </ul> <p class="footer-right">Icons by <a class="reference external" href="https://icons8.com/">Icons8</a></p> </div> </div> </div> <a style="display:none" rel="me" href="https://fosstodon.org/@psycopg">Mastodon</a> </div> <footer> <div style="margin-bottom:0"> <p>© Copyright 2010—2023 by Daniele Varrazzo (at gmail), The Psycopg Team.</p> </div> </footer> <script src="https://code.jquery.com/jquery-3.4.1.slim.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.0/dist/umd/popper.min.js"></script> <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/js/bootstrap.min.js"></script> </body> </html>