Big news! 🎉 @awscloud.bsky.social is a Platinum Sponsor of Psycopg!
This sponsorship funds the ongoing development of Psycopg 3 and 2 and helps us grow the team. If your organisation depends on Psycopg, we would love your support too. Links in replies👇
#PostgreSQL #Python #Psycopg #AWS #OpenSource
This sponsorship funds the ongoing development of Psycopg 3 and 2 and helps us grow the team. If your organisation depends on Psycopg, we would love your support too. Links in replies👇
#PostgreSQL #Python #Psycopg #AWS #OpenSource
September 23, 2026 at 11:41 AM
Big news! 🎉 @awscloud.bsky.social is a Platinum Sponsor of Psycopg!
This sponsorship funds the ongoing development of Psycopg 3 and 2 and helps us grow the team. If your organisation depends on Psycopg, we would love your support too. Links in replies👇
#PostgreSQL #Python #Psycopg #AWS #OpenSource
This sponsorship funds the ongoing development of Psycopg 3 and 2 and helps us grow the team. If your organisation depends on Psycopg, we would love your support too. Links in replies👇
#PostgreSQL #Python #Psycopg #AWS #OpenSource
psycopg使ったAWS Aurora DSQL向けのコードサンプル書いてたら休日が終わった～🔥😭🔥
AIやってるとキリのいいところ見つけるのが難しいぞ！
写真はどこぞのフードコートでいただいた
博多とんこつラーメン
AIやってるとキリのいいところ見つけるのが難しいぞ！
写真はどこぞのフードコートでいただいた
博多とんこつラーメン
November 9, 2025 at 3:58 PM
psycopg使ったAWS Aurora DSQL向けのコードサンプル書いてたら休日が終わった～🔥😭🔥
AIやってるとキリのいいところ見つけるのが難しいぞ！
写真はどこぞのフードコートでいただいた
博多とんこつラーメン
AIやってるとキリのいいところ見つけるのが難しいぞ！
写真はどこぞのフードコートでいただいた
博多とんこつラーメン
Sponsors page: www.psycopg.org/sponsors/
Sponsorship enquiries: sponsor@psycopg.org
Sponsorship enquiries: sponsor@psycopg.org
Psycopg - PostgreSQL adapter for Python
Psycopg is the most popular PostgreSQL adapter for the Python programming language.
www.psycopg.org
September 23, 2026 at 11:42 AM
Sponsors page: www.psycopg.org/sponsors/
Sponsorship enquiries: sponsor@psycopg.org
Sponsorship enquiries: sponsor@psycopg.org
In my defence, when I wrote it (it's been in prod for years) there weren’t quite as many other implementations and the deep support for instrumentation sets this one apart, I think.
And thus Hynek's Summer of Postgres begins.
github.com/hynek/psycache
And thus Hynek's Summer of Postgres begins.
github.com/hynek/psycache
GitHub - hynek/psycache: A psycopg-Backed PostgreSQL Cache
A psycopg-Backed PostgreSQL Cache. Contribute to hynek/psycache development by creating an account on GitHub.
github.com
June 24, 2026 at 5:24 PM
In my defence, when I wrote it (it's been in prod for years) there weren’t quite as many other implementations and the deep support for instrumentation sets this one apart, I think.
And thus Hynek's Summer of Postgres begins.
github.com/hynek/psycache
And thus Hynek's Summer of Postgres begins.
github.com/hynek/psycache
PythonのPostgreSQLドライバをpsycopgからasyncpgに段階的に移行することにした
September 19, 2025 at 12:58 PM
PythonのPostgreSQLドライバをpsycopgからasyncpgに段階的に移行することにした
Throwback to Daniele's keynote at @pyconit.bsky.social 2022! 🌍🐍
"Psycopg from 2 to 3: designing and living Free Software" covers the journey from Psycopg 2 to 3, open source sustainability, and the role of community. Link in replies 👇
#Python #PostgreSQL #Psycopg #OpenSource
"Psycopg from 2 to 3: designing and living Free Software" covers the journey from Psycopg 2 to 3, open source sustainability, and the role of community. Link in replies 👇
#Python #PostgreSQL #Psycopg #OpenSource
August 24, 2026 at 9:14 AM
Throwback to Daniele's keynote at @pyconit.bsky.social 2022! 🌍🐍
"Psycopg from 2 to 3: designing and living Free Software" covers the journey from Psycopg 2 to 3, open source sustainability, and the role of community. Link in replies 👇
#Python #PostgreSQL #Psycopg #OpenSource
"Psycopg from 2 to 3: designing and living Free Software" covers the journey from Psycopg 2 to 3, open source sustainability, and the role of community. Link in replies 👇
#Python #PostgreSQL #Psycopg #OpenSource
This documentation says that "psycopg" is what they call version 3 of psycopg, which used to be called psycopg2, because it is sufficiently different that they can't use psycopg2 assumptions and
`why didn't you call it psycopg3`
`why didn't you call it psycopg3`
July 26, 2024 at 2:32 PM
This documentation says that "psycopg" is what they call version 3 of psycopg, which used to be called psycopg2, because it is sufficiently different that they can't use psycopg2 assumptions and
`why didn't you call it psycopg3`
`why didn't you call it psycopg3`
New on the Psycopg blog: row-by-row streaming with server-side cursors 🐘🐍
Stop calling fetchall() on large datasets. Stream results from PostgreSQL row by row and keep your memory usage small and predictable. Works with async too. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
Stop calling fetchall() on large datasets. Stream results from PostgreSQL row by row and keep your memory usage small and predictable. Works with async too. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
August 12, 2026 at 10:48 AM
New on the Psycopg blog: row-by-row streaming with server-side cursors 🐘🐍
Stop calling fetchall() on large datasets. Stream results from PostgreSQL row by row and keep your memory usage small and predictable. Works with async too. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
Stop calling fetchall() on large datasets. Stream results from PostgreSQL row by row and keep your memory usage small and predictable. Works with async too. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
I tried to use Claude to fix a bug recently
C: I found the error, you are passing your query params in a tuple, psycopg wants the tuple inside a list
(I change it, same error)
C: I found the error, you are putting the tuple in a list, psycopg wants just a tuple
Me: You just said the opposite!
C: I found the error, you are passing your query params in a tuple, psycopg wants the tuple inside a list
(I change it, same error)
C: I found the error, you are putting the tuple in a list, psycopg wants just a tuple
Me: You just said the opposite!
March 25, 2026 at 12:31 AM
I tried to use Claude to fix a bug recently
C: I found the error, you are passing your query params in a tuple, psycopg wants the tuple inside a list
(I change it, same error)
C: I found the error, you are putting the tuple in a list, psycopg wants just a tuple
Me: You just said the opposite!
C: I found the error, you are passing your query params in a tuple, psycopg wants the tuple inside a list
(I change it, same error)
C: I found the error, you are putting the tuple in a list, psycopg wants just a tuple
Me: You just said the opposite!
Earlier this year, Daniele spoke at @pgconf.dev in Vancouver: "Psycopg: 20 years of mostly friendly coexistence with libpq" ❤️
The recording is now available to watch. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
The recording is now available to watch. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
July 27, 2026 at 11:40 AM
Earlier this year, Daniele spoke at @pgconf.dev in Vancouver: "Psycopg: 20 years of mostly friendly coexistence with libpq" ❤️
The recording is now available to watch. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
The recording is now available to watch. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
🎉 psycopg3-docs-l10n is published!
🚀 Preview:
projects.localizethedocs.org/psycopg3-doc...
🌐 Crowdin:
localizethedocs.crowdin.com/psycopg3-doc...
🐙 GitHub:
github.com/localizethed...
#Crowdin #GitHub #Sphinx #Python #Psycopg #PostgreSQL #Database
🚀 Preview:
projects.localizethedocs.org/psycopg3-doc...
🌐 Crowdin:
localizethedocs.crowdin.com/psycopg3-doc...
🐙 GitHub:
github.com/localizethed...
#Crowdin #GitHub #Sphinx #Python #Psycopg #PostgreSQL #Database
GitHub - localizethedocs/psycopg3-docs-l10n: Localization of The Psycopg 3 Documentation
Localization of The Psycopg 3 Documentation. Contribute to localizethedocs/psycopg3-docs-l10n development by creating an account on GitHub.
github.com
June 3, 2026 at 3:45 AM
🎉 psycopg3-docs-l10n is published!
🚀 Preview:
projects.localizethedocs.org/psycopg3-doc...
🌐 Crowdin:
localizethedocs.crowdin.com/psycopg3-doc...
🐙 GitHub:
github.com/localizethed...
#Crowdin #GitHub #Sphinx #Python #Psycopg #PostgreSQL #Database
🚀 Preview:
projects.localizethedocs.org/psycopg3-doc...
🌐 Crowdin:
localizethedocs.crowdin.com/psycopg3-doc...
🐙 GitHub:
github.com/localizethed...
#Crowdin #GitHub #Sphinx #Python #Psycopg #PostgreSQL #Database
Back from @pgconf.dev, full of ideas! 🤗 Great to share our work on Python/Postgres communication and imagine how the protocol could evolve: lots of work ahead! 💪 If you'd like to get involved, please consider supporting Psycopg 💛 Link in comments! #pgconfdev #PostgreSQL #Python #Psycopg #OpenSource
May 28, 2026 at 9:19 AM
Back from @pgconf.dev, full of ideas! 🤗 Great to share our work on Python/Postgres communication and imagine how the protocol could evolve: lots of work ahead! 💪 If you'd like to get involved, please consider supporting Psycopg 💛 Link in comments! #pgconfdev #PostgreSQL #Python #Psycopg #OpenSource
We kept:
- sqlalchemy + psycopg: Postgres queries
- dateutil: cron spec parsing
- pyyaml: config parsing
- typer-slim: CLI tooling
- websockets: monitoring/UI
Tracing is optional via dbos[otel]. Fewer moving parts means easier to trust and operate.
- sqlalchemy + psycopg: Postgres queries
- dateutil: cron spec parsing
- pyyaml: config parsing
- typer-slim: CLI tooling
- websockets: monitoring/UI
Tracing is optional via dbos[otel]. Fewer moving parts means easier to trust and operate.
September 25, 2025 at 4:28 PM
We kept:
- sqlalchemy + psycopg: Postgres queries
- dateutil: cron spec parsing
- pyyaml: config parsing
- typer-slim: CLI tooling
- websockets: monitoring/UI
Tracing is optional via dbos[otel]. Fewer moving parts means easier to trust and operate.
- sqlalchemy + psycopg: Postgres queries
- dateutil: cron spec parsing
- pyyaml: config parsing
- typer-slim: CLI tooling
- websockets: monitoring/UI
Tracing is optional via dbos[otel]. Fewer moving parts means easier to trust and operate.
Python 3.14's coolest feature? t-strings - and Psycopg 3.3 already supports them 😎
Just write t"..." and drop your variables in {braces}. Proper syntax, no SQL injection, dynamic queries and identifiers - all handled for you!
#Python #PostgreSQL #Database #Development
Just write t"..." and drop your variables in {braces}. Proper syntax, no SQL injection, dynamic queries and identifiers - all handled for you!
#Python #PostgreSQL #Database #Development
June 16, 2026 at 9:47 AM
Python 3.14's coolest feature? t-strings - and Psycopg 3.3 already supports them 😎
Just write t"..." and drop your variables in {braces}. Proper syntax, no SQL injection, dynamic queries and identifiers - all handled for you!
#Python #PostgreSQL #Database #Development
Just write t"..." and drop your variables in {braces}. Proper syntax, no SQL injection, dynamic queries and identifiers - all handled for you!
#Python #PostgreSQL #Database #Development
Read the article here: www.psycopg.org/articles/202...
Psycopg - PostgreSQL adapter for Python
Psycopg is the most popular PostgreSQL adapter for the Python programming language.
www.psycopg.org
August 12, 2026 at 10:48 AM
Read the article here: www.psycopg.org/articles/202...
We are so grateful to Codeur·euses en Liberté for their generous donation to Psycopg! 🎉
Their support helps keep this project alive and thriving. If your organisation depends on Psycopg, please consider sponsoring us too. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
Their support helps keep this project alive and thriving. If your organisation depends on Psycopg, please consider sponsoring us too. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
July 23, 2026 at 10:14 AM
We are so grateful to Codeur·euses en Liberté for their generous donation to Psycopg! 🎉
Their support helps keep this project alive and thriving. If your organisation depends on Psycopg, please consider sponsoring us too. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
Their support helps keep this project alive and thriving. If your organisation depends on Psycopg, please consider sponsoring us too. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
Daniele Varrazzo reveals 20 years of mostly friendly Psycopg coexistence with libpq
May 20, 2026 at 5:34 PM
Daniele Varrazzo reveals 20 years of mostly friendly Psycopg coexistence with libpq
New blog post: integrating Psycopg 3 with FastAPI and Pydantic ⚡
Row factories, dependency injection, connection pooling - with a full working example to download! Link in comments 🤗
#PostgreSQL #Python #FastAPI #Psycopg
Row factories, dependency injection, connection pooling - with a full working example to download! Link in comments 🤗
#PostgreSQL #Python #FastAPI #Psycopg
June 24, 2026 at 9:41 AM
New blog post: integrating Psycopg 3 with FastAPI and Pydantic ⚡
Row factories, dependency injection, connection pooling - with a full working example to download! Link in comments 🤗
#PostgreSQL #Python #FastAPI #Psycopg
Row factories, dependency injection, connection pooling - with a full working example to download! Link in comments 🤗
#PostgreSQL #Python #FastAPI #Psycopg
Did you know you can sponsor Psycopg outside of GitHub? 💛
We welcome direct sponsorships, invoiced arrangements and multi-year commitments. Drop us a message at sponsor@psycopg.org and we will find what works for you 🐍
#PostgreSQL #Python #Psycopg #OpenSource
We welcome direct sponsorships, invoiced arrangements and multi-year commitments. Drop us a message at sponsor@psycopg.org and we will find what works for you 🐍
#PostgreSQL #Python #Psycopg #OpenSource
August 18, 2026 at 8:46 AM
Did you know you can sponsor Psycopg outside of GitHub? 💛
We welcome direct sponsorships, invoiced arrangements and multi-year commitments. Drop us a message at sponsor@psycopg.org and we will find what works for you 🐍
#PostgreSQL #Python #Psycopg #OpenSource
We welcome direct sponsorships, invoiced arrangements and multi-year commitments. Drop us a message at sponsor@psycopg.org and we will find what works for you 🐍
#PostgreSQL #Python #Psycopg #OpenSource
muito bem comentado, movi pro psycopg3 e o instrumentador pro psycopg e tudo voltou kkkkk obrigadooo
August 11, 2025 at 4:35 PM
muito bem comentado, movi pro psycopg3 e o instrumentador pro psycopg e tudo voltou kkkkk obrigadooo
Psycopg now has a GitHub Sponsors page 🐘🐍
We've been the standard PostgreSQL adapter for Python for two decades. If your infrastructure depends on it, please consider supporting its development. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
We've been the standard PostgreSQL adapter for Python for two decades. If your infrastructure depends on it, please consider supporting its development. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
July 17, 2026 at 9:58 AM
Psycopg now has a GitHub Sponsors page 🐘🐍
We've been the standard PostgreSQL adapter for Python for two decades. If your infrastructure depends on it, please consider supporting its development. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
We've been the standard PostgreSQL adapter for Python for two decades. If your infrastructure depends on it, please consider supporting its development. Links in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource
A quick shadow drop of sorts: who hasn't implemented a cache on top of Postgres? I know, everyone has. And yet, here's another contender that's based on psycopg and can use existing SQLAlchemy engines (or whatever you implement): ⚡️psycache ⚡️ 1/2
June 24, 2026 at 5:24 PM
A quick shadow drop of sorts: who hasn't implemented a cache on top of Postgres? I know, everyone has. And yet, here's another contender that's based on psycopg and can use existing SQLAlchemy engines (or whatever you implement): ⚡️psycache ⚡️ 1/2