Top all-time · #8431
Daniele Varrazzo
Personal blog · varrazzo.com/blogprogrammingdata
Daniele Varrazzo's personal blog at varrazzo.com covers programming and data. Since 2020, 9 different Hacker News readers have linked it 11 times, most often “Thinking Psycopg3”. No feed was found, so read it on the site itself.
Too few sampled comments (4) to say how often HN recommends it.?
Why HN links it
HN readers link Daniele Varrazzo's posts on psycopg, the PostgreSQL adapter for Python, mainly his 'Thinking psycopg3' post explaining the design changes in psycopg3, such as async support and parameter adaptation.
Summarised by Claude from a sample of 4 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Personal website of Daniele Varrazzo: developer, photographer
Most-linked posts?
- Thinking Psycopg35 people · 5 mentions · first linked 2020-03-06
- A Trip into Optimisation2 people · 2 mentions · first linked 2020-05-20
What Hacker News says?
Not mentioned in the article, but the author also built psychopg2 ( https://www.varrazzo.com/software/ )
Comment linking /software/
on “Surviving Django, if you care about databases”Submitted Thinking Psycopg3 as a story · 268 points
HN discussionI was wondering what the major changes between psycopg2 and psycopg3 were. Found a post from the maintainer here: https://www.varrazzo.com/blog/2020/03/06/thinking-psycopg3/ Main takeaways: - Asyncio from the ground up - Uses PQexecParams to do database-side escaping and interpolation - ContextManager and transaction api improvements for - Python only fallback if the C extension fails to build
Comment linking /blog/2020/03/06/thinking-psycopg3/
on “Building a Django driver for Psycopg 3”Submitted Surviving Django, if you care about databases as a story · 172 points
HN discussionI read this and my first question was "Why?" He has a previous post titled "Thinking psycopg3" that shed some light on the issue: https://www.varrazzo.com/blog/2020/03/06/thinking-psycopg3/ - Query parameters adaption - Context managers and transactions - Optional C module (i.e. reduce requirements) - Async from the ground up - Resolve other outstanding issues Reading that post first went a long way toward giving me…
Comment linking /blog/2020/03/06/thinking-psycopg3/
on “Psycopg3: A First Report”Submitted Psycopg3: A First Report as a story · 40 points
HN discussionOK I was wrong and stand corrected, asyncpg is not pure Python. asyncpg has these two C files and also uses Cython as far as I can see. https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr... https://github.com/MagicStack/asyncpg/blob/master/asyncpg/pr... If you are interested here is a post by the psycopg author about psycopg2 and 3 and performance versus asyncpg. https://www.varrazzo.com/blog/2020/05/19/a-…
Comment linking /blog/2020/05/19/a-trip-into-optimisation/
on “Differences from Psycopg2”Submitted Thinking Psycopg3 – Daniele Varrazzo as a story · 7 points
HN discussionSubmitted Thinking Psycopg3 as a story · 4 points
HN discussionSubmitted A Trip into Optimisation as a story · 2 points
HN discussionSubmitted First Experience with Mypy as a story · 1 points
HN discussion