API optimization
I suggest the following optimizations of the API:
Preserving the attribute values in JSON output
Right now attribute values of relationally linked tables are shown in the apps, and exported as csv, but do not show up in the API. This is a pity as we are trying to use MementoDB as a field database for input into a (much more complex) RDF system. Preserving the attribute values would enormously facilitate work.
e.g.
{
"id": 27,
"name": "actors",
"type": "entries",
"value": [
"JlpXMTxIMk8obyFJSiF3ZGhlVGQ",
"Rls2KjptWjhuVVtbaDdGRlBAcUY",
"JlpXMTxIMk8obyFJSiF3ZGhlVGQ"
]
}
The strings "JlpXMTxIMk8obyFJSiF3ZGhlVGQ" etc. are the actor IDs of the relationally linked table, but the attributes specified (different @role=supporting, @role=main_character) are not showing up.
I would prefer to see something along these lines instead:
{
"id": 27,
"name": "actors",
"type": "entries",
"value": [
{"actor": "JlpXMTxIMk8obyFJSiF3ZGhlVGQ","role": "main_character"},
{"actor": "Rls2KjptWjhuVVtbaDdGRlBAcUY","role": "supporting"},
{"actor": "JlpXMTxIMk8obyFJSiF3ZGhlVGQ", "role": "supporting"}
]
}
Many thanks!