Лучшие подкасты про Database (2024)

1
Making Invisible Connections Visible with Tim Eastridge 37:54

15h ago37:54

37:54

Speaker Resources: Eastridge Analytics: https://www.eastridge-analytics.com/ Graph Data Science with Python and Neo4j book: https://a.co/d/hkfkxPr LinkedIn profile: https://www.linkedin.com/in/timeastridge/ NODES 2024 (look for more info on Tim's talk soon!): https://dev.neo4j.com/nodes24 Neo4j GraphAcademy: https://graphacademy.neo4j.com/ Graph Al…

1
Mastering Query Optimization: Boosting Database Performance 15:01

6d ago15:01

15:01

Dive into the world of query optimization and unlock the secrets to boosting database performance in this informative episode of Database Internals Crashcasts. In this episode, we explore: The fascinating evolution of query optimization from its 1970s origins to modern techniques How query plans are generated and the crucial role of join order opti…

1
SCP-137 - The Real Toy 12:04

6d ago12:04

12:04

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY DrEverettMann AND Arlecchino:www.scp-wiki.net/scp-137www.scp-wiki.net/experiment-log-137License: creativecommons.org/licenses/by-sa/3.0/----The voices of the Database and Dr. [REDACTED] were provided by Joshua Alan Lindsay.The voice of SCP-137 was provided by Ken…

1
Mastering Data Integrity and Consistency in Distributed Database Systems 5:38

13d ago5:38

5:38

Dive into the complexities of maintaining data integrity across distributed database systems in this simulated interview with a senior backend engineer. In this episode, we explore: ACID properties and the unique challenges of distributed systems The two-phase commit protocol: its strengths and limitations Advanced techniques: consensus algorithms …

1
Ruby on Rails + SQLite with Stephen Margheim 1:43:09

29d ago1:43:09

1:43:09

Want to learn more about SQLite? Check out the full course: https://highperformancesqlite.com Get production ready SQLite with Turso: https://tur.so/af. In this interview, I talk to Stephen Margheim about his work with SQLite and Ruby on Rails. Links: Database school on YouTube: https://www.youtube.com/playlist?list=PLI72dgeNJtzqElnNB6sQoAn2R-F3Vqm…

1
Column-Oriented Databases: Revolutionizing Data Storage and Analysis 20:13

6d ago20:13

20:13

Dive into the world of column-oriented databases and discover how they're revolutionizing data storage and analysis for big data analytics. In this episode, we explore: The unique structure and historical evolution of column-oriented databases How these databases optimize analytical queries through compression and late materialization Real-world im…

1
Demystifying Query Processing and Execution: How Databases Handle Your Requests 11:00

6d ago11:00

11:00

Uncover the hidden complexity behind your database queries in this enlightening episode on query processing and execution. In this episode, we explore: The evolution of query processing: From simple table scans to sophisticated distributed systems The magic behind query optimization: How databases transform your SQL into efficient execution plans R…

1
Database Replication Explained: Benefits, Methods, and Tradeoffs 7:14

13d ago7:14

7:14

Dive into the world of database replication with expert insights from Victor, a seasoned database professional. In this episode, we explore: The fundamentals of database replication and its game-changing benefits A deep dive into replication methods and their crucial tradeoffs Real-world scenarios and implementation challenges you need to know Tune…

1
Database Design: Balancing Performance and Reliability for High Write Loads 6:15

13d ago6:15

6:15

Dive into the world of high-performance database design with our simulated interview featuring senior backend engineer Victor. In this episode, we explore: Sharding and partitioning strategies for distributing high write loads Replication and data integrity techniques, including write-ahead logging Caching and load balancing optimizations to enhanc…

1
SQL Performance: Avoiding Common Anti-Pattern Pitfalls 6:39

13d ago6:39

6:39

Dive into the world of SQL performance optimization with expert insights on common anti-patterns and how to avoid them. In this episode, we explore: The pitfalls of using SELECT * and how to write more efficient queries Strategies for optimizing JOIN operations and subqueries for better performance The N+1 query problem and techniques to overcome i…

1
Optimistic vs. Pessimistic Locking: A Deep Dive into Database Concurrency Strategies 6:16

13d ago6:16

6:16

