SurrealDB: Why JOINs are So 2010 and How Graphs Change Everything (Part 3)

The Mental Gymnastics of Data We’ve all been there. You start with a simple Document DB because "it’s flexible." Then your boss says: "Hey, can we show which friends of this user liked the same products in the last 24 hours?" Suddenly, your "flexible" NoSQL setup becomes a nightmare of application-side joins, or you’re staring at a SQL query so long it looks like a spell from Harry Potter. As a medior dev, I’ve learned that the hardest part of coding isn't the logic—it's managing the relationships between data without losing your mind. That’s where the "Surreal" in SurrealDB finally clicks. Graphs vs. Joins: The Arrow Power 🏹 In traditional SQL, you have "Join Tables" (the middleman nobody likes). In SurrealDB, records can point to each other directly using Graph relations. Instead of a 20-line JOIN statement, you use arrows. It’s intuitive, it’s fast, and it’s actually readable: -- Find all products liked by people I follow SELECT -> follows -> person -> liked -> product FROM user : t