Replit Creates MVP: YouTube Summary Service #4
Additional improvements I have recorded the improvements made since Part 3. Improved database structure The first problem I felt after deployment was the lack of scalability. At first, I directly entered the category values into the channel as enums, but it was very inconvenient every time I added or changed a category. Separating the category table makes management much easier. Pitfalls of Image Collection Logic When we kept asking the agent to improve the video collection part, errors kept occurring instead. In particular, when trying to make imperfect improvements like a human, there were many cases where recent videos from certain channels were omitted. Eventually, I went through a process of manually reviewing and correcting all channels to ensure they were imported normally. As I was digging into something that wasn't working, I realized that there were some useless parts of the code that were similar to people. Cost Optimization: Switch to Gemini The task of extracting scripts from audio files has been changed from the existing service to Gemini. I thought that only OpenAI provided it as an API, but Gemini also provides it by default. After a quick price comparison request to Perplexity, I switched to Gemini. The price was a bit cheaper, and the switching process was faster than I expected. It also seemed to be a bit faster (feeling?), so it was a satisfactory decision. First public appearance and reaction Achievements at geeknews Thankfully, when I shared it with geeknews, I got a really positive response. We got 1,300 hits and 60 signups in just one day. The next day, I visited over 400 times and enjoyed the 2-day DAU goal of 100. I received a request in the comments to add RSS XML functionality, so I immediately created an rss.xml file and set it to automatically update whenever a new feed is added. https://shortv.replit.app/rss.xml Thank you to all the geeknews people who sent us so much support :) The analytics provided by Replit are good for viewing, but they don't provide enough data to analyze. I think we'll have to add GA in the future.
- Pokute