Dive into the world of database concurrency with our in-depth exploration of optimistic and pessimistic locking strategies. In this episode, we explore: The fundamental differences between optimistic and pessimistic locking approaches Real-world scenarios for applying each strategy in database design Performance implications and trade-offs of both …

1
Database Indexing Strategies: Optimizing Performance and Understanding Tradeoffs 5:40

13d ago5:40

5:40

Dive into the world of database indexing strategies with expert insights on optimizing performance and navigating crucial tradeoffs. In this episode, we explore: Types of database indexes and their unique strengths in different scenarios Critical performance tradeoffs between query speed, storage space, and write operations How to tailor your index…

1
Designing Robust Multi-Warehouse Inventory Systems: Ensuring Data Consistency and Avoiding Race Conditions 5:06

13d ago5:06

5:06

Dive into the world of robust multi-warehouse inventory systems with expert insights on database design and application layer considerations. In this episode, we explore: Crafting an efficient database structure for tracking inventory across multiple warehouses Strategies for maintaining data consistency using transactions and proper locking mechan…

1
Expert Tips for Troubleshooting Database Performance Issues in a Production Environment 5:15

13d ago5:15

5:15

Dive into a simulated interview with an experienced database engineer as we uncover expert strategies for tackling real-world database performance challenges. In this episode, we explore: Effective use of monitoring tools to quickly identify and diagnose database issues Techniques for identifying and resolving index bloat, a common cause of perform…

1
Mastering Database Performance: Optimizing Large Tables for Read and Write Workloads 7:33

13d ago7:33

7:33

Dive into the world of database performance optimization for large-scale systems with expert insights from seasoned database professional Victor. In this episode, we explore: Fundamental optimization techniques for massive tables, including indexing and partitioning Strategies for enhancing read-heavy workloads through caching and replication Tacti…

1
Mastering Database Sharding: Implementation Strategies and Overcoming Challenges 6:15

17d ago6:15

6:15

Dive into the world of database sharding with expert insights from experienced backend engineer Victor in this episode of "Relational Database Interview Crashcasts." In this episode, we explore: The benefits of database sharding for handling large-scale data and high traffic loads Key challenges in implementing sharded systems, including data distr…

1
Database Sharding: Scaling Databases and When to Use It 5:04

13d ago5:04

5:04

Dive into the world of database sharding with expert insights from experienced backend engineer Victor. In this episode, we explore: The fundamentals of database sharding and its role in improving performance and scalability Key challenges and best practices for implementing sharding in large-scale systems Real-world examples and expert tips for di…

1
Stored Procedures Explained: Boosting Query Performance, Advantages, and Potential Drawbacks 5:12

13d ago5:12

5:12

Dive into the world of stored procedures and discover how they can revolutionize your database performance and security. In this episode, we explore: What are stored procedures and how do they optimize query performance? The hidden advantages of stored procedures beyond speed Potential drawbacks and when to use stored procedures in your projects Tu…

1
Understanding and Preventing Database Deadlocks: Essential Strategies for DBAs 6:29

13d ago6:29

6:29

Dive into the complex world of database deadlocks with expert insights from seasoned backend engineer Victor. In this episode, we explore: The anatomy of a deadlock: Understanding the Coffman conditions and real-world scenarios Practical strategies for deadlock prevention, including timeouts and resource ordering Essential best practices for databa…

1
Database Transactions Explained: Isolation Levels and Their Tradeoffs 6:44

13d ago6:44

6:44

Dive into the world of database transactions and isolation levels with expert insights from seasoned database professional Victor. In this episode, we explore: The fundamentals of database transactions and ACID properties Four standard isolation levels and their implications Critical trade-offs between data consistency and performance Real-world ap…

1
Demystifying SQL Execution Plans: Your Key to Query Optimization 6:24

13d ago6:24

6:24

Unlock the secrets of SQL query optimization with our deep dive into execution plans, featuring expert insights from seasoned database professional Victor. In this episode, we explore: The fundamentals of SQL execution plans and their crucial role in query performance Techniques for viewing and interpreting execution plans across different database…

1
Demystifying Clustered vs. Non-Clustered Indexes: When to Use Each 6:22

14d ago6:22

6:22

Dive into the world of database optimization as we explore the crucial differences between clustered and non-clustered indexes. In this episode, we explore: The library analogy: Understanding how clustered and non-clustered indexes organize data Performance implications: Balancing speed and storage in index selection Strategic choices: Best practic…

