binary data in database, blob vs compressed base64

Question

There is a column type named blob in database, and it is used to store binary data.

But more often than not, I see solutions which compress binary data, then convert binary data to base64, and store base64 string as varchar or text in database.

Python code example:

import zlib, base64
base64_str = base64.b64encode(zlib.compress(binary_data, 9))

So there are two ways to store binary data into database:

as blob
as compressed base64

My Questions is: Which way is better and why?

I don't see why anyone would use method 2. It introduces needless complexity and obfuscates the data twice. However, I won't post this an an answer because I don't have any hard evidence that there are no cases where compressed base64 is beneficial over BLOB. — Polynomial
– Polynomial, Commented Nov 21, 2011 at 10:26

Robin James · Accepted Answer · 2019-12-02 13:13:14Z

22

It seems that I have to answer my own question. Most of the time, storing compressed base64 into database is not a good idea. It is more complex than storing blob. And most of the time binary is smaller than base64 string.

I only find one case that compressed base64 is useful: you can't alter the table schema, and there are only text columns, thus you have to store binary data into that table. The only possible way is to convert binary to base64 string.

edited Dec 2, 2019 at 13:13

Robin James

476 bronze badges

answered Nov 23, 2011 at 1:37

Tyler Liu

20.5k12 gold badges105 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ashfaq Hussain Over a year ago

Didn't know you could answer and accept your own question but well done!

itsraghz Over a year ago

@AshfaqHussain, it is a very well accepted patter in SO (Stack Overflow). One can answer his own question and accept it as long it was a valid solution.

Collectives™ on Stack Overflow

binary data in database, blob vs compressed base64

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related