Columns: One Simple Trick to Avoid Scaling
00plugin.net1 pointsby tsewlliw0 comments
with recursive cte (udo_id, prv, nxt, label) as (
select *
from udo
where udo_id = :first_item_id
union all
select u.*
from udo u
join cte
on u.prv = cte.udo_id
) select * from cte limit 100
I haven't seen folks make the change in formal role. I have seen folks take on the role, and I've taken it on myself (not my fave) with moderate success to make things happen.
Biggest advice: support the people in producing good outcomes, any processes should serve that. But the people create the outcomes, the process is a disposable tool.