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.