Signed commits, worth it or theatre

You

Does commit signing matter for a solo public project?

ChatGPT

It proves commits came from a key you control, which matters mostly for released tags and for actions others automate against. For everyday commits on a one-person project it is largely ceremony, and an expired key causes more confusion than it prevents.

Tool steps: 3 (reasoning summary, call to python, execution output)

reasoning summary

Checked the query plan, then compared index options.

call to python

rows = run_sql("EXPLAIN (ANALYZE) SELECT ...")
print(rows[:3])

execution output

Seq Scan on events  (cost=0.00..812431.00 rows=41203122 width=16)
  Rows Removed by Filter: 38996878
Planning Time: 0.214 ms
Execution Time: 11842.663 ms

You

Any downside worth knowing before I commit?

ChatGPT

It commits you to a format that is tedious to migrate away from later. The first weeks also look worse than doing nothing, which is when most people abandon it.