There is no way to save the image in DB

[skydread1]

Problem

There is no way to save image in DB (user profile pic, posts beside images).

Suggestion

Maybe we can use pantomime to convert the files in BLOB before storing in Datalevin DB.

This should happen only server side.

[robertluo]

Saving blob binary files into database is a common architecture error:

1. databases are not designed for arbitrary binary files, while filesystems are.
2. databases are good for storing structured data, such as meta data of files.

We notice that "files" are just structured data with binary contents, store them in database let it can be queried, while put the binary contents into a blob store -- normally just file systems.

• most time, filename (which is an ID for file system) will be an automatically generated string.

[skydread1]

Ok noted!

So, I think the steps could be:

• From url of image given by user, fetch it and convert to blob using pantomime (for instance)
• Store the blob in a blob store (aws s3 maybe)
• Store the blob name in datalevin db
• When needed, use the blob name taken from db to access the blob in the blob store (or use Cloudfront to get a url directly)
• Display the blob in the web page from cloudfront url or convert to png if accessed from s3