CODEWITHSUNDEEP
androidsqlimagenvarcharvarbinary
Nagendra Hari Karthick
Nagendra Hari Karthick

Reputation: 483

Image storing in SQL DB from Android

I would like to create an application which accepts image in android convert it to base64string. The resulting base64 string will be sent to the rest API where it is converted to byte array and store in SQL DB. Is this the best possible way to store image in SQL DB or there any other possibilities?

Upvotes: 1

Views: 94

Answers (2)

Omar Dhanish
Omar Dhanish

Reputation: 875

This is My way , I will just say in simple way .first i create global path like "yourpath/"

then I Get image from server and Store it in device storage in the global path

then I Store only image name like imagename.jpg to the sqlite

at last I use image name stored in sqlite and concatenate with global path to display images whenever I want

Upvotes: 0

user681574
user681574

Reputation: 553

Better practice is to store the string of the location on the filesystem where the service that executes your database call is hosted. When you retrieve the 'image' you retrieve the location and use that to pull back the image from the file system rather than storing the entire binary on the database.

Upvotes: 1

Related Questions