A draft merge request adding a psycopg3 backend to #Tryton

https://foss.heptapod.net/tryton/tryton/-/merge_requests/2408

It showed that we need to add a feature to python-sql to support the pyformat paramstyle of the the DB-API

https://peps.python.org/pep-0249/#paramstyle

Switching to psycopg3 would allow to use server side binding and thus give some freedom when processing long list of ids (as it's common with Tryton's ORM).

#python #psycopg3 #postgresql

My next project is the Japanese translation of psycopg3 documentation. 🔌🐘 I expected there's already some past existing work for psycopg2, but couldn't find any, a bit surprisingly.

Only the home and async pages were finished!

(Screenshot is locally built from https://github.com/shuuji3/psycopg/commit/df0de57820b8ad33e342fcf968fad9751ef453f0)

#psycopg #psycopg3 #translation

I've completed my basic migration to #psycopg3 for my projects that don't use ORMs. It's all gone very smoothly and in fact with first class support for UUIDs I have actually been removing code and complexity.

What is interesting now is that the new Row Factory functionality means that much of the reason I used the ORMs so simplify query coding may have gone away. I think I can do much of what I need with the base library.

This morning @felixxm merged the branch for @psycopg 3 support in Django 🎉

I opened the related issue 13 months ago and since then many developers have worked on the PR based on the work of Daniele Varrazzo 👏

I thank everyone who made this achievement possible starting from @apollo13 to @felixxm but also Simon Charette, Tim Graham, @adamchainz, @carlton and @davidsmith 🙏

I'm sure that both Django and Psycopg will benefit from this success ✨

#django #psycopg3 #psycopg

https://code.djangoproject.com/ticket/33308

Django 4.2 supports Psycopg 3 📢 💥 Thanks to Daniele Varrazzo, @apollo13 and Simon Charette for their humongous work 🌟 🌟 🌟

https://github.com/django/django/pull/15687

#psycopg3 #postgresql  #django 

@Crocmagnon @psycopg has a lot of new features, you can read about them directly in its website 👇
https://www.psycopg.org/

#psycopg3 #psycopg

In the @django project a great deal of work is underway to add @psycopg support to the #ORM 🐍🐘
Simon and Florian are doing a great job getting PR merged before #Django 4.2 is released ⚡️
You too could help by trying to test this #PR in your projects 👇
https://github.com/django/django/pull/15687

#django #psycopg #psycopg3 #postgresql