open source developer @ podverse.fm / fediverse / foss / javascript / node.js / podcasts / react / react native / typescript
⚡️:mitch@getalby.com
| Podverse | https://podverse.fm |
| Github | https://github.com/mitchdowney |
After making a huge Postgres database schema with many join tables...I am finally learning about "Cartesian product" issues 😣
And hoo boy...I am not seeing any appealing ways to handle this.
I have an "item" table, I want to query for one item, and in the screenshot are all the related tables I want to include data from with the result...but apparently the OneToMany relationships (all the tables that end with "s" in this case) cause exponential complexity. Not sure what to do...
This is what a lot of my programming looks like today:
"write a QueueResourceItemController with methods that correspond with each of them in the QueueResourceItemService"
and from that Copilot spit out 102 lines of code. In this case it happened to work first try, using patterns already set in other files for the project.
You still have to review the code manually, but its amazing how well it handles some types of work. It's kinda like using a calculator for math instead of pen and paper.
close! can't say podverse is decentralized...
chatgpt is better at marketing this than me 🙈
ChatGPT knows about Podcasting 2.0 👀
Prompt: what is the difference between <itunes:season> and <podcast:season>
Answer wasn't super helpful though...all I wanted it to tell me is something like "name is optional for <podcast:season> but name is not supported with <itunes:season>"
There are many classes that will have both repository and a get method...how can these lines be abstracted into a super class, so it can be used with other service classes, like ChannelAboutService?
These helpers are using TypeORM.
This is my attempt...but I keep getting stuck on a Typescript error with the "where" key. Error msg in linked gist:
https://gist.github.com/mitchdowney/905f751d70de25cb7409019b7a91e138
"A revolutionary media technology, transforming podcasting!" sounds like another project i know :)
@adam @dave their marketing dept is good. How many years of in house technical experience does Podcasting 2.0 have?
hey @dave, @suorcd and I are looking into ways to shrink our database, and our "episodes" table is by far the largest. I was wondering if you have thoughts on how to reduce the size of this table. We are using Postgres. Our biggest columns are episode description, and 3 columns for URLs.
We already have a pruning process for removing dead / no longer public episodes. I suppose we could limit the length of text saved to the description column, although not sure what a good limit will be.
12 Rods Tour ft. Mellow Cassette is LIVE and LIT 🔥 #V4V
12 Rods Tour Eclipse: A v4v Mirror Ball Stream Featuring Mellow Cassette 12 Rods Ryan Olcott - Vocals, Guitar Lars Oslund - Guitar Adri Mehra - Bass Efren Maldonado - Keyboards Alec Tonjes - Drums Mellow Cassette Blake Johnson - Drums Dan Olsen - Bass John Kargol - Guitar, Vocals Taylor Sound and Video Perry Bowers Nick Foss Parker Grones Thunder Road Media boo-bury Frankie Paint Ericpp Kaylin Wolf Make Heroism Tunestr.io OpenMike Bryan Erickson Executive Producers momma-bury and Spaz Alanna Tuttle Petar, The Goat Butcher Kyrin Downs of the Mere Mortals & Value For Value podcast OpenMike of Tunestr.io Elizabeth Gemelli Associate Executive Producers SirVo ChadF Trevor Kraabel Dovydas Joksas of RSSblue.com Lavish, Could Be Lavaush, But It Could Be Lavish of the Behind The Sch3m3s podcast boo-bury, Mothman of The Minneapocalypse of the Behind The Sch3m3s podcast DuhLaurien of the Homegrown Hits podcast MaryKate Ultra of the Homegrown Hits podcast Mike Nuemann of the It’s A Mood podcast Sircuss Media Associate Producers Carolyn Blaney of the Hog Story Podcast CBrooklyn112 The Good Reverend Dr. Phifer of The Two Hour Folk Hour podcast KR Øystein Berge of the Mutton, Mead & Music podcast Frankiepaint Dame Boolysteed Wiirdo NetNed Piranesi SirSeatSitter of the ABS 'N A 6-Pack podcast Cousin Vito Nam of the Millennial Media Offensive podcast Same Sethi of Truefans.fm SirSpencer of the Bowl After Bowl Podcast Sir TJ The Wrathful of The Doerfels Lyonstyles HeyCitizen of the HeyCitizen Experience MakeHeroism Darren O’Neill of the Planet Rage, No Agenda Rock 'N' Roll Pre-Show, Randumb Thoughts, Unrelenting, and Grumpy Old Bens podcast Anon Anon Anon Anon Podcasts That Produced Via The Value Split Behind The Sch3m3s Before The Sch3m3s Bowl After Bowl Homegrown Hits Mere Mortals S01E194: I Am Become Paint Destroyer Of Canvas – The GOAT DRIVE Winners Oystein Berge - pin FrankiePaint - shirt Mary-Kate Ultra - vinyl Mike Neumann - pin Boo-Bury - shirt SircussMedia - vinyl DuhLaurien - vinyl SircussMedia - pin KR - shirt Mary-Kate Ultra - shirt Lavish - shirt DuhLaurien - shirt Boosters SirVo Boolysteed SirSpencer Cousin Vito El Guapo Phifer Sircuss Media Nam NetNed MakeHeroism SirTJTheWrathful Wiirdo SirSeatSitter ChadF Face2theScr33n Show Art Gif Frankiepaint boo-bury Promotional Art boo-bury Lighting Rental Provided By Mack Swanson and Slamhammer Sound inc Lighting Designer Frankiepaint Master Electrician/Rigger/M.C. boo-bury Banner Fabrication Kaylin Wolf boo-bury Banner Painting Frankiepaint RSS Feeds Build And Management boo-bury EricPP Boostscore Board By EricPP Split Kit Technician EricPP Audio Op Nick Foss John Kargol Cameras and Video Switcher Op Parker Grones Time Lapse Intro By Parker Grones Boo-bury 12 Rods Tour Eclipse: A v4v Mirror Ball Stream Featuring Mellow Cassette Shirts Makeheroism boo-bury Kaylin Wolf Preshow Playlist By Frankiepaint NOISEDIVER - BLOWORLD Emily Ronna - Breathe PRISMIND - Dagger Herbivore- Anne-Cecilia Sista Fista - Play Skatenigs - Hell And Back Again The Trusted - Terrible Fight The Cooper Friendly Feel Good Group - On My Way Silverseed - All Things are Born of Woman Abi Muir - Stockholm Rainmaker - No Place Like Home Herbivore - Pixelated Smile Prosperous Soul - Keep Searching Survival Guide - Blood Perfume The Doerfels - They Don't Know Choreboy - We’re in It for the Money Credits By Litebrite End Credits Track False Finish - Rings of Saturn A Special Thanks To LiteBrite of the Rough Around The Hedges podcast Kaylin Wolf of the Rough Around The Hedges podcast Cottongin SirVo Voidzero Sirbemrose of the Grumpy Old Bens and Angry Tech News Podcast Lavish BTS shop Slamhammer Sound inc Marty Lesmeister Jake Wick Mack Swanson Monkey Wrench Productions Apex Transfers Stephen Bell of Musicsideproject.com and Sovereignfeeds.com Dovydas of Rssblue.com Oscar Merry of Fountain.fm Sam Sethi of TrueFans.fm OpenMike of Tunster.io Podcastindex.org And producers like you! Continue? Yes or Yes
