The official SurrealDB SDK for Rust.
# surrealdb
The official SurrealDB SDK for Rust.
What is SurrealDB?
SurrealDB is an end-to-end cloud native database for web, mobile, serverless, jamstack, backend, and traditional applications. SurrealDB reduces the development time of modern applications by simplifying your database and API stack, removing the need for most server-side components, allowing you to build secure, performant apps quicker and cheaper. SurrealDB acts as both a database and a modern, realtime, collaborative API backend layer. SurrealDB can run as a single server or in a highly-available, highly-scalable distributed mode - with support for SQL querying from client devices, GraphQL, ACID transactions, WebSocket connections, structured and unstructured data, graph querying, full-text indexing, geospatial querying, and row-by-row permissions-based access.
View the [features](https://surrealdb.com/features), the latest [releases](https://surrealdb.com/releases), and [documentation](https://surrealdb.com/docs).
Features
- [x] Can be used as an embedded database (`Surreal`)
- [x] Connects to remote servers (`Surreal` or `Surreal`)
- [x] Allows picking any protocol or storage engine at run-time (`Surreal`)
- [x] Compiles to WebAssembly
- [x] Supports typed SQL statements
- [x] Invalid SQL queries are never sent to the server, the client uses the same parser the server uses
- [x] Clonable connections with auto-reconnect capabilities, no need for a connection pool
- [x] Range queries
- [x] Consistent API across all supported protocols and storage engines
- [x] Asynchronous, lock-free connections
- [x] TLS support via either [`rustls`](https://crates.io/crates/rustls) or [`native-tls`](https://crates.io/crates/native-tls)
Documentation
View the SDK documentation [here](https://surrealdb.com/docs/integration/libraries/rust).
How to install
To add this crate as a Rust dependency, simply run
```bash
cargo add surrealdb
```
Quick look
This library enables simple and advanced querying of an embedded or remote database from server-side or client-side (via Wasm) code. By default, all remote connections to SurrealDB are made over WebSockets, and automatically reconnect when the connection is terminated. Connections are automatically closed when they get dropped.
```rust
use serde::{Deserialize, Serialize};
use serde_json::json;
use surrealdb::sql;
use surrealdb::sql::Thing;
use surrealdb::Surreal;
use surrealdb::engine::remote::ws::Ws;
use surrealdb::opt::auth::Root;
use surrealdb::Error;
#[derive(Serialize, Deserialize)]
struct Name {
first: String,
last: String,
}
#[derive(Serialize, Deserialize)]
struct Person {
#[serde(skip_serializing)]
id: Option,
title: String,
name: Name,
marketing: bool,
}
// Install at https://surrealdb.com/install
// and use `surreal start --user root --pass root`
// to start a working database to take the following queries
//
// See the results via `surreal sql --ns namespace --db database --pretty`
// or https://surrealist.app/
// followed by the query `SELECT * FROM person;`
#[tokio::main]
async fn main() -> Result<(), Error> {
let db = Surreal::new::("localhost:8000").await?;
// Signin as a namespace, database, or root user
db.signin(Root {
username: "root",
password: "root",
})
.await?;
// Select a specific namespace and database
db.use_ns("namespace").use_db("database").await?;
// Create a new person with a random ID
let tobie: Vec = db
.create("person")
.content(Person {
id: None,
title: "Founder & CEO".into(),
name: Name {
first: "Tobie".into(),
last: "Morgan Hitchcock".into(),
},
marketing: true,
})
.await?;
// Create a new person with a specific ID
let mut jaime: Option = db
.create(("person", "jaime"))
.content(Person {
id: None,
title: "Founder & COO".into(),
name: Name {
first: "Jaime".into(),
last: "Morgan Hitchcock".into(),
},
marketing: false,
})
.await?;
// Update a person record with a specific ID
jaime = db
.update(("person", "jaime"))
.merge(json!({ "marketing": true }))
.await?;
// Select all people records
let people: Vec = db.select("person").await?;
// Perform a custom advanced query
let query = r#"
SELECT marketing, count()
FROM type::table($table)
GROUP BY marketing
"#;
let groups = db.query(sql)
.bind(("table", "person"))
.await?;
// Delete all people up to but not including Jaime
let people: Vec = db.delete("person").range(.."jaime").await?;
// Delete all people
let people: Vec = db.delete("person").await?;
Ok(())
}
```