
#06 - Tech stack of Open Podcast: Which database is best?
Failed to add items
Sorry, we are unable to add the item because your shopping cart is already at capacity.
Add to basket failed.
Please try again later
Add to Wish List failed.
Please try again later
Remove from Wish List failed.
Please try again later
Follow podcast failed
Unfollow podcast failed
-
Narrated by:
-
By:
About this listen
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/
- Matthias Endler (https://twitter.com/matthiasendler)
- Wolfgang Gassler (https://twitter.com/schafele)
- Email: echo@openpodcast.dev
- Twitter: https://twitter.com/OpenPodcastDev
The theme music is U.S. Army Blues - Kelly’s Number and is licensed under Public Domain Mark 1.0 License.
What listeners say about #06 - Tech stack of Open Podcast: Which database is best?
Average Customer RatingsReviews - Please select the tabs below to change the source of reviews.
In the spirit of reconciliation, Audible acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.