Whats the recommended column type for images? I wa...
# prisma-client
n
Whats the recommended column type for images? I want to store potentially an image URL and a base64 encoded string. Currently I have it set to
image      String?      @db.Text
n
I would suggest storing an image URL, storing an image to a Blob Store something like AWS S3 and storing its reference. What database are you using, if you are using MySQL, you could use
@db.LongBlob
to store base64 string Reference: MySQL Mappings
n
Thanks for the recommendation! I ended up going with an image blob store (imagekit, similar to cloudinary) and just storing its reference 👍