SurrealQL language preview
1. Define and select
SCHEMAFULL tables, record ids, and WHERE
horizon-dark
DEFINE TABLE user SCHEMAFULL;
SELECT * FROM user:alice WHERE age > 18;atom-one-dark
DEFINE TABLE user SCHEMAFULL;
SELECT * FROM user:alice WHERE age > 18;github-dark
DEFINE TABLE user SCHEMAFULL;
SELECT * FROM user:alice WHERE age > 18;dracula
DEFINE TABLE user SCHEMAFULL;
SELECT * FROM user:alice WHERE age > 18;nord
DEFINE TABLE user SCHEMAFULL;
SELECT * FROM user:alice WHERE age > 18;github
DEFINE TABLE user SCHEMAFULL;
SELECT * FROM user:alice WHERE age > 18;2. Create and relate
SET fields and graph edges
horizon-dark
CREATE user SET name = "Ada";
RELATE user:alice->wrote->post:hello;atom-one-dark
CREATE user SET name = "Ada";
RELATE user:alice->wrote->post:hello;github-dark
CREATE user SET name = "Ada";
RELATE user:alice->wrote->post:hello;dracula
CREATE user SET name = "Ada";
RELATE user:alice->wrote->post:hello;nord
CREATE user SET name = "Ada";
RELATE user:alice->wrote->post:hello;github
CREATE user SET name = "Ada";
RELATE user:alice->wrote->post:hello;3. Live query
comments and string predicates
horizon-dark
// users who wrote a post
LIVE SELECT * FROM user WHERE name = "Ada";atom-one-dark
// users who wrote a post
LIVE SELECT * FROM user WHERE name = "Ada";github-dark
// users who wrote a post
LIVE SELECT * FROM user WHERE name = "Ada";dracula
// users who wrote a post
LIVE SELECT * FROM user WHERE name = "Ada";nord
// users who wrote a post
LIVE SELECT * FROM user WHERE name = "Ada";github
// users who wrote a post
LIVE SELECT * FROM user WHERE name = "Ada";