fred icon indicating copy to clipboard operation
fred copied to clipboard

Storing Fred Data

Open sottwell opened this issue 4 years ago • 2 comments

Is there any thought to eventually storing the Fred data in a custom database table?

Stuffing it all into the resource's properties field makes me nervous.

sottwell avatar Feb 11 '21 19:02 sottwell

Hi Susan, genuinely curious as to the concern about using a column vs a dedicated table?

rthrash avatar Feb 11 '21 19:02 rthrash

For the same reasons that MIGXdb and custom resource types and the various tagging packages were developed. For one thing, custom tables for custom data fields are more efficient for filters, searches and sorting. TVs are not really good for that, and a single large JSON string isn't either.

sottwell avatar Mar 16 '21 22:03 sottwell