Comment by out_of_protocol

> As my app matured, I found that I often wanted hierarchical folder-like functionality

(1) Slim table "items"

- id / parent_id / kind (0/1 file folder) integer

- name text

- Maybe metadata.

(2) Separate table "content"

- id integer

- data blob

There you have file-system-like structure and fast access times (don't mix content in the first table)

Or, if you wish for deduplication or compression, add item_content (3)