I'm building a mobile app with a Retool database as main datasource.
I'm storing items into a table sku, and for each item I store an image taken with the mobile image input.
The image is stored into a S3 bucket because it seemed like the easiest way, but it doesn't seem very practical (or I don't really know how to do).
The main issue is retrieving the images for a list of skus I retrieve from the a database query like
SELECT * from sku. it would be great have a way of storing or retrieving all the images as well in order to display the image in a collection list component with the image.
Any idea on how to design this ?
I thought of building a workflow to make requests to S3 to retrieve the image for each but it seemed a bit overkill and I'm concerned it would slow down the app.
IMO the most convenient would be a way of storing this inside retool but I didn't find how
Otherwise I feel like I could store the amazon S3 bucket file image link in the database, but I don't find any link on the amazon S3 bucket file that would let this possible.
Any help would be appreciated, thanks in advance !