John Paul Grips on Nostr: tried to query the database for a specific post I made about 2 years ago and after ...
tried to query the database for a specific post I made about 2 years ago and after half an hour I don't know whether to complain about Pleroma's schema that stores data in slabs of raw JSON, or about ActivityPub's schema which probably caused that decision
Published at
2024-05-16 21:38:19Event JSON
{
"id": "e3d5f08ce81d6f0b4af174184e9008f8173101cc575e212d03a2dfbc11d90b8f",
"pubkey": "f51bfdc8460692883afe8809bf642ec7fef6fc760b30daf8bc2a71120c4830c1",
"created_at": 1715895499,
"kind": 1,
"tags": [
[
"proxy",
"https://cawfee.club/objects/1b57b0cc-764c-46b2-bb6d-bb80c44b3faa",
"activitypub"
]
],
"content": "tried to query the database for a specific post I made about 2 years ago and after half an hour I don't know whether to complain about Pleroma's schema that stores data in slabs of raw JSON, or about ActivityPub's schema which probably caused that decision",
"sig": "df323c7ee15a9fe2378b499cd059bafcf1e56c2ba9b3b2282dd001c7cdcd3c4d9b96727a488768e365733eeb5db77eeecb71ece8655d137fc60741c1c2123f93"
}