What is SurrealDB?

SELECT id, title,
    vector::distance::knn() AS vec_dist,
    search::score(1) AS ft_score,
    (1 - vector::distance::knn()) * 0.6
        + search::score(1) * 0.4
        AS blend_score
    FROM knowledge_base
    WHERE tenant = $tenant
        AND updated_at > time::now() - 30d
        AND id IN $customer->owns->product
            ->has_issue->knowledge_base
        AND content_embedding <|50,20|>
            $query_embedding
        AND content @1@ $query_text
    ORDER BY blend_score DESC
    LIMIT 10;

-- HNSW graph for vector similarity
DEFINE INDEX product_vec ON product
    FIELDS embedding
    HNSW DIMENSION 1536 DIST COSINE;

-- BM25 inverted index for full-text
DEFINE INDEX article_ft ON article
    FIELDS content
    FULLTEXT ANALYZER english BM25;

-- B-tree for structured lookups
DEFINE INDEX user_email ON user
    FIELDS email UNIQUE;

-- A traversal feeds a vector ranking
-- as one stream
SELECT id, name,
    vector::distance::knn() AS dist
    FROM customer:acme->owns->product
    WHERE embedding <|10|> $query_vec
    ORDER BY dist
    LIMIT 5;

-- An edge with its own fields
RELATE customer:acme->owns->product:p42
    SET since = time::now(),
        seat_count = 120;

-- Walk it, filtering the edge
SELECT ->owns[WHERE seat_count > 50]->product.name
    FROM customer:acme;

-- Two hops, bounded depth
SELECT ->owns->product->has_issue->knowledge_base
    FROM customer:acme;

-- The query you already wrote, as a stream
LIVE SELECT * FROM knowledge_base
    WHERE tenant = $tenant;

-- Only the change, not the whole record
LIVE SELECT DIFF FROM task
    WHERE status != "closed";

-- The client receives each commit:
-- { action: "UPDATE", result: { id: task:9f2, ... } }

-- Stop receiving updates
KILL $live_id;