What is the best way to store images in a database (base64 or locatino/img.png)?

Question

Django

Now I am modeling a database, for the first time in a pet project I use the ability to upload images by the user.
There was a question of a choice of storage of images.
Which option to choose?
1. base64 string in the database, then there will be a heavyweight database, but calculations will be only on the front
2. image location, but then in addition to calculations on the front there will be calculations on the backend (get the string, convert it to an image and save it to a folder, save the directory to the database) and on the output (take the location from the database, convert the image to base64, send the string to the front), and the directory will be too heavy.

Answer 1

If you do not know how, then definitely - ImageField, you have Django.
If you want to store all these in the database (which means you understand exactly why), then why are there any intermediate base64-type formats to take up more space? Store in binary, but once again, this is only if you can clearly explain why in the database.

Answer 2

Вот так например https://www.regex101.com/r/BEn6W7/1

Answer 3

"SIP/rosnet_6651560/808080808080,300,Tt".split('/').pop().split(',')[0]

Answer 4

$string = "SIP/rosnet_6651560/808080808080,300,Tt";
\preg_match('/\/([\d]+)\,/', $string, $result);
echo $result[1];