What can you store in SQLite?

Can you store files in SQLite?

The limit of a SQLite database is something like 2TB. Your Android device will not have that much storage space. Thanks for the answer CommonsWare ...Stored the files in DB successfully . now have to check for libraries to display the .

What can SQLite be used for?

SQLite is often used as the on-disk file format for desktop applications such as version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, record keeping programs, and so forth. The traditional File/Open operation calls sqlite3_open() to attach to the database file.

What data types are supported by SQLite?

SQLite only has four primitive data types: INTEGER, REAL, TEXT, and BLOB. APIs that return database values as an object will only ever return one of these four types. Additional . NET types are supported by Microsoft.

Can SQLite store images?

Inorder to store images to android SQLite database, you need to convert the image uri to bitmap then to binary characters that is, bytes[] sequence. Then set the table column data type as BLOB data type. After retrieving the images from DB, convert the byte[] data type to bitmap in order to set it to imageview.