{"id":11825,"date":"2025-09-13T20:50:51","date_gmt":"2025-09-13T20:50:51","guid":{"rendered":"https:\/\/putridparrot.com\/blog\/?p=11825"},"modified":"2025-09-13T20:50:51","modified_gmt":"2025-09-13T20:50:51","slug":"trying-out-surrealdb-with-rust","status":"publish","type":"post","link":"https:\/\/putridparrot.com\/blog\/trying-out-surrealdb-with-rust\/","title":{"rendered":"Trying out SurrealDB with Rust"},"content":{"rendered":"

SurrealDB is a multi-model database, which essentially means it allows storage of relation, document, graph, time-series, vector and search as well as geospatial models (as taken from the SurrealDB Overview<\/a>).<\/p>\n

SurrealDB allows queries through an SQL like query language as well as GraphQL, HTTP and RPC.<\/p>\n

There are SDKs for Rust (which I’m going to use here) along with JavaScript, Java, Go, Python, .NET and PHP. <\/p>\n

Whilst you can install on Windows, Linux and Mac I prefer using Docker, so let’s run up an instance of SurrealDB <\/p>\n

\r\ndocker run --rm -p 8000:8000 surrealdb\/surrealdb:latest start --log trace --user root --pass root memory\r\n<\/pre>\n
With a volume, either create yourself a folder (i.e. mkdir mydata) or use an existing path<\/p>\n
\r\ndocker run --rm -p 8000:8000 surrealdb\/surrealdb:latest start --log trace --user root --pass root mydb:\/mydata\/mydatabase.db\r\n<\/pre>\n
If you’d like to run a web based UI for SurrealDB, you can run Surrealist<\/p>\n
\r\ndocker run -d -p 8080:8080 surrealdb\/surrealist:latest\r\n<\/pre>\n
Then use this to connect to your running instance, default user is admin, default password is admin (obviously change this in a real world usage).<\/p>\n
Once connected via Surrealist we can create a namespace and database, here’s a simple example of such a query run via Surrealist<\/p>\n
\r\nUSE NS myns DB mydb;\r\n<\/pre>\n
Yes, we literally just use the namespace and database for the first time to create both. Now let’s a some data, creating a “table” using<\/p>\n
\r\nCREATE person CONTENT {\r\n  first_name: "Scooby",\r\n  last_name: "Doo",\r\n  age: 42,\r\n  email: "scooby.doo@example.com"\r\n};\r\n<\/pre>\n
We can query for the list of “person” rows using<\/p>\n
\r\nSELECT * FROM person;\r\n<\/pre>\n
As you can see, it’s very SQL like syntax with some differences. <\/p>\n
We didn’t created an id or such like field, but if you select the rows from the person table you’ve notice something like this<\/p>\n
\r\n[\r\n  {\r\n    age: 42,\r\n    email: 'scooby.doo@example.com',\r\n    first_name: 'Scooby',\r\n    id: person:77xrs2c05oe9bmtgjbhq,\r\n    last_ame: 'Doo'\r\n  }\r\n]\r\n<\/pre>\n
We could have supplied an id ourselves like this<\/p>\n
\r\nCREATE person CONTENT {\r\n  first_name: "Fred",\r\n  last_name: "Jones",\r\n  age: 19,\r\n  id: person:fredjones,\r\n  email: "fred.jones@example.com"\r\n};\r\n<\/pre>\n
We can update a row using <\/p>\n
\r\nUPDATE person:77xrs2c05oe9bmtgjbhq SET name="Scrappy", age = 23;\r\n<\/pre>\n
There are obviously more commands\/queries we could use, but let’s move on to using the DB from Rust. <\/p>\n
We’ll start by adding a few dependencies to Cargo.toml<\/p>\n
\r\n[dependencies]\r\ntokio = { version = "1.47.1", features = ["full"] }\r\nsurrealdb = "2.3.8"\r\nserde = { version = "1.0.219", features = ["derive"] }\r\n<\/pre>\n
Next update main.rs to look like this<\/p>\n
\r\nuse surrealdb::{Surreal};\r\nuse surrealdb::engine::remote::ws::Ws;\r\nuse std::error::Error;\r\nuse surrealdb::opt::auth::Root;\r\n\r\nuse surrealdb::sql::Thing;\r\nuse serde::Deserialize;\r\n\r\n#[derive(Debug, Deserialize)]\r\nstruct Person {\r\n    id: Thing,\r\n    first_name: String,\r\n    last_name: String,\r\n    email: String,\r\n    age: u32,\r\n}\r\n\r\n#[tokio::main]\r\nasync fn main() -> Result<(), Box<dyn Error>> {\r\n    let db = Surreal::new::<Ws>("127.0.0.1:8000").await?;\r\n    db.signin(Root { username: "root", password: "root" }).await?;\r\n    db.use_ns("myns").use_db("mydb").await?;\r\n\r\n    let result: Vec<Person> = db.query("SELECT * FROM person").await?.take(0)?;\r\n\r\n    println!("{:?}", result);\r\n    Ok(())\r\n}\r\n<\/pre>\n
We’re using the default username and password. Ofcourse you should change the password for this user and create your own user, but for now, let’s just get things up and running.<\/p>\n
Notice that we connect to SurrealDB via the web socket.<\/p>\n
You may have also noticed that in our Person struct we have an id Thing<\/em>. This is essentially a record pointer, which has the table name and record id.<\/p>\n","protected":false},"excerpt":{"rendered":"
SurrealDB is a multi-model database, which essentially means it allows storage of relation, document, graph, time-series, vector and search as well as geospatial models (as taken from the SurrealDB Overview). SurrealDB allows queries through an SQL like query language as well as GraphQL, HTTP and RPC. There are SDKs for Rust (which I’m going to […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[191,755],"tags":[],"class_list":["post-11825","post","type-post","status-publish","format-standard","hentry","category-rust","category-surrealdb"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/11825","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/comments?post=11825"}],"version-history":[{"count":5,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/11825\/revisions"}],"predecessor-version":[{"id":11837,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/posts\/11825\/revisions\/11837"}],"wp:attachment":[{"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/media?parent=11825"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/categories?post=11825"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/putridparrot.com\/blog\/wp-json\/wp\/v2\/tags?post=11825"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}