Can images be stored using MySQL database?

[Ubuntu]

Is it possible? I'm wanting to create an image hosting website but I only got 5TB to work with, that may sound alot but it's used up in no time trust me, so I want some other way to store my images and maybe they could be rendered back to a jpg or other image file type when the user wants it?

 

[Adil]

You can, via MySQL's LONGBLOB datatype. However, this isn't recommended; store images in directories and then store a link/reference to the image in your database.

You must be registered for see links

You must be registered for see links

You must be registered for see links

 

[Ubuntu]

Well I was going to do that and I have before but my problem is it takes up too much space.

 

[Adil]

It'll take up the same amount of space (I think) in a database...
If you need to save space, compress the images before they're saved/uploaded.

 

[Ubuntu]

Well I tried that last time and the users didn't like that cause the quality was shit so I just took it off.

 

[Adil]

Well I tried that last time and the users didn't like that cause the quality was shit so I just took it off.

Have you tried lossless compression?

 

[TesoMayn]

The images would be the same size, and it would be foolish to do. Either store your images on your server, or use a CDN.

 

[GarettM]

I am a super noob so don't mind me but couldn't you convert the image to base64 then save the base64 string into the database then compress the image and save it in the directory that way you have a base64 image in the database and a compressed backup on disk. There has to be some kind of compression technique for images i have a desktop with a 1TB i don't use. You could use for testing

 

[TesoMayn]

Base64 would increase the size.

 

[GarettM]

Base64 would increase the size.

I didn't know that i just thought a string would be smaller then a image format