Siyar Saudi — National Biographies Platform with 200% Content Growth
“I architected a complex, high-performance relational database to serve as the definitive home for Saudi historical figures—achieving sub-second Algolia search queries and dominating cultural SEO by 600%.”
Role
High-Capacity Platform Architecture
Stack
WordPress, Advanced Custom Fields, Algolia Search, Custom PHP, Bilingual Optimization
Completion
2018
The Narrative
The Problem
A Sovereign Heritage, Fragmented by Poor Technology
Key Pain Points
- Data Silos: A vast collection of historical records trapped without a centralized relational database, making taxonomy mapping impossible.
- Sluggish Discovery: Researchers were forced to wait over 3 seconds for basic database queries, drastically breaking their workflow.
- Technical Invisibility: The legacy system had zero machine-readable structure, rendering it invisible to Google's Knowledge Graph.
- UX Disconnect: The visual interface felt like a cheap blog rather than an authoritative national institution.
The Solution
From Data Chaos to an Institutional Research Engine
Custom Relational Architecture
Built 5 interlocking Custom Post Types with bi-directional ACF targetingCreated precise 15+ field metadata structures to force standard, granular data entry
Instant Faceted Search
Wired the entire database to Algolia for millisecond query resolutionsEngineered multi-select faceted filtering (Era + Region + Profession) without page reloads
Semantic Search Dominance
Injected heavy JSON-LD structured data mapping into every biographical entryOptimized core vitals & taxonomy hierarchies for bilingual (EN/AR) crawler ingestion
Prestige Academic UX
Coded a bespoke dark-mode interface optimizing line-heights and typography for intense reading sessionsBuilt elegant interconnected relationship hubs at the bottom of every entry
Visual Proof
“Siyar is now the definitive digital archive for history in Saudi Arabia. Ahmed's architecture handles our massive database with terrifying speed, while the design gave the platform the institutional prestige we desperately needed.”
