nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqln5q8np5aezhtt7ztv6tah86xk4t3smjuchdvxp0u6uta056204qf4h82d (nprofile…h82d) nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqs0l2l0skj3k5czyrxgese57xy6ghmmkjv5hcs9a5ul0d8jrvq8vqxqnrc9 (nprofile…nrc9) I can't remember any raw sql I've written for pv2 yet, except for the table / index / etc creation logic.
the outermost parser function looks like this:
https://github.com/podverse/podverse-parser/blob/v5-develop/src/lib/rss/parser.ts#L43
going deeper, item parsing looks like this. the transactionalEntityManager is what makes the orm queries within these functions happen in a transaction:
https://github.com/podverse/podverse-parser/blob/v5-develop/src/lib/rss/item/item.ts#L197
and here's what the ItemAbout parsing looks like:
https://github.com/podverse/podverse-parser/blob/v5-develop/src/lib/rss/item/itemAbout.ts
and...
Mitch Downey :pci:
npub1yf…w6g6v
2025-02-22 01:37:40 UTC
in reply to nevent1q…n3wr
Author Public Key
npub1yfr5d05qj3qzz84kntze3c8accyz0unwczgm0fxuypuqdnenkwuqew6g6vSeen on
wss://relay.ditto.pubPublished at
2025-02-22 01:37:40 UTCEvent JSON
{
"id": "3ae7b25a6b47371fc7e39f66e66ef8ccd59c16ad28cd5926e6db194a45cfebd6",
"pubkey": "224746be809440211eb69ac598e0fdc60827f26ec091b7a4dc207806cf33b3b8",
"created_at": 1740188260,
"kind": 1,
"tags": [
[
"p",
"fce803cc34ee4575afc25b34bedcfa35aab8c372e62ed6182fe6b8bebe9a53ea",
"wss://relay.mostr.pub"
],
[
"p",
"83feafbe16946d4c088332330cd3c626917deed2652f8817b4e7ded3c86c01d8",
"wss://relay.mostr.pub"
],
[
"p",
"01b564093b88a80fa5269f27044e1dea1d832f56f9b40f2064a6ba39506f27e2",
"wss://relay.mostr.pub"
],
[
"p",
"7b13be03cb561b414dbc0ef33cc731a2d3f75f5bb9b1265dfa407abdad9f79ab",
"wss://relay.mostr.pub"
],
[
"e",
"8be22086579506c4b9a093fee1e6bb54597e5d59044538a81628878c116167be",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://podcastindex.social/users/mitch/statuses/114044977811108425",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqln5q8np5aezhtt7ztv6tah86xk4t3smjuchdvxp0u6uta056204qf4h82d nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqs0l2l0skj3k5czyrxgese57xy6ghmmkjv5hcs9a5ul0d8jrvq8vqxqnrc9 I can't remember any raw sql I've written for pv2 yet, except for the table / index / etc creation logic.\n\nthe outermost parser function looks like this:\n\nhttps://github.com/podverse/podverse-parser/blob/v5-develop/src/lib/rss/parser.ts#L43\n\ngoing deeper, item parsing looks like this. the transactionalEntityManager is what makes the orm queries within these functions happen in a transaction:\n\nhttps://github.com/podverse/podverse-parser/blob/v5-develop/src/lib/rss/item/item.ts#L197\n\nand here's what the ItemAbout parsing looks like:\n\nhttps://github.com/podverse/podverse-parser/blob/v5-develop/src/lib/rss/item/itemAbout.ts\n\nand...",
"sig": "5a33e6583b58b4a763f9dc647274a2090a379afab789bbef3e908b544c6eada4863dca34d092640436553f17e7b7533bea6e2d07337bf696ce174b3570d6d127"
}