The simplicity of tree-navigation in "closure" is pretty amazing: https://github.com/nalgeon/sqlean/issues/27
Given that SQLite supports huge sizes for text, you could almost use the above as a way to create an outliner, with everything stored in the database itself ...