pwm on Nostr: How normalized are you gonna make em? If you are okay to stick to something like ...
How normalized are you gonna make em? If you are okay to stick to something like postgres as your back end, then you are able to just shove the JSON directly into json or jsonb fields. Pleroma does this for AP events. Postgres has extensive support for manipulating and querying the JSON objects that you shove into it
Published at
2023-03-18 21:48:06Event JSON
{
"id": "47d8e8b416a7a4522dd0b4a5b3e4026659e931f821976027bd84308abfbc18d7",
"pubkey": "3baabe4d008648b5438bfe3180e3d443cbc36478fbabb65007099a96a1c56922",
"created_at": 1679176086,
"kind": 1,
"tags": [
[
"e",
"6b72b73f963f97268bba1e79d19af5522859cbaf670a03073245dc808762dfc7",
"",
"root"
],
[
"p",
"d5eb1db13d9a77065907d310070eb7568ff5457a7c6aee7f216bf75945b62161",
""
]
],
"content": "How normalized are you gonna make em? If you are okay to stick to something like postgres as your back end, then you are able to just shove the JSON directly into json or jsonb fields. Pleroma does this for AP events. Postgres has extensive support for manipulating and querying the JSON objects that you shove into it",
"sig": "0182e24eae3ba3601ba8df01c0f86180ada80e379ea7e8e0e7386e35ca1c3f018579c871c1333cbfa18492020cf8b489bc15c1b9a1c714eb8655ab3e847d1a5e"
}