1
Database Query Optimization: Tools and Techniques for Faster Performance 5:16

14d ago5:16

5:16

Dive into the world of database query optimization with expert insights on identifying and improving slow-running queries. In this episode, we explore: Essential tools for pinpointing problematic queries in your database How to decode query execution plans and uncover performance bottlenecks Index optimization strategies and potential pitfalls to w…

1
Query Optimization: The Key to Boosting Database Performance 7:08

14d ago7:08

7:08

Unlock the secrets of query optimization and supercharge your database performance in this essential episode for aspiring senior backend engineers. In this episode, we explore: The critical role of query optimization in boosting database efficiency and user experience Key factors affecting query performance, including indexing strategies and query …

1
Database Transactions Explained: The Key to Ensuring Data Integrity 6:53

14d ago6:53

6:53

Dive into the world of database transactions and discover why they're crucial for maintaining data integrity in complex systems. In this episode, we explore: Understanding database transactions and their "all-or-nothing" nature Exploring ACID properties and their role in ensuring data reliability Real-world applications and potential pitfalls of tr…

1
Database Indexes Explained: Boosting Query Performance and Weighing the Trade-offs 6:13

14d ago6:13

6:13

Dive into the world of database indexes and learn how they can revolutionize query performance in this informative episode of "Relational Database Interview Crashcasts." In this episode, we explore: The power of database indexes: Discover how these data structures can dramatically speed up your queries Index varieties: Uncover the strengths of B-tr…

1
Demystifying SQL JOINs: INNER JOIN vs LEFT JOIN Explained with Examples 5:27

14d ago5:27

5:27

Unlock the power of SQL JOINs in this enlightening episode of Relational Database Interview Crashcasts, featuring expert insights from experienced database engineer Victor. In this episode, we explore: The crucial differences between INNER JOIN and LEFT JOIN, demystified with real-world examples A deep dive into other JOIN types, including RIGHT JO…

1
Primary vs. Foreign Keys: Understanding the Backbone of Relational Databases 7:08

14d ago7:08

7:08

Dive into the world of relational databases as we unravel the crucial differences between primary and foreign keys. In this episode, we explore: Key definitions and their vital roles in database design How primary and foreign keys work together to maintain data integrity Performance implications and real-world applications of these database corners…

1
Demystifying Database Normalization: Understanding 1NF, 2NF, and 3NF 6:12

14d ago6:12

6:12

Dive into the world of database normalization with expert insights on 1NF, 2NF, and 3NF. In this episode, we explore: The essentials of database normalization forms, from basic 1NF to advanced 3NF Key purposes and benefits of proper database structuring Real-world considerations and common pitfalls in normalization Join database expert Victor as he…

1
Relational Database Relationships Explained with Examples 5:31

14d ago5:31

5:31

Dive into the world of relational database relationships with expert insights from seasoned backend engineer Victor. In this episode, we explore: Three main types of database relationships with real-world examples Implementation techniques using foreign keys and join tables Advanced concepts: self-referential relationships, cardinality, and optiona…

1
Understanding ACID: The Key to Database Consistency and Reliability 6:14

14d ago6:14

6:14

Dive into the world of database reliability with our exploration of ACID properties, a fundamental concept for senior backend engineers and database administrators. In this episode, we explore: The four pillars of ACID: Atomicity, Consistency, Isolation, and Durability Real-world examples that illustrate each ACID property in action Why ACID is cru…

1
Relational vs. NoSQL Databases: Understanding the Differences and Best Use Cases 6:40

14d ago6:40

6:40

Dive into the world of databases as we explore the fundamental differences between relational and NoSQL databases, their strengths, and ideal use cases. In this episode, we explore: The structure and characteristics of relational databases NoSQL databases and their flexible data models Four main types of NoSQL databases and their unique features Ke…

1
SCP-136 - Naked Doll 11:50

15d ago11:50

11:50

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY kabu:www.scp-wiki.net/scp-136License: creativecommons.org/licenses/by-sa/3.0/----The voice of the Database was provided by Joshua Alan Lindsay.The voice of Dr. Meyers was provided by Romeo Rosales, Jr..----Sound Credits"Alert4.mp3” by RICHERlandTV of Freesound.or…

1
Pragmatic Knowledge Graphs with Ashleigh Faith 52:17

