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
Jun 30
182: AI Assisted Coding
Intro topic: Getting an entry-level jobNews/Links:Mario Kart 64 Fully Decompiledhttps://gbatemp.net/threads/mario-kart-64-decompilation-project-reaches-100-completion.671104/Q-Learning is not yet scalablehttps://seohong.me/blog/q-learning-is-not-yet-scalable/Grover’s Algorithmhtt ... Show More
1h 37m
May 12
181: Memory Management
Intro topic: Video Game PricesNews/Links:Step one: Jump in the Lava - Abyssofthttps://youtu.be/WdadpHLAfdA?si=oXYnhB0EdkR_RaPEScalable world models for continuous controlhttps://www.tdmpc2.com/Clever code is probably the worst code you could write - Engineer’s Codexhttps://read.e ... Show More
1h 46m
Mar 2025
180: Reinforcement Learning
Intro topic: GrillsNews/Links:You can’t call yourself a senior until you’ve worked on a legacy projecthttps://www.infobip.com/developers/blog/seniors-working-on-a-legacy-projectRecraft might be the most powerful AI image platform I’ve ever used — here’s whyhttps://www.tomsguide.c ... Show More
1h 52m
Recommended Episodes
Dec 2023
Episode 158 - Reverse Engineering Table Relations based on SQL Plans
Guy and Eitan talk about some great things about SQL Server, and mostly Guy’s experience in digging into execution plans and generating synthetic IO workloads. Relevant links: What’s new in SQL Server and Azure SQL 2023 Year in Review Multi-Tenancy in the Real World | Eitan Blumi ... Show More
41m 41s
Nov 2023
86: SQL Simplified: For Data Beginners
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. Tune in now! 🗄️ Join FREE SQL hands-on workshop th ... Show More
25m 25s
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
Summary 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 state of affairs by building a unified layer on top ... Show More
43m 36s
Jul 2021
Should you go with an Optimistic or Pessimistic Concurrency Control Database?
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 perform ... Show More
21m 46s
Sep 2023
Exploring SQL and ETL
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? Bharani Subramaniam and Madhu Podila discuss ... Show More
31m 57s
Listen to millions of songs and podcasts on Anghami