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