Industry: Mobile software development
Migration: from PostgreSQL to SurrealDB
Yaacomm, a mobile software development company based in the Netherlands and founded in 2006, has spent the past decade building high quality innovative communication solutions for a wide range of customers in the Netherlands, including companies, organisations and funds in diverse sectors including health care, aviation, and the metal industry.
PostgreSQL's rigid schema structure made it difficult to iterate quickly and maintain complex queries for diverse customer requirements.
Performance spikes and complex, difficult-to-maintain queries when tracking relations between app users and content interactions.
The need to define and maintain rigid database schemas created bottlenecks in development and deployment processes.
The existing architecture struggled to support the diverse requirements of different customer sectors and use cases.
Migrated to SurrealDB's schemaless tables, eliminating the need for rigid database schemas and enabling faster iteration.
Leveraged edge tables and relations extensively, with roughly half of tables designated as edge tables for optimized queries.
Utilized viewer and editor access roles through Surrealist to prevent unintended modifications while maintaining data integrity.
Successfully migrated from Firebase and PostgreSQL to SurrealDB, maintaining data structure while gaining new capabilities.
No longer need to maintain complex rigid schemas, enabling much faster iteration and development cycles.
Significantly decreased query complexity while overcoming performance issues previously encountered with PostgreSQL.
Effortlessly track and analyse relations between app users and content interactions for precise audience targeting.
Positioned to integrate full-text searching for articles, documents, and extensive text-based content.
With SurrealDB's graph-based architecture and schemaless design, Yaacomm can now offer their customers functionality that was not feasible before, while maintaining the flexibility needed for diverse use cases across healthcare, aviation, and metal industry sectors.
Get in touch to learn more →