The decision to store as a blob was made a long time ago, and not by Trevius as far as I know. It is a convenient way to serialize a large struct all at once occasionally, but not a good solution when the data changes frequently as we appear to be seeing.
...or to query against it, or to gain performance benefits of indexing, or to maintain referential integrity, or to normalize the data to prevent repetition, or basically anything you use a database for.
I don't mean to sound so critical I would just really like to know what benefit is gained by doing it this way. Cause I can't think of a single one. I'm not saying there isn't one, and I have been known to overlook things before so I'm genuinely curious.
