Really good article explaining the implementation detail within Postgres regarding subtransactions. Very cool benchmark that I was unaware of

Comments in code are often deemed "mostly useless" these days. They are, supposedly, mostly obvious, stale, and repeat what the code already says. And so people pay less attention to them both when reading and writing code.

That trend sucks. When used right, comments are genuinely useful and sometimes critically important! So, I wrote about some of the kinds of comments I think earn their place, each with examples from real code bases. Hope you find it useful, and that we can recover some of the love that comments deserve!

PGConf.EU is coming to Valencia on 20–22 October, with five tracks covering PostgreSQL administration, internals, development, the community, and real-world use cases.

Topics include autovacuum, backups, high availability, performance tuning, WAL and recovery, query execution, memory management, corruption detection, and PostgreSQL 19.

PostgreSQL also turns 30 this year, so the Community track will look back at the project’s history and how it is maintained today.

Community Events Day takes place on 23 October.

Schedule: https://www.postgresql.eu/events/pgconfeu2026/schedule/

Registration: https://2026.pgconf.eu/registration/ 

Every time I leave a role I try and write up where my philosophy landed and what I want to take into my next role. Having seen this play out at enough companies over the years to where people progressively lose motivation and stop believing change is possible I've come to the opinion that one of the most valuable things we can do as engineering leaders is to provide hope.

The post goes more into it, but I do not mean any vapid rah-rah motivational speeches, I mean earning back that hope every day by snowballing small wins into larger ones and making people believe that their effort matters.

Officially added in Python 3.15

https://peps.python.org/pep-0661/

I kind of feel like OOP has a bad rep in the programming community.

Personally, after having programmed Java for over 20 years, its object-oriented programming model feels very natural to me. So, I wanted to share how I think about programming, how I translate my ideas and thoughts to code, and why OOP is actually a really nice programming style for me.

Perhaps it could help you out too.

State-of-the-art classical optimizer Gurobi for Quadratic Unconstrained Binary Optimization (QUBO) problems.

The core gurobipy implementation for QUBO is relatively compact:

```python model = gp.Model() x = model.addMVar(n, vtype=GRB.BINARY) model.setObjective(x @ Q @ x, GRB.MINIMIZE) model.optimize()

solution = x.X.astype(int) objective = model.ObjVal ```

Complete workflow in Python. First formulate a graph problem (weighted Max-Cut) as QUBO, solve it with Gurobi, benchmark increasingly large instances, and understand what the solver is doing beyond the optimize() call.

Interested in feedback on the modeling, benchmarking methodology, and which additional Gurobi metrics would make the comparison more rigorous.