Can we store .doc .pdf and .jpg files in SQLite Database (Android)?

android sqlite pdf .doc
Prasanth Perumal picture Prasanth Perumal · Mar 12, 2015 · Viewed 22.7k times · Source

Is it possible to store files like pdf doc in SQLite db and the retrieve them again successfully.the files must be intact and readable again.I know we can store image files but for the above??.

Even if we can store what will be the given max file size??

Answer

dcatteeu picture dcatteeu · Aug 28, 2017

Yes, go ahead. It is easier to store every file in the database, than just using the database to keep track of where each file is.

If the files are small, performance should be fine. From the SQLite website:

... many developers are surprised to learn that SQLite can read and write smaller BLOBs (less than about 100KB in size) from its database faster than those same blobs can be read or written as separate files from the filesystem. (See 35% Faster Than The Filesystem and Internal Versus External BLOBs for further information.) There is overhead associated with operating a relational database engine, however one should not assume that direct file I/O is faster than SQLite database I/O, as often it is not.

Related questions

Android - What are the good reporting tools to design and generate reports from SQLite Data Source?

I am working on Android database type application. We need to show some reports. My questions are: 1- How the reporting works on Android? 2- What are the good reporting tools to design and generate reports from SQLite data source? 3…

Read More
SQLite in Android How to update a specific row

I've been trying to update a specific row for a while now, and it seems that there are two ways to do this. From what I've read and tried, you can just use the: execSQL(String sql) method or the: …

Read More
How to delete all records from table in sqlite with Android?

My app has two buttons, the first button is for deleting record on user input and the second button is for deleting all records. But when I want to delete data it shows the message "Your application has been forcefully …

Read More