logo
episode-header-image
Sep 2023
1h 31m

164: Choosing a Database For Your Projec...

Patrick Wheeler and Jason Gauci
About this episode

Things to consider when choosing a database

  • Speed & Latency
  • Consistency, ACID Compliance
  • Scalability
  • Language support & Developer Experience
  • Relational vs. Non-relational (SQL vs. NoSQL)
  • Data types
  • Security
  • Database environment
    • Client vs Server access


Info on Kris & Harper:

  • Website: harperdb.io
  • Twitter: @harperdbio, @kriszyp
  • Github: @HarperDB, @kriszyp


★ Support this podcast on Patreon ★
Up next
Feb 3
186: Becoming a Manager
186: Becoming a ManagerIntro topic: plastic welding kitsNews/Links:Parse.bot, turn any website into an APIhttps://www.parse.bot/Gemini 3https://blog.google/products/gemini/gemini-3/Depth Anything 3https://github.com/ByteDance-Seed/Depth-Anything-3Wan 2.2 (run on runpod)https://ww ... Show More
1h 27m
Nov 2025
185: Workflow Orchestrators
Intro topic: Asymmetric ReturnsNews/Links:NanoChat by Andrej Karpathyhttps://github.com/karpathy/nanochatPydantic AIhttps://www.marktechpost.com/2025/03/25/pydanticai-advancing-generative-ai-agent-development-through-intelligent-framework-design/1000th Starlink this yearhttps://s ... Show More
1h 32m
Sep 2025
184: Asynchronous Programming
184: Asynchronous ProgrammingIntro topic: AI ScamsNews/Links:Coding Adventure: Ray-Tracing Glass and Caustics (Sebastian Lague)https://www.youtube.com/watch?v=wA1KVZ1eOuABoson AI announces Higgs Audio V2https://www.boson.ai/technologies/voice The Misconception that Almost Stopped ... Show More
1h 30m
Recommended Episodes
Dec 2023
Episode 158 - Reverse Engineering Table Relations based on SQL Plans
tail spinning
41m 41s
Nov 2023
86: SQL Simplified: For Data Beginners
<p>SQL is the most important data skill you can learn on your journey. And it doesn’t need to be complicated. In this episode, dive into a short SQL introduction, basic SQL commands and know how SQL can help you land your data job.</p> <p>Tune in now!</p> <p><br></p> <p><a href=" ... Show More
26m 9s
Mar 2020
Episode 114 - Lots of catching up to do
Guy Glantser is co-hosting with Eitan Blumin for the first time, and we have a lot of topics to cover and catching up to do. PASS and SQLBits Conferences Storage Best Practices for SQL on IaaS in Azure SQL VM RP (Resource Provider) Guy's hopes for SQL Server setup options SQL Ser ... Show More
38 m
Jan 2024
Episode 159 - Select * Wastes Money
Guy and Eitan discuss various practices in SQL Server that hurt performance and possibly waste money, negative VarDecimal numbers, renumbering Identity columns, and the new Azure Database Fleet Manager. Relevant links: SQL Server IN Clause With Multiple Literal Values Performance ... Show More
37m 55s
Sep 2021
S17:E9 - What are some database architectures and their use cases (Kyle Bernhardy)
In this episode, we talk about database architectures and some of their use cases, with Kyle Bernhardy, CTO of HarperDB. Kyle talks about what a database is, different types of databases, and when you might want to use one type of database over another. Show Links DevDiscuss (spo ... Show More
48m 31s
May 2022
#366: Optimizing PostgreSQL DB Queries with pgMustard
See the full show notes for this episode on the website at talkpython.fm/366 
1h 14m
Mar 2020
Easier Stream Processing On Kafka With ksqlDB
<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>Building applications on top of unbounded event streams is a complex endeavor, requiring careful integration of multiple disparate systems that were engineered in isolation. The ksqlDB project was created to address this ... Show More
43m 36s
Jul 2021
Should you go with an Optimistic or Pessimistic Concurrency Control Database?
<p>MongoDB, Postgres, Microsoft SQL Server, or MySQL, or any other database manages concurrency control differently. There are two methods, pessimistic and optimistic, both have their pros and cons. Let explore how different databases implement this and what is the effect on perf ... Show More
21m 46s
Sep 2023
Exploring SQL and ETL
<p>The evolution of SQL and the ease of access to ever larger sizes of computational power has made SQL and ETL a useful pairing for practitioners in the data space. But how do they work together exactly? And what challenges can it pose?</p> <p>Bharani Subramaniam and Madhu Podil ... Show More
31m 57s
Listen to millions of songs and podcasts on Anghami