Looking back at 6 months of Open Podcast in the final episode for this season.

Time flies. It’s been six months since we started our Open Podcast project. What have we achieved? What went well? What didn’t?

We take an honest look at the project and also look into the future. Thanks to everyone who has been part of this journey!

Links

Open Podcast (https://openpodcast.dev)

How did you like this episode?

👍(upvote)  👎 (downvote)

What if we told you that you could get realtime feedback from your podcast listeners today? This and more is possible thanks to Podcasting 2.0

Podcast development is stuck in the past. There’s a severe lack of features like being able to monetize content or get feedback from listeners. There hasn’t been any update to RSS since 2006, even though we’ve seen astounding technological advancement like the advent of broadband internet, the adoption of smartphones, or social networks like Facebook).

But there is hope: Podcasting 2.0. It’s a new standard created by the original authors of RSS and supported by many Podcast hosters, players, and indexers. Over 400.000 podcasts use the new format already, to provide better functionality for listeners and creators.

We will talk about the new standard, the market, the players, and how you can start using that today. And about the relationship between the Podcasting 2.0 ecosystem and Open Podcast.

Links

• Podcasting 2.0 talk at FOSDEM: https://fosdem.org/2023/schedule/event/podcasting20/ 
• Castopod https://castopod.org/ 
• What si Podcasting 2.0? https://origin.fm/blog/podcasting-2point0/ 

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

How did you like this episode?

👍(upvote)  👎 (downvote)

How did you like this episode?

👍(upvote)  👎 (downvote)

We describe our stack for writing documentation and which tools we can recommend to improve yours.

One of a user’s first points of contact with your project will be through your project documentation. Even open source projects should try to make a good first impression here, but how exactly do you write great docs?

Nowadays there are a gazillion different tools to write developer documentation. To save you some time, we’ll try to give you an overview and explain what worked for us and what didn’t.

Links

