Decibel is a full-stack music streaming platform built with .NET 7, Entity Framework Core, and MS SQL Server, featuring a novel backend architecture for playlist management.

Technical Highlights

• Double Circular Linked List implementation:
  • Stored procedures handle O(1) playlist operations (reordering, insertions)
  • Optimized pagination via procedural logic
• Database Performance:
  • 300ms average response for 10k-track playlists
  • 99.8% uptime via SmarterASP deployment
• DevOps Pipeline:
  • CI/CD with Azure DevOps
  • Automated testing (xUnit/NUnit)

Architecture Diagram

Key Innovations

1. Linked List in SQL:

   • Eliminated N+1 queries for playlist navigation
   • Enabled constant-time track adjacency updates

2. Hybrid Data Loading:

   • EF Core projections for minimal data transfer
   • Batched procedural execution

Metrics

• Supported 500+ concurrent users
• 40% faster playlist modifications vs. traditional JOIN approaches

---

Proprietary system developed under NDA. Architectural details available upon request.

---

← Back to projects