Beyond CRUD: Leveraging Advanced SQL for Backend Optimization

This presentation highlights a backend engineer's journey in optimizing financial data analysis by advancing from basic CRUD operations to sophisticated SQL features. Faced with the challenge of slow API responses due to extensive database interactions, a novel approach was adopted—transferring computational processes directly into the database. This shift not only streamlined data retrieval through single SQL queries but also enhanced performance by exploiting SQL's advanced functionalities like Materialized Views, CTEs, and Window Functions. The initiative not only significantly reduced API response times but also minimized development and maintenance overhead, demonstrating the power of advanced SQL in backend optimization and the importance of embracing database capabilities for system efficiency.

講者

葉家郡

Jia-Jun Yeh, a seasoned principal software engineer specializing in FinTech, blends deep computer science knowledge with expertise in C++ and Go. He has evolved into a skilled Kubernetes administrator and application developer, demonstrating exceptional adaptability and swift learning. Over the past few years, Jia-Jun has confidently embraced a significant leadership role, steering his team towards innovation and collective achievement with decisive direction.

講者

Raiven Kao

一名專注於 Golang 的後端工程師，熱衷於探索與應用最新技術來提升開發效率和系統性能。擅長 Golang，撰寫了多篇技術文章，涵蓋隱式記憶體別名、樂觀鎖與悲觀鎖的應用以及 HTTP 路由改進等。在後端開發中經常使用 Kubernetes，也將許多服務跑在自架的 Homelab 中。在 Golang 和後端開發領域具備扎實技術能力和豐富項目經驗，期待在 COSCUP 2024 與更多開發者交流。