Storing images and html in a database

Question

SQL

There is a project for Win Phone, which will be ported to other platforms in the future.

There is a SQLite base with logic and a set of keys (master base). They are lightweight and contain only enumerations of entities, indexes and their relationships.

For each of the entities in the master database, you need to store some previously unknown number of pictures and html pages.

The question arose, how to organize this repository?
A working option is a separate SQLite file where to store everything in blob fields. Plus - no need to worry about cross-platform and file structure. Minus - it is not entirely clear how to organize storage, given that the number of entities is not known in advance. It’s somehow not pleasant to make N tables and join them all, and the fields in one table are by definition limited in number.
Maybe there are simple cross-platform key-value stores? To store all data in one file. This option would be perfect for me.
Please advise in which direction to dig.

Answer 1

What's stopping you from making a key-value in sqlite?