add Image in SQLite Browser to cell (BLOB) and open in Android

Excuse me please, I cant find some tutorial on the web, how can I in SQLite add an image to database to BLOB field, is it possible please? :sign0013:

Please very much for understanding me, I have read SQL tutorial, I have read SQLite documentation but I cant find it....
Thank you

Hi petr4ppc,

I don´t know if it is a good idea storing pictures in databases... I always store the path in the database keeping the database as small as possible.

Fatman

There is an example in the SQL tutorial.

Dear FATMAN,

thank you very much for your answer, because I am sitting over this trouble second day and I belive that it is very simple....It is very nice and interresting advice and I can realize your advice now, it is simple and smartexample....

BUT

I cant add image to database in SQLite Browser....SQLite browser allow add only *.txt format of files...I dont know how to add image as file to database via SQLite Browser :BangHead:

this make me sad...I belive that it must be easy :BangHead:

please for advice how can I do this....
Best regards
p4ppc

DEAR Erel....thank you for your answer...I have read all examples SQL, I am writing here after reading tutorials and examples....but there is not written how to add image in SQLite Studio.....no via andorid code but in real SQLite studio....I cant find it.
Yes..I know that you have written often in forum, that we must have all OK in writting side, that we must have temporary file....but this is for example when we want add image to database via basic4ppc code

Thank you and best regards
p4ppc

Sorry I missed that. I'm not familiar with SQLite Studio.

Use Firefox and the add-on "SQLite Manager". Think this can handle Blobs.

EREL
Do not apologize, you are doing all for us. Thank you
FATMAN
Thank you very much for your advices, I will try addon in firefox and in second example I use your advice with URL to picture in database

I give up add image to DB in real SW SQLite :sign0148:

THANK YOU
BEST REGARDS
p4ppc