Psycopg

Psycopg GitHub sponsor link 💛 github.com/sponsors/dvarr…

Back from @PGConfdev, 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, please consider supporting Psycopg 💛 Link in comments! #pgconfdev #PostgreSQL #Python #Psycopg

We're going to Vancouver! 🇨🇦 Our maintainer Daniele Varrazzo will be giving a talk at @PGConfdev about libpq and how to get more out of PostgreSQL. Come say hi! 👋 #pgconfdev #PostgreSQL #Python #Psycopg #libpq #OpenSource #PythonDeveloper #PostgreSQLCommunity #DevConference

The Psycopg website has a new look! Check it out: psycopg.org

We have a new logo! What do you think? More updates coming soon...

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! 2025.pgdaynapoli.org

@pauloxnet aaaaAAAAAAAAA!!!!!1 That's amazing! Thank you for the immense work!!!

CC @psycopg

Django 4.2 LTS has just been released 🎉 From Django news 💡 "… few highlights are: - psycopg version 3 support - comments on columns and tables - support for asynchronous streaming responses …" Info 👇 djangoproject.com/weblog/2023/ap… #Django #Python #Release #LTS #Psycopg #Async

@samuelcolvin Something easier to do is to list the minimum versions in a constraint files and include it in a CI test run using pip -c. Details at #constraints-files" target="_blank" rel="nofollow noopener">pip.pypa.io/en/stable/user…

I want a CI tool that installs all combinations of dependencies for a package (or random combinations of dependencies if "all" is too many), then runs tests. It could run either on push or nightly and would pick up issues like github.com/pydantic/pydan… Does any such thing exist?

@github What is a SQL injection?

We’ve known about SQL injection attacks for a long time. Catch vulnerable code before it’s committed to your codebase. 🔍🔒

@willmcgugan @samuelcolvin @github I got one of these yesterday too, which was sort of upsetting... but then I thought that it was the first spam ever received since I'm active on @github, which has been a long while. So I guess it counts as a testament of the quality of the platform 🙂

@samuelcolvin @github Woke up to a tsunami of "issues" this morning. Relieved it was spam and not a Rich bug. In fairness, of all the platforms I use, GitHub is the least spammy.

Seems like @github is being hit by a wave of spam. I'm seeking multiple spam comments an hour, most are deleted straight away, but not all. Did someone crack their "I am not a robot"?

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

@FreyaHolmer You can have your comments stored in GitHub issues comments. Take a look at utteranc.es

so disqus then? I was a little worried when it said it's ad supported, as well as I would've expected something newer to take its place!

what's the most standard/easy way to set up a comment section on a website/blog? I want to write some on my website, but I think it'd be nice if there was some sort of comment section

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

@willmcgugan Are simple controls such as check boxes, radio, drop-downs implemented? Last time I checked there weren't, still needed curses, so no way to write a portable app

What should Textual add next?

@sfermigier I tried, and no: you can't convert the URLs to a dict. It only works if it's on a single line.

@psycopg I don't really agree. On the left, we have DSL where some information are conventional. On the right, things are more regular and more directly map to an internal data structure. Also, you could change `projects.urls` to a dict to solve the issue you've mentioned.

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.

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 github.com/psycopg/psycop…

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. docs.github.com/en/actions/usi…

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.

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). #psycopg-3-1-7" target="_blank" rel="nofollow noopener">psycopg.org/psycopg3/docs/…