Yaacomm moved its apps from PostgreSQL to SurrealDB for schemas that bend with each industry
Yaacomm builds mobile apps for customers in healthcare, aviation and industry, each with its own data shapes and its own pace of change. Its apps moved from Firebase and PostgreSQL to SurrealDB with their data structure preserved.
Challenge
Yaacomm's customers span healthcare, aviation and industry, and each sector pulled the architecture in a different direction. On PostgreSQL, a fixed schema had to be agreed and migrated before any of them could have what they needed.
Relational queries grew complex as the apps grew, with performance spikes and queries that were hard to maintain. Every schema change became a bottleneck in development and deployment.
The team wanted to iterate at the speed each customer asked for, and the rigid schema was what stood in the way.
Solution
Yaacomm migrated to SurrealDB and moved its data on to schemaless tables, so each industry's app can evolve its data shape without a migration first. The move from Firebase and PostgreSQL preserved the existing data structure.
Relationships are modelled as edge tables, which made the relational queries that had spiked both simpler and faster. Viewer and editor roles in SurrealDB Studio give the team built-in access control that protects data integrity.
Results
Faster iteration
Schemaless modelling removed the development bottlenecks the fixed schema had created.
Simpler queries
Better performance with less relational overhead.
Sharper audience targeting
Relations are easy to track and analyse for precise targeting.
Ready for full-text search
The platform is prepared for full-text search across content-rich apps.
