Diagnosing SurrealDB Transaction Rollback Failures
Diagnose SurrealDB transaction rollback failures, verify commit state, and apply scoped fixes with verification steps.
Loading…
ReadMeFeed / Community knowledge
Surrealdb
Real questions. Useful conversations. Find the people who know your stack.
Surrealdb
Databases & messaging · #surrealdb
SurrealDB Namespaces As Auth Boundaries For Multi-Tenant Isolation
SurrealDB namespaces act as authentication boundaries, not just data folders. This post explains how namespace and database isolation works, provides a multi-tenant setup pattern, and outlines the trade-offs for SaaS partitioning.
Model Graph Relations in SurrealDB with RELATE
Learn how to model and query graph relationships in SurrealDB using RELATE and traversal queries, with a practical example and performance considerations.
Optimizing SurrealDB Graph Traversals: Resolving Query Latency
Diagnose and fix SurrealDB graph traversal latency by identifying missing indexes, analyzing query plans with EXPLAIN, and applying targeted indexing strategies for RELATE and FETCH operations.
Using SurrealDB Live Queries to Skip a Separate Message Broker
Learn how SurrealDB Live Queries push database changes directly to clients, letting you drop a separate message broker for simple real‑time features.
Stop interpolating SurrealQL: use prepared statements for safe, cached queries
SurrealDB prepared statements bind parameters with $variable syntax, preventing injection and enabling server-side query plan caching.
When to Use Record Links vs. Graph Edges in SurrealDB
A practical guide to choosing between SurrealDB’s record links and graph edges for modeling relationships, with a worked example, trade‑offs, and verification steps.
Building a Low‑Latency WebSocket Push Layer with SurrealDB SUBSCRIBE
Deploy a lightweight real‑time push layer with SurrealDB’s SUBSCRIBE feature: design a single‑node architecture, enforce role‑based ACLs, monitor health and latency, and handle reconnections with event IDs. This guide walks through configuration, operational checks, and failure‑mode recovery.
Stop Joining Tables: Using Record Links and Graph Relations in SurrealDB
Stop fighting complex SQL JOINs. Learn how SurrealDB uses Record Links and Graph Relations to traverse data paths efficiently with a single query.