episode-header-image

Oct 2021

22m 27s

On Graph Databases | The Backend Enginee...

About this episode

I get a lot of emails asking me to talk about graph databases, so I want to start researching them, but I wanted to give you guys the framework of how I think about any databases to defuse any “magic” that might be there.

In this video, I discuss what constrains a database and how the use cases try to work around them.

0:00 Intro

1:50 What constrains a database?

4:00 Indexing Techniques

5:30 Storage Engines - Row-Store

9:00 Columnar Databases

12:00 Graph use cases

16:00 Graph Storage Engines

Learn the fundamentals of databases, grab my my Introduction to Database Engineering udemy course here for a discount coupon https://database.husseinnasser.com 🧑‍🏫

Up next

How a query optimization gave birth to infinite scroll

The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro1:00 ... Show More

Postgres is half as fast in Linux 7.0

An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel. The cause turns out to be massive TLB and page faults exacerbated by Postgres process-based design. In this backend engineering show episode I dive deep into how this was di ... Show More

Don't let AI rob you

A discussion about why many engineers still love the struggle, the mistakes, and the process of figuring things out themselves. This is how we grow and get better and stronger. Letting AI do everything (even though it can’t) robs us this feeling..

Recommended Episodes

Customizing a Graph Solution

<p>In this episode, Dave Bechberger, principal Graph Architect at AWS and author of "Graph Databases in Action", brings deep insights into the field of graph databases and their applications.</p> <p><br /> Together we delve into specific scenarios in which Graph Databases provide ... Show More

Hashing It Out - Pranav Maheshwari - TheGraph

Today Corey talks with Pranav Maheshwari from The Graph, an indexing protocol for querying networks like Ethereum and IPFS. We'll dive deep into how The Graph works, what it aims to solve, what complications it has faced as it has scaled out to its current state, and where it exp ... Show More

#1028: Databases

<p>In this podcast, I talk about one of the most important tools we use for Magic design—databases. I walk through the history of our databases and explain how we use them.</p>

Graph Databases and AI

In this episode, we sit down with Yuanyuan Tian, a principal scientist manager at Microsoft Gray Systems Lab, to discuss the evolving role of graph databases in various industries such as fraud detection in finance and insurance, security, healthcare, and supply chain optimizatio ... Show More

#687: Graph Analytics Breakdown

In this conversation, Jillian Forde interviews Dave Bechberger, Principal Graph Architect at AWS, where they talk through the fundamentals of graphs and their applications. This is a wide ranging conversation on graphs from their use cases in generative AI, choosing between Amazo ... Show More

GraphRAG (beyond the hype)

Seems like we are hearing a lot about GraphRAG these days, but there are lots of questions: what is it, is it hype, what is practical? One of our all time favorite podcast friends, Prashanth Rao, joins us to dig into this topic beyond the hype. Prashanth gives us a bit of backgro ... Show More

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

Picking a database should be simple (Changelog & Friends #56)

Database aficionado, Ben Johnson, joins Jerod to answer the age ol' question: which database should you use? Answering that isn't always easy, which means it's time to play the "It Depends" jingle & weigh (some of) the options.

Fraud Detection with Graphs

In this episode, Šimon Mandlík, a PhD candidate at the Czech Technical University will talk with us about leveraging machine learning and graph-based techniques for cybersecurity applications. We'll learn how graphs are used to detect malicious activity in networks, such as ident ... Show More