bruh/a1ba (nprofile…3utp) lain (nprofile…t3h7) silverpill (nprofile…nptm) meso (nprofile…5vpa) Blurry Moon (nprofile…tsag)
>Not to mention the JSON-in-PostgreSQL being pain in the ass every time something wrong happening to it
That's just ActivityPub being ActivityPub. You can't normalize a barely structured document into columns. Best you can do is pull out certain normalized values into separate columns and have a hybrid schema. Which the indexed jsonb stuff basically does anyway.
I think that is also where the whole rewrite Akkoma DB backend for Cassandra came from.
Phantasm
npub1er…farq5
2026-07-17 10:29:55 UTC
in reply to nevent1q…eajy
Author Public Key
npub1er26g8v2gdquxkyk43usmlk7gaqhle08p378ld3ldfd6p5yrt8usmfarq5Seen on
wss://relay.ditto.pubPublished at
2026-07-17 10:29:55 UTCEvent JSON
{
"id": "96885e3c7b7cf37ce59629b0e457b5c467760a8940b4f0a85ec2bdacd780ec9a",
"pubkey": "c8d5a41d8a4341c35896ac790dfede47417fe5e70c7c7fb63f6a5ba0d08359f9",
"created_at": 1784284195,
"kind": 1,
"tags": [
[
"p",
"288059249d3068d2994e16ca1aa07ec4db75f434042952e536305c8ea1ce16a9",
"wss://relay.ditto.pub"
],
[
"p",
"776ed1a547e2693a2c964e4824d6306a11aa364cd9c798f3e1ccd638af3d3725",
"wss://relay.ditto.pub"
],
[
"p",
"6a5f35dc281276c30c527e1240ef6bad3ef27bcf92b4fef017dc7f5a5c31e5ec",
"wss://relay.ditto.pub"
],
[
"p",
"fc3e392a448560dc0e9ffa75b38cd96fe59020794aea529cd312f4b90473ca1c",
"wss://relay.ditto.pub"
],
[
"p",
"05de5f2d3b8d98f9b929695080ae6aa51b14f00dc122eef1d40d502a0ab48154",
"wss://relay.ditto.pub"
],
[
"e",
"a0487318e25ccf2521bd909fad947573e37dcb0d48a375212351ff2c0e644505",
"wss://relay.ditto.pub",
"reply"
],
[
"proxy",
"https://fluffytail.org/objects/c96226ca-0041-4518-9a9a-5426b3a15ac4",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpq9zq9jfyaxp5d9x2wzm9p4gr7cndhtap5qs549efkxpwgagwwz65sx63utp nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqwahdrf28uf5n5tykfeyzf43sdgg65djvm8re3ulpentr3teaxujs9vt3h7 nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqdf0nthpgzfmvxrzj0cfypmmt45l0y770j260auqhm3l45hp3uhkqvrnptm nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqlslrj2jys4sdcr5llf6m8rxedljeqgreft4998xnzt6tjprnegwql55vpa nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqqh097tfm3kv0nwffd9ggptn255d3fuqdcy3wauw5p4gz5z45s92qjctsag\n\u003eNot to mention the JSON-in-PostgreSQL being pain in the ass every time something wrong happening to it\n\nThat's just ActivityPub being ActivityPub. You can't normalize a barely structured document into columns. Best you can do is pull out certain normalized values into separate columns and have a hybrid schema. Which the indexed jsonb stuff basically does anyway.\n\nI think that is also where the whole rewrite Akkoma DB backend for Cassandra came from.",
"sig": "1ce6e0981e6728724403c29a7fb8b8f2096ad022978139a067a0d7028d106f90516a8ecd58f6b44a241d32ef0dd39c7b9733cbf553c85b1ba5ff3c638a3808f1"
}