DBDB.io The Encyclopedia of Database Systems · Est. 2017
Database of Databases

Database Entry

SurrealDB


SurrealDB is a multi-model DBMS that supports embedded and shared-nothing deployments. It uses a hybrid data model that combines documents with explicit graph edge relationships.[03]

Source Code
https://github.com/surrealdb/surrealdb[02]
Twitter
@surrealdb
Developer
Country of Origin
GB
Start Year
2016 [08]
Project Types
Commercial, Open Source
Written in
Rust
Supported Languages
Go, JavaScript, Rust
Embeds / Uses
EchoDB, FoundationDB, RocksDB, TiKV
Compatible With
EchoDB, FoundationDB, RocksDB, TiKV
Operating Systems
Linux, macOS, Windows

Database Entry

SurrealDB


SurrealDB is a multi-model DBMS that supports embedded and shared-nothing deployments. It uses a hybrid data model that combines documents with explicit graph edge relationships.[03]

History[04]


The work on SurrealDB was started in 2016 by Tobie and Jamie Morgan Hitchcock as a private project. The first functional version of SurrealDB was completed in 2017 and it was written completely in Go. In 2021, the source code for the SurrealDB project was made public to allow contributions from the outside world. Work on building an improved version of SurrealDB with Rust from scratch also begin in 2021. In 2022, SurrealDB was released in public beta mode.

Checkpoints[02]


SurrealDB does not explicitly support checkpoints. However, SurrealDB internally uses other key-value store databases for storing user data and metadata in the backend. Some of these backends like RocksDB do support checkpointing and might create checkpoints in the background.

Data Model[05]


SurrealDB supports relational, document, and graph-based data models. By default, SurrealDB creates schema-less documents, however the SurrealQL syntax provides functionality for creating fixed-schema tables as well. Graph-based models are constructed by representing the nodes and the edges as relations that are related by record links.

Foreign Keys


SurrealDB does not have the concept of foreign keys. It instead uses record links to link records in different relations like the edges of a graph.

Joins[06]


SurrealDB does have the concept of joins. Instead of Joins between pre-defined relations, SurrealDB uses graph edges (record links) to link records to each other. With graph edges and the ability to store arrays and objects as field members, SurrealDB can provide the functionality of Joins along with other graph-based operations like path traversal.

Query Execution


Query Interface[07]


SurrealDB can be started as an independent process or embedded in the application as a library. As an independent process, it is possible to interact with the database using either the SurrealQL REPL (if SurrealDB is running locally), or using the HTTP/REST endpoints. As a library, SurrealDB can be used in other applications by interfacing with the APIs provided by the SurrealDB library. SurrealDB also provides the WebSocket API which can be interfaced with using RPCs.

Storage Organization


Stored Procedures


System Architecture


Citations

8 sources
  1. SurrealDB | The context layer for AI agents surrealdb.com
  2. GitHub - surrealdb/surrealdb: A scalable, distributed, collaborative, document-graph database, for the realtime web · GitHub github.com
  3. Getting started | SurrealDB Docs surrealdb.com
  4. SurrealDB | The context layer for AI agents surrealdb.com
  5. DEFINE TABLE | SurrealDB Docs surrealdb.com
  6. Record links | SurrealDB Docs surrealdb.com
  7. https://surrealdb.com/docs/integration surrealdb.com
  8. https://www.linkedin.com/pulse/dreaming-something-better-surrealdb?trackingId=7cArqAk1EAsOH2sp706tuQ== linkedin.com
Revision #11 Last Updated: