Skip to content
164: Choosing a Database For Your Project With Kris Zyp episode artwork

Sep 11, 2023 1 hr 31 min

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.

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

164: Choosing a Database For Your Project With Kris Zyp

0:00 1:31:21

Chapters

  1. 0:00 Kris Zyp's background and early career
  2. 7:09 Bridging client-side and data storage
  3. 16:40 The path from open-source project creation to professional roles
  4. 21:30 The Challenges of Maintaining Open Source Projects
  5. 27:01 When to use a database vs. other storage
  6. 28:59 Query complexity and NoSQL vs. SQL
  7. 31:22 The challenges of normalization
  8. 35:22 The Challenges of Data Modeling
  9. 42:51 Scalability Challenges
  10. 47:47 Relational vs. NoSQL Scaling
  11. 51:43 Consistency vs. Speed
  12. 55:00 Defining SQL vs. NoSQL
  13. 57:31 When to Use SQL for Complex Queries
  14. 59:48 ORMs and Developer Experience
  15. 1:01:54 The N+1 Query Problem
  16. 1:05:29 Embedded Databases as a Solution
  17. 1:07:29 Database Environment and Latency
  18. 1:10:01 The Impact of Latency on User Experience
  19. 1:12:55 Local Data Storage for Mobile Devices
  20. 1:15:08 Introduction to Edge Computing
  21. 1:17:33 Why JavaScript is Preferred for Edge Computing
  22. 1:25:07 The Importance of Latency in User Experience

No transcript yet.

Requests help us decide what to transcribe next.

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.