https://surrealdb.com/ Home Install Blog Product Why SurrealDB? Features Releases Roadmap Documentation Community Community GitHub LinkedIn Twitter YouTube Join cloud waitlist Home Install Community Product Why SurrealDB? Understand why SurrealDB is the ultimate cloud database. Features Get a detailed overview of all of SurrealDB's technical features. Releases Keep track of the notable updates and improvements for every SurrealDB product release in chronological order. Roadmap See what we have planned for SurrealDB, and see the features and functionality which has already been implemented. Blog GitHub Twitter LinkedIn Dev YouTube Discord Stack Overflow Docs Blog Star us on GitHub Join cloud waitlist SurrealDB logo SurrealDB is the ultimate cloud database for tomorrow's applications Develop easier.Build faster.Scale quicker. With an SQL-style query language, real-time queries with highly-efficient related data retrieval, advanced security permissions for multi-tenant access, and support for performant analytical workloads, SurrealDB is the next generation serverless database. Install Documentation Join cloud waitlist Why use SurrealDB? SurrealDB is an innovative NewSQL cloud database, suitable for serverless applications, jamstack applications, single-page applications, and traditional applications. It is unmatched in its versatility and financial value, with the ability for deployment on cloud, on-premise, embedded, and edge computing environments. For a hassle-free setup, get started with SurrealDB Cloud in one-click. Jamstack apps Serverless apps # Develop easier There is no need for your team to learn new complicated database languages. Getting started with SurrealDB is as simple as one command - and advanced functionality is simple to understand, whilst still being fast and performant. # Build faster SurrealDB simplifies your database and API stack, removing the need for most server-side components. As a web database, client-side applications can be built with direct connections to SurrealDB, while traditional server-side development techniques can still leverage the powerful but simple querying and analytics abilities. # Scale quicker Forget about scaling databases, servers, loadbalancers, and API endpoints. SurrealDB takes the hassle out of your stack, enabling you to grow and operate at scale with a highly-available, highly-scalable distributed platform. Deploy anywhere, or keep it simple with SurrealDB Cloud. [database-a] Database, realtime API layer, and security permissions all-in-one SurrealDB combines the database layer, the querying layer, and the API and authentication layer into one platform. Advanced table-based and row-based customisable access permissions allow for granular data access patterns for different types of users. There's no need for custom backend code and security rules with complicated database development. Tables, documents, and graph. Store and model your data in any way As a multi-model database, SurrealDB enables developers to use multiple techniques to store and model data, without having to choose a method in advance. With the use of tables, SurrealDB has similarities with relational databases, but with the added functionality and flexibility of advanced nested fields and arrays. Inter-document record links allow for simple to understand and highly-performant related queries without the use of JOINs, eliminating the N+1 query problem. [multimodel] [graph-data] Advanced inter-document relations and analysis. No JOINs. No pain. With full graph database functionality SurrealDB enables more advanced querying and analysis. Records (or vertices) can be connected to one another with edges, each with its own record properties and metadata. Simple extensions to traditional SQL queries allow for multi-table, multi-depth document retrieval, efficiently in the database, without the use of complicated JOINs and without bringing the data down to the client. Simple schema definition for frontend and backend development With SurrealDB, specify your database and API schema in one place, and define column rules and constraints just once. Once a schema is defined, database access is automatically granted to the relevant users. No more custom API code, and no more GraphQL integration. Simple, flexible, and ready for production in minutes not months. [schema-dir] [browser-sy] Connect and query directly from web-browsers and client devices Connect directly to SurrealDB from any end-user client device. Run SurrealQL queries directly within web-browsers, ensuring that users can only view or modify the data that they are allowed to access. Highly-performant WebSocket connections allow for efficient bi-directional queries, responses and notifications. Query the database with the tools you want. Your data, your choice. SurrealDB is designed to be flexible to use, with support for SurrealQL, GraphQL (coming soon), CRUD support over REST, and JSON-RPC querying and modification over WebSockets. With direct-to-client connection with in-built permissions, SurrealDB speeds up the development process, and fits in seamlessly into any tech stack. [multiple-i] [realtime-l] Realtime live queries and data changes direct to application SurrealDB keeps every client device in-sync with data modifications pushed in realtime to the clients, applications, end-user devices, and server-side libraries. Live SQL queries allow for advanced filtering of the changes to which a client subscribes, and efficient data formats, including DIFFing and PATCHing enable highly-performant web-based data syncing. Scale effortlessly to hundreds of nodes for high-availability and scalability SurrealDB can be run as a single in-memory node, or as part of a distributed cluster - offering highly-available and highly-scalable system characteristics. Designed from the ground up to run in a distributed environment, SurrealDB makes use of special techniques when handling multi-table transactions, and document record IDs - with no use of table or row locks. [scale-up-3] [database-p] Extend your database with JavaScript and WebAssembly functions Embedded JavaScript functions allow for advanced, custom functionality, with computation logic being moved to the data layer. This improves upon the traditional approach of moving data to the client devices before applying any computation logic, ensuring that only the necessary data is transferred remotely. These advanced JavaScript functions, with support for the ES2020 standard, allow any developer to analyse the data in ever more simple-yet-advanced ways. Designed to be embedded or to run distributed in the cloud Built entirely in Rust as a single library, SurrealDB is designed to be used as both an embedded database library with advanced querying functionality, and as a database server which can operate in a distributed cluster. With low memory usage and cpu requirements, SurrealDB has been specifically designed to run in all types of environment. [cloud-or-e] A highly-scalable NewSQL database SurrealDB is a flexible, developer-friendly, fully ACID transactional, realtime document-graph web database for serverless applications. Never again worry about database provisioning, scaling, sharding, replication, or correctness. # Document & graph database # JOIN-less deep fetching # Distributed ACID transactions # Built with Rust # Structured and un-structured data # SQL-style querying # GraphQL and REST API # Support for multi-tenant apps # Multi-row, multi-table transactions # Online and offline data sync # In-built access and permissions # Multi-column and full-text indexes # Incrementally computed views # Distributed and highly-scalable # No complex back-end servers and APIs Improved data modelling SurrealDB doesn't force you into setting up your data model in any one way. Instead you can choose between simple documents, documents with embedded fields, or related graph connections between records. Use schemafull or schemaless tables giving you the flexibility to store whatever you need. Once stored in SurrealDB, all data is strongly typed, with the ability to convert between different types seamlessly - and numbers can be stored and computed with 64 bit precision or as arbitrary length decimals. View all features Get started with SurrealDB -- Create a 'user' record CREATE user SET age = 34, enabled = true, -- Store the current time created_at = time::now(), -- Specify embedded fields name.first = "Tobie", name.last = "Morgan Hitchcock", -- Add a field which is computed from other fields name.full = string::join(' ', name.first, name.last), -- Add an array whose values point to other remote records friends = [user:gna732gnajan74hj, user:gna732gnajan74hj], ; -- Select all users and fetch the users' friends' names SELECT *, friends.*.name.full AS friends FROM user; -- Set a variable to be used in subsequent statements LET $tobie = (SELECT * FROM user WHERE name.first = "Tobie"); -- Select all users with complex graph traversal SELECT *, -- Select all users who like this user <-like<-user AS friends, -- Select all products which friends have purchased <-like<-user->purchase->product AS recommended -- Only look at the single user selected above FROM $tobie ; Powerful querying abilities The primary method of querying SurrealDB is using SurrealQL, a similar but modified version of traditional SQL. SurrealQL enables linked documents to be traversed and queried efficiently, while still using an imperative language which remains understandable by data scientists. With an innovative, but simple-to-understand, SQL language developers or data scientists can use a myriad of different techniques to store, query, and analyse the data in SurrealDB. View all features Get started with SurrealDB Simplified data analytics SurrealDB is designed to be quick to setup, and even quicker to implement. Multi-column indexes can be easily added and removed as your application evolves, allowing for strongly consistent reads and writes, and highly-performant reads. Pre-computed table views allow superfast and highly-efficient aggregated data for queries which are known upfront - with simple view definition as easy as writing an SQL statement. View all features Get started with SurrealDB -- Add a new 'user' record with some basic attributes CREATE user SET age = 34, gender = 'm', name = 'Tobie Morgan Hitchcock' ; -- Define a table which aggregates data from another table DEFINE TABLE users_by_gender AS SELECT gender, count() AS total, math::mean(age) AS average_age FROM user GROUP BY gender ; -- Specify access permissions for the 'post' table DEFINE TABLE post SCHEMALESS PERMISSIONS FOR select -- Published posts can be selected WHERE published = true -- A user can select all their own posts OR user = $auth.id FOR create, update -- A user can create or update their own posts WHERE user = $auth.id FOR delete -- A user can delete their own posts WHERE user = $auth.id -- Or an admin can delete any posts OR $auth.admin = true ; Faster app development times WIth permissions in-built from the ground up, SurrealDB is the perfect web-database for serverless applications. Easily specify permissions with easy-to-write SQL statements, ensuring that only the correct users can access the specified data that they have permission to select or modify. With support for SSL/TLS, Single-Sign-On, external 3rd party authentication, JWT token based authentication, and custom business authentication logic - SurrealDB offers strong security, with the flexibility of custom authentication methods that suit your app or business. View all features Get started with SurrealDB Superpowered database functionality When connecting with SurrealDB, all connections are made using WebSockets, allowing for bi-directional data syncing. Dependent on data access permissions, client-based document subscriptions are triggered in real-time whenever changes are made to the data. Data subscriptions can be specified for whole tables, filtered result sets, or individual records - enabling a multitude of different use-cases in all types of applications. View all features Get started with SurrealDB -- Subscribe to all changes to documents which match LIVE SELECT * FROM document WHERE account = $auth.account OR public = true ; -- Subscribe to all changes to a single 'post' record LIVE SELECT * FROM post:c569rth77ad48tc6s3ig; -- Stop receiving change notifications KILL "1986cc4e-340a-467d-9290-de81583267a2"; Simplify your SurrealDB experience Manage your data with the simplicity of a spreadsheet. Setup authentication rules, tables, indexes, triggers, and run full SQL queries without ever having to leave the dashboard. The SurrealDB management interface will be included with every SurrealDB instance. Coming soon SurrealDB Application Interface Loved by developers