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.
Just depends what you are going for, really
pwm /
npub18w…2dnvc
2023-03-18 21:57:01
in reply to nevent1q…ghf8
Author Public Key
npub18w4tungqseyt2sutlcccpc75g09uxerclw4mv5q8pxdfdgw9dy3qr2dnvcPublished at
2023-03-18 21:57:01Event JSON
{
"id": "fd653e5d7d18e57b57237b6ff109e4d153d580b29722e9318b784fa48cbb3bab",
"pubkey": "3baabe4d008648b5438bfe3180e3d443cbc36478fbabb65007099a96a1c56922",
"created_at": 1679176621,
"kind": 1,
"tags": [
[
"p",
"d5eb1db13d9a77065907d310070eb7568ff5457a7c6aee7f216bf75945b62161"
],
[
"e",
"6b72b73f963f97268bba1e79d19af5522859cbaf670a03073245dc808762dfc7",
"wss://relay.damus.io/",
"root"
]
],
"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.\nJust depends what you are going for, really",
"sig": "24d6e3178d80534f6f002a0255106a286c73974d8dbadf22cade8d7a52d77515347d90debaca573f4eef8ffe38cd91e2d84cd998ab4a2e1fde75c307e2fe369f"
}