psycopg
@psycopg
Followers
2K
Following
365
Media
95
Statuses
827
I am the most used and most advanced PostgreSQL driver for Python! (it/its)
Joined October 2010
What is #psycopg3 anyway? Last March at https://t.co/nx1pV427wD I gave a talk with a good description of the project and its goal: https://t.co/jI5tBGH4nm
#Python #PostgreSQL Please come to have a look! Thank you very much @PostgresPro for the opportunity!
2
7
22
Shall we meet in Naples? We will be at PGDay Napoli to talk about Psycopg 3 and in the upcoming 3.3, with Python 3.14 and PostgreSQL 18 support. After that, get the chance to visit a picturesque city and have the best pizza of your life! https://t.co/smM6iGiZn2
2025.pgdaynapoli.org
The PostgreSQL conference in Napoli.
0
0
0
I hope to not be committing any crime by declaring that you can find us as @psycopg@fosstodon.org Whether we will keep on using this space or not depends on the quality of the interaction and the toxicity of the different networks. #python #postgresql #freesoftware
0
0
9
Very annoying... psycopg 3 threads stumble on each other, but can't figure out what is hogging the GIL (above: 1 thread benchmark, below, 4 threads, circled: GIL acquisition). How to debug it? #Python #Debugging
2
0
10
Tried to convert setup.cfg to pyproject.toml, and it's a pretty poor result: likely it won't be merged. I hate how useful info are forced to irrelevant places, such as the urls after the filename of the readme. I wish this format was ditched and build-system moved to setup.cfg.
1
0
8
Hints: - @GitHubActions services don't support passing ARGS to docker run (which would be passed to the server) - You can't override the ENTRYPOINT with a script from the repo, because the service starts before actions/checkout Checkmate, AFAICS https://t.co/Ajjc0itGaE
github.com
0
0
5
It is impossible to configure the postgresql.conf of the @GitHub @GitHubAction @PostgreSQL service. For instance, impossible to enable two-phase commit. Prove me wrong. https://t.co/xNEVOZBXh9
docs.github.com
You can create a PostgreSQL service container to use in your workflow. This guide shows examples of creating a PostgreSQL service for jobs that run in containers or directly on the runner machine.
3
0
12
There could be a few lessons to learn here. One is to look into other provides (checking if @MacStadium has availability for Free-Software projects). We will also refactor the metadata to allow more flexibility in Psycopg 3.2.
0
0
1
Just released psycopg 3.1.7, but we couldn't build M1 binary packages as @Scaleway has no hardware availalble. So we made it compatible with psycopg-binary 3.1.6 (we could, this time, because only changes are in Python code). https://t.co/fhtm5BE4zf
1
1
6
Let's take a look how it is down there. Nice default avatar, it looks a bit like me.
1
2
13
Retweeting @pauloxnet tweet to say thank you for your work bringing everyone together, and because it contains a nice list of people to thank. Great job, people! 💜
The Django @psycopg branch has been merged 🎉 I opened the issue 13 months ago and many developers worked on the PR started by @dvarrazzo 👏 Thanks @fapolloner @MariuszFelisiak Simon Charette, Tim Graham, @AdamChainz, @carltongibson and @David_Smith86 🙏 https://t.co/l5y6MSSsIs
1
0
3
Oops... didn't even close the shell where 3.1.5 was released that we had a reason to release 3.1.6 😩 In 3.1.5 we broke cursor.copy() when row_factory is specified... and copy() doesn't even use row factories 😅 Relevant tests added, of course. #TDD
https://t.co/mqgAF3ARGA
0
0
9
This was an amazing piece of work! Thank you very much @djangoproject for welcoming Psycopg 3!
Django 4.2 supports @psycopg 3 📢💥 Thanks to Daniele Varrazzo, @fapolloner, and Simon Charette for their humongous work 🌟🌟🌟 https://t.co/EUmvPNu1Aq
#psycopg3 #postgresql #django
0
1
7
A very nice article from @bitdotioinc about the effect of latency in your queries. Featuring admiral Grace Hopper and psycopg 3 pipeline mode! Check it out, it's a good read! https://t.co/Bvyi1UoI6o
innerjoin.bit.io
Network latency is a simple reality of physics: communications between clients and servers must travel through the infrastructure of the…
0
5
12
Psycopg 3.1.5 released. A few bug fixes and *big* speedup improvements: networking, namedtuples, arrays... Try it out now! 😄🚀
0
2
25
Psycopg 3.1.4 and 2.9.5 released, with Python 3.11 and PostgreSQL 15 support! 🥳🥳🥳 Today all the world must have been building their packages, because it took forever... 🌎📦🌍📦🌏📦 Happy hacking! #python #postgresql #freesoftware #release
2
28
212
1
6
79
The last versions of psycopg 2 and 3 binaries now support Apple M1 hardware! 🥳🥳🥳 Thank you to everyone who helped releasing these packages 💜 #python #postgresql #freesoftware
0
6
41
The pipeline mode in psycopg 3.1 is a game changer in terms of performances and requires minimal changes in your code to use! You can read about it in this in-depth article by its main author, Denis! #python #postgresql #freesoftware
Our developer Denis contributes to @psycopg, the #PostgreSQL adapter for #Python, maintained by @dvarrazzo. This week, he tells you all you need to know about its pipeline mode => https://t.co/wXJ8kvhOA5
#opensource #freesoftware #DBMS
0
5
23