image encoding and decoding in mysql using python

Question

i am trying to read the image as input and convert this as base64 type and store it into mysql db.

and again read the base64 string from mysql and send the data as response to front-end.

what i tried so far is:

with open('/home/user/Desktop/image1.png', 'rb') as binary_file:
    binary_file_data = binary_file.read()

i am storing binary_file_data value into mysql blob column.

is this correct way to store base64 in mysql?

and how to read this base64 data from mysql and send as response to front-end in python?

any suggestions please.

Bill Karwin · Accepted Answer · 2020-12-07 04:25:59Z

1

You don't need to use base64 to store binary data in a BLOB data type.

Encoding in base64 transforms three bytes of binary data into four bytes of base-64 encoded characters, so it can use only printable ASCII symbols. By doing this, it increases the total size of your data by 33%.

BLOBs can store full 8-bit bytes, and they don't care about bytes that are unprintable. So you can just store the bytes as-is.

That is, once you load the content of your image file into your variable binary_file_data, then just store that directly into the BLOB column using the INSERT SQL statement. Don't encode it.

Re your comments:

The way http works is that each image is a separate http request, so you need to make another PHP script to fetch the BLOB from the database and echo it:

<?php

header('Content-Type: image/png');

// query BLOB data from database

// echo BLOB data

Then in your main PHP script that outputs HTML, you reference the one that reads the image from the database:

<img src="/myimage.php">

As long as the PHP script sets the content-type, it works just as well as reading the image file from disk.

edited Dec 7, 2020 at 4:25

answered Dec 7, 2020 at 3:47

Bill Karwin

568k87 gold badges711 silver badges872 bronze badges

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

2 Comments

user6325753 Over a year ago

Thanks for the quick response, storing into mysql okay, but how can i send base64 data to front-end?

Nour-Allah Hussein Over a year ago

Then store data in an image file and link it viahtml or any other method.

Collectives™ on Stack Overflow

image encoding and decoding in mysql using python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related