Michael Vogel on Nostr: Jools The entries in the photo table are always there. Only the location changed. And ...
Jools (nprofile…48rj) The entries in the photo table are always there. Only the location changed. And the storage table doesn't shrink by itself. You have to execute optimize on it an SQL console to actually remove all the deleted parts.
Published at
2025-03-02 15:49:03Event JSON
{
"id": "4da9704ba7f00431b67b6404653e12b908fefd427000bd048e11e4b99be25589",
"pubkey": "9d890fa7852c95a6cfdac237f1267882e5d8779fef504115edea5e32bc7369d1",
"created_at": 1740930543,
"kind": 1,
"tags": [
[
"p",
"8ad95b24c2aa43473abc4f30abbab2364280b2ead8b5f28b4b614c12a63897c8",
"wss://relay.mostr.pub"
],
[
"p",
"15b7758904cd6ec9c4d780aed7cca01019b61be45945dea8a68e2d2322a45ecd",
"wss://relay.mostr.pub"
],
[
"e",
"bd747396c732f73f0362732c6fcf32d5afd5f29253857df74e80c7ebd4a8c3d2",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://pirati.ca/objects/ec054ce7-2067-c47d-efbc-a7b999780979",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpq3tv4kfxz4fp5ww4ufuc2hw4jxepgpvh2mz6l9z6tv9xp9f3cjlyqp948rj The entries in the photo table are always there. Only the location changed. And the storage table doesn't shrink by itself. You have to execute optimize on it an SQL console to actually remove all the deleted parts.",
"sig": "c5611009f22fa429454cbae1d6da8e405234f65c404873a43fdd96fbd9e648d08ba200ab20afece58b6800d39e634bc719bf9415b7cb0cb2e405c37a8974d4b7"
}