GSoC proposal for pgAdmin 4 bytea support

Dear PostgreSQL community,

I have submitted a proposal for the project pgAdmin 4 bytea support. The
project discusses storing media content (images, audio, video) as bytea.
However, I have a quick question. What does bytea data look like typically
when storing media content? What I had in mind is, media contents that uses
MIME type, which are rendered as part of HTML. For example, the following
is rendered as a red dot:

'data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAAUA
AAAFCAYAAACNbyblAAAAHElEQVQI12P4//8/w38GIAXDIBKE0DHxgljNBAAO
9TXL0Y4OHwAAAABJRU5ErkJggg==’

This string is decoded to bytea, and I stored it in a bytea column.

What are some other examples of using bytea to store media content, not
necessarily using the MIME type? Is there a way to detect the type of these
media (audio, image) stored in bytea?

Another question I had is, I read that there are performance-related issues
for storing media in bytea. Are there practical ways to store bytea data
that does not face performance-related issues? For example, storing large
media content using multiple bytea parts, and reassembling them together
once retrieved from the database?

Thank you,
Howard

https://docs.google.com/document/d/1ADkdj1Nnhzpy1HTqgs6c6nVPXvPBmwLaysmaNX9eFc0/edit?usp=sharing