mastodon
4.6.6
The most popular PostgreSQL adapter for Python
Earlier this year, Daniele gave a talk at @pgconfdev@mastodon.social in Vancouver titled "Psycopg: 20 years of mostly friendly coexistence with libpq" ❤️
Two decades of Python and PostgreSQL working together and there are still stories worth telling. The recording is now available to watch online. Link in replies 👇
#PostgreSQL #Python #Psycopg #OpenSource #FOSS #PGConf #DataEngineering
We are deeply grateful to @CodeursEnLiberte@framapiaf.org for their generous donation to Psycopg! 🎉
Codeur·euses en Liberté are a French web cooperative with a commitment to open source software. Their support helps us keep Psycopg maintained and freely available to everyone who relies on it.
Psycopg is critical infrastructure for the Python and PostgreSQL ecosystem. If your organisation depends on it, please consider supporting the project. Links in replies 👇
You don't need a NoSQL database if you have PostgreSQL! 💪
Postgres can store unstructured data alongside relational data - just add a JSON or JSONB field!
And here's a secret 🤫 Call register_dumper(dict, JsonDumper) early in your program and every dictionary migrates seamlessly between Python and PostgreSQL
So good it might become the default in Psycopg 3.4. What do you think? Psycopg is your friend of course: check the docs in the comments 👇
New to the Psycopg blog: integrating Psycopg 3 with FastAPI and Pydantic ⚡
Covers dependency injection for DB connections, row factories that map results directly to Pydantic models and tying a connection pool to the application lifecycle. Full working example included - link in comments!
#PostgreSQL #Python #FastAPI #Pydantic #Psycopg #OpenSource #FOSS
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. No more counting %s placeholders or juggling param dicts!
Check the link in the comments 👀 #Python #PostgreSQL #Database #Development
Did you know that you can customise the objects returned by a query? 👀
By default Psycopg returns a Python tuple for every Postgres row, but which object it uses is actually under your control.
If you want more flexibility, 'row_factory' and the 'psycopg.rows' module are your friends! 😊
Back from @pgconfdev@mastodon.social, full of ideas! 🤗 Great to share our work on Python/PostgreSQL communication with core hackers 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 #libpq #OpenSource #PythonDeveloper #PostgreSQLCommunity #DevConference
We're heading to Vancouver! 🇨🇦
Our maintainer Daniele Varrazzo will be speaking at @pgconfdev@mastodon.social next week, giving a talk on libpq - the PostgreSQL client library at the heart of Psycopg - and how we can help clients get even more out of PostgreSQL
If you're attending, don't miss it. And if you're around, come say hello! 👋
#pgconfdev #PostgreSQL #Python #Psycopg #libpq #OpenSource #DatabaseEngineering #PythonDeveloper #PostgreSQLCommunity #DevConference
Draft of the usage of Python 3.14 template strings in Psycopg 3.3!
https://www.psycopg.org/psycopg3/docs/basic/tstrings.html
Any feedback? Feel free to contribute to the discussion in https://github.com/psycopg/psycopg/discussions/1044
PEP 750 just merged to Python 3.14! https://github.com/python/cpython/pull/132662
And yesterday I happened to start working at template strings support in psycopg: https://github.com/psycopg/psycopg/pull/1054
First tests here: https://github.com/psycopg/psycopg/blob/646f2023b24744bd32a96d1a621e8fed8cc48409/tests/test_tstring.py
This is probably the biggest change to happen to the project since its inception! Exciting times! 😃