87. Handling movie images in an SQLite database

If you have not done so already, you must complete the previous two problems before continuing with this one. For this problem, we must extend the database model with an additional table to store images and possibly other media files, such as videos. The actual content of the media files must be stored in a blob field, but other attributes, such as description and filename, should also be stored.

When you are using large objects you have two options: either store them directly in the database as blobs or keep them in separate files and store only the file paths in the database. According to the tests performed by the developers of SQLite, for objects smaller than 100KB, reads are faster when ...

Get The Modern C++ Challenge now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.