storing image in blob vs text?

[Jassim Rahma]

Hi, I want to ask what's the best way to store images in MySQL size-wise and performance-wise? is it better to store it as blob or as base64 text? Thanks, Jassim[^]

Technology News @ www.JassimRahma.com

[Mycroft Holmes]

Don't store file data in the database, store it in the file system and have the file name in the database only. Just my 2c!

Never underestimate the power of human stupidity RAH

[Lost User]

Converting your blob yo base64 will cost time, and the result would be somewhat bigger.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

[Lost User]

If it is relational data, then it should be in the datastore :thumbsup:

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)

[Jorgen Andersson]

Here's[^] a research document from Microsoft on the subject. The tl;dr is that it's size dependent. For smaller files it's better using a database, for larger files it's better using the file system. And the breakeven is somewhere around 0.1 - 1 MB, depending on your system. Possibly larger nowadays since there has been a bit of development since the paper was written.

Wrong is evil and must be defeated. - Jeff Ello

[david_smith01]

TEXT is a data-type for text based input. On the other hand, you have BLOB and CLOB which are more suitable for data storage (images, etc) due to their larger capacity limits (4GB for example). As for the difference between BLOB and CLOB, I believe CLOB has character encoding associated with it, which implies it can be suited well for very large amounts of text. BLOB and CLOB data can take a long time to retrieve, relative to how quick data from a TEXT field can be retrieved. So, use only what you need. =============== Parse Migration Services