DEV Community

Alex Spinov
Alex Spinov

Posted on

SurrealDB Has a Free Multi-Model Database — SQL, Graph, Document in One Database

SurrealDB is a multi-model database — use SQL, graph queries, and document storage in a single database.

What You Get for Free

  • Multi-model — relational, document, graph in one DB
  • SurrealQL — SQL-like with graph traversal and JSON
  • Real-time — live queries, WebSocket subscriptions
  • Permissions — row-level security with DEFINE ACCESS
  • Functions — server-side JavaScript/TypeScript functions
  • Full-text search — built-in search indexes
  • Geospatial — geographic data types and queries
  • Schema-full or schema-less — flexible per table
  • Single binary — runs anywhere, embeddable

Quick Start

curl -sSf https://install.surrealdb.com | sh
surreal start --user root --pass root
Enter fullscreen mode Exit fullscreen mode
-- Relational
CREATE user:1 SET name = 'Alice', age = 30;
CREATE post:1 SET title = 'Hello', author = user:1;

-- Graph
RELATE user:1->wrote->post:1;
SELECT ->wrote->post FROM user:1;

-- Document (nested JSON)
CREATE product SET specs = { weight: '1.2kg', color: 'blue', tags: ['new', 'sale'] };

-- All in one database, one query language
Enter fullscreen mode Exit fullscreen mode

Why Developers Switch from PostgreSQL + Neo4j

Running separate databases for SQL and graph is operational overhead:

  • One database — SQL + graph + document, no data sync
  • Real-time — LIVE SELECT for push notifications
  • Permissions — DEFINE ACCESS on tables, not application-level
  • Simpler ops — one backup, one connection string, one dashboard

A social app ran PostgreSQL (users, posts) + Neo4j (followers, recommendations). After SurrealDB: one database, graph queries for recommendations, SQL for CRUD, eliminated data sync issues.

Need Custom Data Solutions?

I build production-grade scrapers and data pipelines for startups, agencies, and research teams.

Browse 88+ ready-made scrapers on Apify → — Reddit, HN, LinkedIn, Google, Amazon, and more.

Custom project? Email me: spinov001@gmail.com — fast turnaround, fair pricing.

Top comments (0)