Do something with this column changes query

[simonw]

This query shows which columns are most frequently updated, ignoring those for version = 1

select columns.name, count(*)
from item_changed
  join item_version on item_changed.item_version = item_version._id
  join columns on item_changed.column = columns.id
where item_version._version > 1
group by columns.name
order by count(*) desc

Maybe turn this into a view?

[simonw]

I used this in my blog post: https://simonwillison.net/2021/Dec/7/git-history/