missing: sample for BLOB/LONGVARBINARY/LONGVARCHAR handling
That would be quite interesting, also because it is partially different between databases and precompilers.
So far I've seen no BLOB handling but handling of huge VARBINARY/LONGVARBINARY (but also there: no sample of how to use it), and the "text" variants VARCHAR/LONGVARCHAR.
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information