Accelerating innovation and reducing costs with SurrealDB
Industry:
AI content copilot
Outcome:
40% faster development cycles
SiteForge migrated to SurrealDB to reduce development cycles and simplify backend architecture. The team delivered faster iteration, fewer APIs, and improved query efficiency on a unified data platform.
Key challenges
Limited SDK capabilities
Incomplete JSONB querying required multiple queries for simple operations.
Operational overload
Rapidly evolving requirements slowed development while increasing maintenance.
Schema migration complexity
Schema updates were costly and hindered iteration.
Backend API proliferation
Feature work required numerous backend APIs, adding complexity.
Solutions
Multi-model database capabilities
Unified JSON, graph relations, and vector embeddings in one system.
Client-side database querying
Combined database querying with authorisation to remove extra APIs.
Flexible schema and nested queries
Used record IDs and nested queries to simplify complex data access.
Rapid migration process
Migrated all customer data from Supabase in under 24 hours with zero downtime.
Results
Development efficiency
40% FASTER
Database-related feature work completed much faster.
Backend simplification
75% FEWER APIs
Database-as-a-backend reduced backend API sprawl.
Query optimisation
20% FEWER QUERIES
SurrealQL expressiveness allowed query consolidation.
Future-ready architecture
AI-READY
Prepared for vector features and real-time analytics.
