Re:The data model behind Notion's flexibility
by jitl on Tuesday May 18, 2021 @06:35PM
(#27202165)
Ltree is interesting, but if I understand correctly, to move a parent block, I'd also need to update the path column in all the child blocks -- at our scale such write amplification is a non-starter.
http://patshaughnessy.net/2017/12/13/saving-a-tree-in-postgr...