164: Choosing a Database For Your Project With Kris Zyp
from Programming Throwdown Hosted by Patrick Wheeler and Jason Gauci with guest Kris Zyp
Things to consider when choosing a database Speed & Latency Consistency, ACID Compliance Scalability Language support & Developer Experience Relational vs. NoSQL) Data types Security Database environment Client vs Server access Info on Kris & Harper: Website: harperdb.io Twitter: @harperdbio, @kriszyp Github: @HarperDB, @kriszyp.
Embed this episode
Chapters
- 0:00 Kris Zyp's background and early career
- 7:09 Bridging client-side and data storage
- 16:40 The path from open-source project creation to professional roles
- 21:30 The Challenges of Maintaining Open Source Projects
- 27:01 When to use a database vs. other storage
- 28:59 Query complexity and NoSQL vs. SQL
- 31:22 The challenges of normalization
- 35:22 The Challenges of Data Modeling
- 42:51 Scalability Challenges
- 47:47 Relational vs. NoSQL Scaling
- 51:43 Consistency vs. Speed
- 55:00 Defining SQL vs. NoSQL
- 57:31 When to Use SQL for Complex Queries
- 59:48 ORMs and Developer Experience
- 1:01:54 The N+1 Query Problem
- 1:05:29 Embedded Databases as a Solution
- 1:07:29 Database Environment and Latency
- 1:10:01 The Impact of Latency on User Experience
- 1:12:55 Local Data Storage for Mobile Devices
- 1:15:08 Introduction to Edge Computing
- 1:17:33 Why JavaScript is Preferred for Edge Computing
- 1:25:07 The Importance of Latency in User Experience
No transcript yet.
Similar podcasts
The Self-Worth Project
Jenn Stevens
Welcome to The Self-Worth Project! Hosted by Jenn Stevens, coach, hypnotist, and creator of The Aligned Life This podcast is designed to help you remember who you really are: underneath the layers of pain, shame, and programming that are keeping you small. Let's ditch the unhealthy patterns so we can create the life we really want, without apology.
Disability Law Show
CKNW Programming
Samfiru Tumarkin LLP is a Toronto-based law firm that specializes in labour and employment law, as well as personal injury and insurance claims.
Frequently asked questions
How long is this episode of Programming Throwdown?
This episode is 1 hour and 31 minutes long.
When was this Programming Throwdown episode published?
This episode was published on September 11, 2023.
Can I download this Programming Throwdown episode?
Yes. Use the download control on the episode player to save the publisher-provided media file.