Franco (Castamatic) on Nostr: npub1ln5q8…5xyw6 I would just turn the records for removed episodes in tombstones. ...
npub1ln5q8np5aezhtt7ztv6tah86xk4t3smjuchdvxp0u6uta056204q45xyw6 (npub1ln5…xyw6) I would just turn the records for removed episodes in tombstones. Add a bool field “removed” to the episode table. The field defaults to false at record creation, and is turned to true when the episode is no more in the feed. All other APIs should filter for episode.removed == false.
As a bonus once a week you can purge all episodes where removed == true in one pass to free db space.
Published at
2023-07-17 13:33:31Event JSON
{
"id": "3413867bd7ae1bf3cfe044f31a6c5c35c418cf11317879fd5561e23547283c30",
"pubkey": "e9b8f5a97b890f8a4deee76d90b908c0bd0475a17530fd3fa2fa4355e2ed2f1e",
"created_at": 1689600811,
"kind": 1,
"tags": [
[
"p",
"fce803cc34ee4575afc25b34bedcfa35aab8c372e62ed6182fe6b8bebe9a53ea",
"wss://relay.mostr.pub"
],
[
"p",
"01b564093b88a80fa5269f27044e1dea1d832f56f9b40f2064a6ba39506f27e2",
"wss://relay.mostr.pub"
],
[
"e",
"1065f95f3d6ab498d3bbe4a032ced3950d2398d65952323c21e327e4a72c672d",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://podcastindex.social/users/francosolerio/statuses/110729678804267008"
]
],
"content": "nostr:npub1ln5q8np5aezhtt7ztv6tah86xk4t3smjuchdvxp0u6uta056204q45xyw6 I would just turn the records for removed episodes in tombstones. Add a bool field “removed” to the episode table. The field defaults to false at record creation, and is turned to true when the episode is no more in the feed. All other APIs should filter for episode.removed == false.\n\nAs a bonus once a week you can purge all episodes where removed == true in one pass to free db space.",
"sig": "58cc4e4e12aa7b67d53d26899c46558af8075b4c3163ba0e9043a306e587ad25fb6c10ba07bc045cd11fe9d7971848e9a0f42cfc5a7f66a3c30e8d736b86b1b4"
}
