I am not real familiar with BLOB fields. One of my departments has a table with a BLOB field that contains a photo for each record. This BLOB field is a recent addition to the table. The way I currently make the layer and connect the photo in AGO is a spatial view to create the needed points, and the photos are hosted on a web server and are linked via a url in the popup.
The photos were migrated from the web server to the database into the table's BLOB field. What is the best approach for retrieving that photo stored in the table's BLOB field to be displayed in a popup in an AGO web map/app?