Trying to figure out how to use the <podcast:person> tag with database relationships...
Since Adam Curry is one person, at first glance it seems like I would want a singular "Adam Curry" person row in a table, and that row gets referenced to many channels and items.
But it doesn't look like <podcast:person> is meant to be used this way, or I imagine it'd have a guid.
I guess we will save person with each channel and item row, and for a "list all by person" feature, we'll need special handling
Mitch Downey :pci: /
npub1yf…w6g6v
2024-08-09 02:35:50
Author Public Key
npub1yfr5d05qj3qzz84kntze3c8accyz0unwczgm0fxuypuqdnenkwuqew6g6vPublished at
2024-08-09 02:35:50Event JSON
{
"id": "0c4ab9f8b215ca081961895c11687c7a95a10cc3dcea4d3e6e840dddea7b8128",
"pubkey": "224746be809440211eb69ac598e0fdc60827f26ec091b7a4dc207806cf33b3b8",
"created_at": 1723170950,
"kind": 1,
"tags": [
[
"proxy",
"https://podcastindex.social/users/mitch/statuses/112929731400406763",
"activitypub"
]
],
"content": "Trying to figure out how to use the \u003cpodcast:person\u003e tag with database relationships...\n\nSince Adam Curry is one person, at first glance it seems like I would want a singular \"Adam Curry\" person row in a table, and that row gets referenced to many channels and items.\n\nBut it doesn't look like \u003cpodcast:person\u003e is meant to be used this way, or I imagine it'd have a guid.\n\nI guess we will save person with each channel and item row, and for a \"list all by person\" feature, we'll need special handling",
"sig": "0c7c411e8765615ce0997675faba1683fd19a72eab131184dcf3a4a6e14b133767dbe6d158582e92c13e63054d134c1ea1472c641bc8718add684a75129c6812"
}