way to insert base64(from image) string to mysql table

Asked Feb 21 '18 at 15:17

Active Feb 21 '18 at 15:17

Viewed 731 times

i have node js server using Mysql. and a client(iphone, android phone) send base64 encoded(from image) string to my server.

in my server, what is best way to insert base64 string to table?

just insert origin base64 string to column MEDIUMTEXT.
after convert base64 to a blob like this(gist.github.com/fupslot/5015897), insert blob data to column MEDIUMBLOB.

asked Feb 21 '18 at 15:17

dh0rmfpdlxm

2

it depends on other things, like, what do you want to do with it once stored server-side? what do you need most, speed or light weight? etc. – Kaddath Feb 21 '18 at 15:21
1

Possible duplicate of https://stackoverflow.com/questions/17/binary-data-in-mysql? – mfkw1 Feb 21 '18 at 15:31
@Kaddath thank you for answer! i need speed. – dh0rmfpdlxm Feb 22 '18 at 09:36
@kubawal thank you for answer! you mean that you recommend way 2? – dh0rmfpdlxm Feb 22 '18 at 09:39
Yes. Converting from base64 everytime will result in performance overhead – mfkw1 Feb 22 '18 at 09:46
@kubawal thank you~~ – dh0rmfpdlxm Feb 22 '18 at 14:58

0 Answers0