1M ago52:17

52:17

Speaker Resources: Ashleigh’s YT Channel: https://www.youtube.com/@AshleighFaith Tools of the Month: Abk: Any Airline using Windows 3.1 😆 Ashleigh: Zentity: https://zentity.io/ Jason: Cypher Co-pilot: https://neo4j.com/developer-blog/cypher-co-pilot/ Alison: System https://www.system.com Announcements / News: Articles: Turning Your Tabular Data Int…

1
SCP-135 - Universal Carcinogen 7:42

1M ago7:42

7:42

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY Pig_catapult:www.scp-wiki.net/scp-135License: creativecommons.org/licenses/by-sa/3.0/----The voice of the Database was provided by Joshua Alan Lindsay.----The outro music was written by Joshua Alan Lindsay.----Enjoy the podcast? Consider supporting us on Patreon!…

1
SCP-134 - Star-Eyed Child 9:14

1M ago9:14

9:14

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY Skali Sharpnose, Voct, AND AN UNKNOWN AUTHOR:www.scp-wiki.net/scp-134License: creativecommons.org/licenses/by-sa/3.0/----The voice of the Database was provided by Joshua Alan Lindsay.----The outro music was written by Joshua Alan Lindsay.----Enjoy the podcast? Co…

1
SCP-133 - Instant Hole 4:22

1M ago4:22

4:22

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY AN UNKNOWN AUTHOR, REWRITTEN BY Aelanna:www.scp-wiki.net/scp-133License: creativecommons.org/licenses/by-sa/3.0/----The voice of the Database was provided by Joshua Alan Lindsay.----The outro music was written by Joshua Alan Lindsay.----Enjoy the podcast? Conside…

1
SCP-132 - Broken Desert 9:23

2M ago9:23

9:23

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY Robert Sandler:www.scp-wiki.net/scp-132License: creativecommons.org/licenses/by-sa/3.0/----The voice of the Database was provided by Joshua Alan Lindsay.The voice of Dr. Peterson was provided by Spera Crinis.----Sound Credits"Alert4.mp3” by RICHERlandTV of Freeso…

1
SCP-131 - The "Eye Pods" 8:03

2M ago8:03

8:03

CLEARANCE GRANTED... WELCOME, AUTHORIZED PERSONNEL...SCRIPT BASED ON ORIGINAL ENTRY BY Lt Masipag:www.scp-wiki.net/scp-131License: creativecommons.org/licenses/by-sa/3.0/----The voice of the Database was provided by Joshua Alan Lindsay.----The outro music was written by Joshua Alan Lindsay.----Enjoy the podcast? Consider supporting us on Patreon! P…

1
Docker, AI, and More: Catch a Glimpse of the Java Ecosystem with Oleg Šelajev 45:25

2M ago45:25

45:25

Speaker Resources: Testcontainers https://testcontainers.com/ NODES 2024 https://dev.neo4j.com/nodes24 Tools of the Month: Neo4j Kubernetes documentation https://neo4j.com/docs/operations-manual/current/kubernetes/ ragas framework https://ragas.io/ Haiper.ai https://haiper.ai/home (Neo4j GenAI Package + DreamStudio.ai) Announcements / News: Neo4j G…

1
SCP Tales, Episode 13 - "The Deadname Meme" 40:44

2M ago40:44

40:44

Content Warning: Sexual references, mentions of gender dysphoria & deadnaming. (No actual deadnaming takes place.)----An SCP Tale by Queerious:www.scp-wiki.net/the-deadname-memeLicense: creativecommons.org/licenses/by-sa/3.0/----The voice of the Narrator and the Database was provided by Joshua Alan Lindsay.The voice of Dr. Heather Garrison was prov…

1
Migrating from Postgres to SQLite with Kent C. Dodds 51:30

3M ago51:30

51:30

Want to learn more about SQLite? Check out the full course: https://highperformancesqlite.com. Get production ready SQLite with Turso: https://tur.so/af. In this interview, I talk to Kent C. Dodds about SQLite, LiteFS and the React ecosystem. Kent: https://twitter.com/kentcdodds EpicWeb: https://www.epicweb.dev The Epic Stack: https://www.epicweb.d…

Подкасты, которые стоит послушать

Подкасты на тему Database

Подкасты, которые стоит послушать

Краткое руководство