I'm doing an application on Python 3 communicate with the DBMS MariaDB. The application is not on the same computer as MariaDB.
I'm trying to play INSERT images in a table using the function LOAD_FILE (file name), but it only executes correctly when the image is on the machine where the DBMS is hosted, and with file name pointing to the directory of the image.
Until now, the only suggestion I've found is to convert the image file to hexadecimal and write the result in the table.
I'm using a variable of type LONGBLOB.
If anyone knows the opposite, I will be grateful!