That isn't very complex, but things get complicated when a music feed contains tracks that have an "episode number", and tracks that do not have an "episode number". Where do the non-numbered tracks go in the auto play order?
To handle this, I (::cough:: llm) wrote the query to handle all tracks in a music feed that do not have an episode number as if it had a season of -1, and to sort those by pub_date, while the sort for properly numbered tracks get handled as normal.
https://github.com/podverse/podverse-orm/commit/3470108ab6c81de9dac9a1f0a7c9fd6bbc810ffa#diff-c3343c792900d109ee2695d00313b8b2e68844b2d088a3271b7527b4c88d459eR384
Mitch Downey :pci:
npub1p7…lqql0
2025-12-15 20:58:11 UTC
in reply to nevent1q…ndjn
Author Public Key
npub1p7v0a3mgwgqkhyuuwwrdf7kyt8c0gker3asa4lp0l626p0f3ck5sklqql0Seen on
wss://relay.momostr.pinkPublished at
2025-12-15 20:58:11 UTCEvent JSON
{
"id": "0a8a36ff67b2ab6b826c33a09dfd70fd5728a78b5452066ec43f26a67f4ebb25",
"pubkey": "0f98fec76872016b939c7386d4fac459f0f45b238f61dafc2ffe95a0bd31c5a9",
"created_at": 1765832291,
"kind": 1,
"tags": [
[
"e",
"e611d9108611a48019b0a21649442e49bbf148f3f05a2eb911f953cc1feb3ef1",
"",
"root",
"0f98fec76872016b939c7386d4fac459f0f45b238f61dafc2ffe95a0bd31c5a9"
],
[
"p",
"0f98fec76872016b939c7386d4fac459f0f45b238f61dafc2ffe95a0bd31c5a9"
],
[
"proxy",
"https://podcastindex.social/@mitch/115725585071268325",
"web"
],
[
"proxy",
"https://podcastindex.social/users/mitch/statuses/115725585071268325",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://podcastindex.social/users/mitch/statuses/115725585071268325",
"pink.momostr"
],
[
"-"
]
],
"content": "That isn't very complex, but things get complicated when a music feed contains tracks that have an \"episode number\", and tracks that do not have an \"episode number\". Where do the non-numbered tracks go in the auto play order?\n\nTo handle this, I (::cough:: llm) wrote the query to handle all tracks in a music feed that do not have an episode number as if it had a season of -1, and to sort those by pub_date, while the sort for properly numbered tracks get handled as normal.\n\nhttps://github.com/podverse/podverse-orm/commit/3470108ab6c81de9dac9a1f0a7c9fd6bbc810ffa#diff-c3343c792900d109ee2695d00313b8b2e68844b2d088a3271b7527b4c88d459eR384",
"sig": "7a4b4d9330050bd128d5d58df4b4f2e4cc4005aa7c2d52a7a3e8fa2ce8d9ef4460ab3ce7bbfd3b6772eb2fb7bacc7252018da657e8a584d17418971b06ad9e38"
}