C#•3w ago

Save an image to a mysql

cmd = new MySqlCommand(query, con); cmd.Parameters.AddWithValue("@image", client.Image); I tried this method, but saved "System.Image.bitmap" on the database How can I save the image to the mysql database?

25 Replies

Luna•3w ago

btw my client.image variable is this: public Image? Image { get; set; } = image;

mg•3w ago

You'll want to store images with a service that's built for storing large amounts of binary data, not in your SQL database.

TizzyT•3w ago

can base64 encode it if all else fails

mg•3w ago

But what's happening is happening because ToString() is implicitly being called on client.Image, which returns the type name by default

Luna•3w ago

i'll try

mg•3w ago

You should be using whatever MySQL's type for binary data is

TizzyT•3w ago

yup i said if all else fails store as bytes or blob, etc

Luna•3w ago

yes, i'm using a binary type

mg•3w ago

And for smaller images it can be ok to store them in the database

Luna•3w ago

i can't, unfortunately also true The scope of this project, is for a local store

TizzyT•3w ago

then why not just move the images to a specific location and just store the path to it? is that not allowed?

Luna•3w ago

The problem is, if the computer breaks, the images gets lost forever

mg•3w ago

That's always going to be true

TizzyT•3w ago

isnt that the same if the db is hosted on the same computer?

mg•3w ago

What does storing them in a database solve

Luna•3w ago

and it was promissed to the client that everything will be have backup

TizzyT•3w ago

so the db is online gotcha

Luna•3w ago

not in this case, the db is online

mg•3w ago

I didn't say store them on the client's filesystem, I said store them somewhere that's designed for storing files

Luna•3w ago

i know, but i can't do this i'll try to convice my boss to buy AWS for images anyways, thanks

mg•3w ago

Fair enough, again if the images are small there's probably not a huge problem with storing them in the database Just make sure you're storing them in their own table

Luna•3w ago

worked converting to base64

 public static string EncodeBase64(Image image, ImageFormat format)
 {
     MemoryStream memoryStream = new();

     image.Save(memoryStream, format);
     byte[] imageBytes = memoryStream.ToArray();

     return Convert.ToBase64String(imageBytes);
 }

 public static string EncodeBase64(Image image, ImageFormat format)
 {
     MemoryStream memoryStream = new();

     image.Save(memoryStream, format);
     byte[] imageBytes = memoryStream.ToArray();

     return Convert.ToBase64String(imageBytes);
 }

TizzyT•3w ago

lol

Angius•3w ago

Just saying, but storing files in the database will be slow as shit Not only will it slow down your queries and bloat the db You'll be unable to use compression and caching

Luna•2w ago

agree

Gaming

Programming

Save an image to a mysql