Anyone interested in RSS + Podcasting 2.0 and relational databases?
It is still a draft (it hasn't been tested), but we have a Postgres SQL file for creating ALL of the RSS + Podcasting 2.0 related tables.
This could be split into many more files for readability, but we're keeping all RSS related table logic in one file for now.
https://github.com/podverse/podverse-ops/blob/database-schema/database/migrations/0001_init_podcasting_20_database.sql
Mitch Downey :pci: /
npub1yf…w6g6v
2024-08-18 20:48:00
Author Public Key
npub1yfr5d05qj3qzz84kntze3c8accyz0unwczgm0fxuypuqdnenkwuqew6g6vPublished at
2024-08-18 20:48:00Event JSON
{
"id": "94586b50cee071dd41a4e631f5036d55acd9f7e9cb2f73f607202b8ae9684cac",
"pubkey": "224746be809440211eb69ac598e0fdc60827f26ec091b7a4dc207806cf33b3b8",
"created_at": 1724014080,
"kind": 1,
"tags": [
[
"proxy",
"https://podcastindex.social/users/mitch/statuses/112984986758617811",
"activitypub"
]
],
"content": "Anyone interested in RSS + Podcasting 2.0 and relational databases?\n\nIt is still a draft (it hasn't been tested), but we have a Postgres SQL file for creating ALL of the RSS + Podcasting 2.0 related tables.\n\nThis could be split into many more files for readability, but we're keeping all RSS related table logic in one file for now.\n\nhttps://github.com/podverse/podverse-ops/blob/database-schema/database/migrations/0001_init_podcasting_20_database.sql",
"sig": "fe34a571bd3b79df1acec5bdd869afe7102a3fbbe2f1b1ff98f8fbb6d5135406164cf3f4dbf322cca973229c5e24aa2a7eedfe0b7d3d98141ac885d0aabb8cbb"
}