• Readme.com (https://readme.com/) 
• Excalidraw (https://excalidraw.com/)
• Mermaid (https://mermaid.js.org )
• Docsify (https://docsify.js.org/#/)
• Our docs (https://openpodcast.dev/#/?id=main)

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

How did you like this episode?

👍(upvote)  👎 (downvote)

How did you like this episode?

👍(upvote)  👎 (downvote)

Have you ever dreamt of working on your own Open Source projects full-time? We show ways to fund your work.

Funding is a big topic for many Open Source projects. People spend many hours per week on their passion project without getting paid. To support their project long-term, many projects will have to find ways to fund that work.

We talk about different Open Source funds like Prototype, Mozilla Ventures, or Media Tech Lab which help OSS projects become sustainable. We’ll also talk about the tradeoffs of each program, the amount of funding you can expect, and how you can apply.

Links

• Github Accelerator: https://accelerator.github.com/
• Mozilla Ventures Announcement: https://blog.mozilla.org/en/mozilla/mozilla-ventures-investing-in-responsible-tech/ 
• Mozilla Ventures Homepage: https://mozilla.vc/ 
• Matthias’ blog post about funding OSS projects: https://endler.dev/2021/oss-money/ 

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

How did you like this episode?

👍(upvote)  👎 (downvote)

How did you like this episode?

👍 👎

Learn how to set up Open Podcast yourself; on-premise or in the cloud.

If you’re hosting a podcast you know how important it is to learn about your audience to grow the channel. And chances are you listen to this podcast to learn more about just how to do that.

The start of the year is a great time to start something new, so today we give you a complete walkthrough on how to set up our Open Podcast analytics platform yourself. No more excuses. ;)

Links

• Installation instructions: https://openpodcast.dev/#/install 

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

How did you like this episode?

👍 👎

How did you like this episode?

nice 👍 <> 👎 meh

Podcasting can be a solitary pursuit, and it can be challenging for podcasters to get feedback from their listeners. We talk about ways to change that.

Some podcasters like the German Doppelgänger Podcast have turned to social media or community platforms like Discord to interact with their audience and gather feedback. They have even suggested using chapter markers or time stamps in their podcasts to allow listeners to leave comments or feedback on specific sections of the episode, similar to the way that Soundcloud allows users to annotate music with comments. Another idea that has been proposed is the creation of a social graph of podcast guests, where listeners could follow and comment on the "public life" of guests who have appeared on multiple podcasts and TV interviews.

We comment on all of these ideas and share our own perspective.

This is the sequel to episode 16, where we talked about our simple upvote/downvote mechanism. In this episode we go deeper and look at alternative feedback mechanisms and community building that goes beyond feedback.

How did you like this episode?

nice 👍 <> 👎 meh

Links

• Engineering Kiosk #-1 Wrap-Up: https://engineeringkiosk.dev/podcast/episode/-1-wrap-up-2022-und-1-geburtstag-learnings-statistiken-und-was-2023-geplant-ist/ 
• Doppelgänger Podcast #212: https://www.doppelgaenger.io/212-%f0%9f%8f%a6-esops-%f0%9f%a4%bf-apple-headset-%f0%9f%97%93%ef%b8%8f-shopify-meetings-%f0%9f%8e%a7-podcast-crm-%f0%9f%aa%99-zinsen-bei-tr-%f0%9f%8c%a7%ef%b8%8f-layoffs-%f0%9f%9b%8d%ef%b8%8f-about/ 

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://mastodon.social/@woolf)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

Ignore from here on, it is just a test:

• 👍 up  👎 down
• up  down
• 👍 (icon only)

How did you like this episode?

👍 👎

If you are interested in our self-hosted solution, you can now run the full stack of Open Podcast on your own servers.

We have a Docker Compose file that you can use to run the whole stack on your own servers. You can find instructions on how to do that in our documentation at https://openpodcast.dev/#/install.

We made sure to make the installation as easy as possible, to keep the installation instructions simple to follow, and to make maintaining the stack as easy as possible.

Please provide feedback on the installation process, and let us know if you have any questions.

How did you like this episode?

👍 👎

In case you can't click the icons:

Up: https://api.openpodcast.dev/feedback/0/upvote

Down: https://api.openpodcast.dev/feedback/0/downvote

Feedback is extremely useful for podcast creators. Let’s look at some ways users can send data back to the hosts and how they are implemented.

How did you like this episode?

👍 👎

Back in 2017, the US National Public Radio worked on an open standard called RAD (which stands for Remote Audio Data), which allows users to send anonymized feedback to Podcast creators via a public endpoint.

They provide an open source Android- and iOS SDK and a specification for the standard to make it easy to integrate their standard into any podcast player or platform.

We explain how the format works and compare it to our own solution, which integrates into a Podcast’s RSS feed as well as a simple “thumbs-up/thumbs-down” voting system that can be integrated into the show notes of any podcast episode.

How did you like this episode?

👍 👎

In case you can't click the icons:

Up: https://api.openpodcast.dev/feedback/0/upvote

Down: https://api.openpodcast.dev/feedback/0/downvote

Pitching products is an art.

…especially when trying to pitch “open core” products, which are rooted in open source because being open source maintainers, we focus too much on the OSS part. The truth is most potential business partners don’t care - at least initially.

Last week we had a lot of opportunity to train how to pitch because we attended an intro-day for all products in batch #1 of Media Tech Lab Bavaria, which we are part of.

In this episode we’ll talk about our (failed) attempts to pitch Open Podcast to strangers and we learned from that for the future.

Links

• Media Tech Lab: https://www.media-lab.de/media-tech-lab 

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

Finding customers for open source tools is important for the success of the project.

How do developers find customers for their tools? Do they just write code and wait for customers to jump on their product? Or do they talk to potential customers before they write their first line of code?

If you build an app that is not just a hobby project, customer acquisition is one of the most important things to do to ensure long term success. But customer acquisition is not easy; it takes time and effort.

In this episode, we talk about potential marketing channels for open source tools, how to find interview partners, and how to get feedback from potential customers. We will share our experience of building an application for podcast hosts and how we approached the market. We will share our learnings and insights and how we built a network of potential customers and partners.

Links

• Open Podcast: https://openpodcast.dev 

Hosts

• Matthias Endler (https://mastodon.social/@mre) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

We talk about the different business models for open source projects and how we could apply them to our podcast analytics project.

There are many trade-offs to consider when choosing a business model for an open source project. We discuss the pros and cons of the different models like open core, consulting, and contracting. Along the way we look at some examples of successful open source projects and how they monetize their work.

We also explain the open core model, which describes business models where the core of the project is open source, but some features are only available in a paid version. We discuss the advantages and disadvantages of this model and how we could apply it to our podcast analytics project.

Links

• Elasticsearch license change: https://www.elastic.co/pricing/faq/licensing 
• Plausible: “How we made it to 1 million MRR: https://plausible.io/blog/open-source-saas 
• Cal.com open business data: https://cal.com/open

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

We have to move away from PlanetScale, our database layer because of a lack of functionality. Here's why.

The main database is at the core of every data-driven product. It's the place where all the data is stored and where all the data is processed.

For a long time, we've been using PlanetScale as our database layer and we have been very happy with it.

Unfortunately, we have to move away from PlanetScale because of a lack of functionality.

In this episode, we'll talk about why we have to move away from PlanetScale and what we're going to do instead.

Links

• Planetscale: https://planetscale.com/
• PostHog: https://posthog.com/ 
• Vitess: https://vitess.io/ 

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

What Podcasters can learn from Spotify’s data

Spotify’s data is a goldmine for podcasters. It can help you understand your audience, improve your content, and grow your audience. Here are some of the most important things you can learn from Spotify’s data.

In the last episode, we talked about the Spotify API and how we access and store the data.

This time we pick up where we left off and talk about what you can do with the data and why it's important to own your data.

We expose the data in a SQL database and use metabase to visualize the data. (See also episode #8 for more on metabase, redash, grafana, and superset.)

With the data in a SQL database, we can do more powerful things like calculating averages and comparing episodes through SQL custom queries.

It's even more powerful when you store historical data. You can then correlate the data with other data sources (e.g. from different podcasts or hosts). It’s hard to retrieve historical data after the fact.

Users want to know if they have improved over time and compare between episodes. All of this is possible with historical data and graphs that are easy to understand.

Links

• Our Open Podcast documentation: https://openpodcast.dev
• Open Podcast on Github: github.com/openpodcast

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

In this episode, we talked about the Spotify for Podcasters API and how to use it to extract data from Spotify. We also talked about the different data types that can be extracted and how to store the data in a MySQL database.

The API consists of internal endpoints for fetching metadata, episodes, and detailed streams, listeners, followers, and aggregate data. To use the API we need to fetch the authentication token for a user. Notably this is not the user's Spotify account.

The data can be stored in a MySQL database. We can then use the data to answer complex questions such as "What topics perform the best?" and "What are the preferences of specific age groups?" This is much more flexible than using official Spotify for Podcasters dashboard. Furthermore the data will be available for further analysis for an arbitrary time period and can be used to create a custom dashboard.

Links

• Explanation on how to retrieve the Spotify cookie for fetching data: https://den.dev/blog/unlocking-spotify-podcast-data/ 
• An OSS library for fetching Spotify Podcast data and more: https://github.com/wdr-data/wdr-okr/ 
• Our code: https://github.com/openpodcast 

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License.

We talk about our visit at Medientage München and the future of the audio industry.

Last week we visited the Medientage München, one of the biggest media events in Germany. (Thanks Media Tech Lab for sponsoring our visit!)

Attending the event is a great opportunity to get in touch with the industry and to get a lot of insights into the future of the audio industry.

What we found was that the audio industry is going through a massive transformation and that the future of audio is no longer linear.

For us this group of people is very interesting, because we want to position Open Podcast as the best tool for gathering analytics for podcasters and podcast studios to help them make this transition.

Links

• Medientage: conference about media in Munich https://medientage.de/ 
• German summary of the conference Medientage https://blog.medientage.de/das-waren-besondere-momente-der-mtm22
• Our sponsor Media Tech Lab Bayern https://www.media-lab.de/de/media-tech-lab 

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

The final part of our tech stack description. This time we discuss the visualization part based on Metabase.

For any analytics platform, the decision on how data gets visualized is a crucial one. It is what users will interact with first and has an important impact on how the quality of a data product is perceived. We discuss the pros and cons of the most popular visualization tools and how they compare to Metabase, which is the tool we settled on for Open Podcast.

Metabase is a popular open source data visualization tool that integrates well with SQL databases. For our hosted variant of Open Podcast, we use Metabase to visualize the data stored on Planetscale.

Before Metabase we used Posthog, which is also great, but doesn't now allow writing custom SQL queries. We also tried Grafana, which is a great tool for time series data, but it also doesn't integrate well with SQL databases and is primarily meant for monitoring solutions.

Other competitors we discuss are Superset, Redash, and Grafana. We also briefly touch on the topic of self-hosted vs. cloud-based solutions.

Links

• How to create dashboards with metabase https://www.metabase.com/docs/latest/dashboards/introduction 
• https://superset.apache.org/
• https://posthog.com/
• https://grafana.com/ 
• https://redash.io/ 

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License.

Another technical episode; this time about our realtime analytics forwarder/proxy written in Rust.

Podcast creators want realtime data about the performance of each episode. The big platforms usually only provide aggregated data with some delay whereas the hosting platforms like Podbeans or Redcircle store the data in proprietary formats that oftentimes can’t be exported or gets filtered and put behind paywalls through pro-accounts.

In contrast, our proxy works with any major platform and stores the data in a machine-readable format that can easily be exported. It is written in Rust and runs as an edge-worker on Cloudflare Workers, but it can also be run on a standalone server.

We’ll talk about the architecture of the component and the tradeoffs we made while building it. 

Links

• https://www.rust-lang.org 
• https://codilime.com/blog/why-is-rust-programming-language-so-popular/
• https://blog.cloudflare.com/workerd-open-source-workers-runtime/
• https://workers.cloudflare.com/ 

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

In this episode we talk about the tech stack of Open Podcast. We discuss the reasons why we chose the technologies we use and why we chose to use them. We also talk about the advantages and disadvantages of the technologies we use.

We require all tools to be open source and self-hostable. We also require that the tools are easy to set up and easy to use. We also require that the tools are scalable and have solid documentation.

Today we start with the database, which is based on SQL. We use MySQL because many devs have a lot of experience with MySQL.

We evaluated a few options and we'll explain why we chose Planetscale over other options.

Links

• Planetscale MySQL Service https://planetscale.com 
• Event Storage and Analytics https://posthog.com 
• SQLite https://www.sqlite.org/index.html 
• Cloudflare D1 SQLite based DB https://blog.cloudflare.com/introducing-d1/

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

Why we are still in “Podcast Analytics Stone Age”?

Looking at the current state of web monitoring, one might be surprised when setting up a Podcast: many of the standard metrics are hard to get for podcasts and the ones that are are not standardized.

There is a zoo of different measurements for podcast analytics out there and everyone is trying to push their own agenda. We think these issues can be fixed with standardization.

In this episode we compare the state of podcast analytics with the early days of the web. Back then you had simple image counters on your websites. Pretty limited. The podcast industry is in its infancy as well and the lack of client-side tracking makes it hard for hosts to connect with their audience.

We give an overview of the industry efforts to fix these issues and how we’re planning to help as well.

Links

• Wolfgang's first online project in the 90s https://web.archive.org/web/19991127092201/http://www.all-4-free.net/counter.htm
• Interesting resources describing tech behind podcasts https://openpodcast.dev/#/research
• List of podcast user agents https://github.com/opawg/podcast-rss-useragents
• IAB guidlines how to measure podcast downloads https://iabtechlab.com/standards/podcast-measurement-guidelines/
• Tool to process download logs of podcasts https://github.com/open-downloads/odl
• trivago tech blog https://tech.trivago.com

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License. 

In this episode we talk about the Open API for Podcasts project and how you can get involved.

Last week we talked about vendor lock-in and how it is a problem for podcasters.

We thought it would be a good idea to elaborate on this topic and talk about our proposed solution, an Open API for Podcasts.

We talk about the motivation behind the project, what the project is trying to achieve and what the next steps are. We also talk about the RFC process and how you can get involved.

Links

• https://github.com/wdr-data/wdr-okr/

Hosts

• Matthias Endler (https://twitter.com/matthiasendler) 
• Wolfgang Gassler (https://twitter.com/schafele)

Feedback

• Email: echo@openpodcast.dev 
• Twitter: https://twitter.com/OpenPodcastDev 

Credits

The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License.