Image saving to / Reading from an SQlite database

Discuss
#1

Hello everyone !

I’d like to know how to insert an image to my SQLite table (i’m using Taifun SQLite extension).
I’ve read that I need to use the BLOB typeto save image to DB but I wonder how to convert my image to a such type :confused:
I also need to read the image from the DB.

Can someone give me some help please? :stuck_out_tongue:

EDIT: ok it seems that to do what I want, I have only 2 solutions :

  • use Cloudinary or Firebase online database to upload images (but need to be online)
  • store image on device and only save path to database (better solution for me because I want an offline app).

I am right ?

#2

Yes you can do so,

If you are storing the file path in database rather you can store the file path in tinydb, so your app becomes offline

#3

Hello @Soham_Shah :slight_smile:
As I will use an SQLite DB, I will store them into it :wink:

#4

If you want a offline app then to set/get data from database it will need internet connection.

#5

???
My .sqlite db is embeded on my device :neutral_face:

Why sould I be online to connect to a local database ?

#6

You don’t need internet …

#7

:sweat_smile:
First good news of the day, thanks @Rogerio_Rios

#8

Actually I don’t know about that :sweat_smile:

#9

You should mark your first post as solution @stefun as you had only cleared your doubt in the first post

#10

You can’t mark first post as solution :sweat_smile:

#11

¿How do you store an image into SQLite? I need to resolve the same problem.
Thanks!

#12

Did you try to save your image path in the bank?

#13

Not yet, but I thougth we can save an image into SQLite as blob.

#15

Did You searched ? What are you failing to do?

#16

I´m searching and i´ve found it

image
image768×126 7.71 KB

But I don´t find the how to…

#17

Hello @Proyecto_Freelance, if you find some stuff, please share. I’m still wondering hot to store image in SQLite ! :confused:

1 Like
#18