SKT
Projects
Not much to show but the churn for now.
Acca Dacca
A comprehensive music sync platform featuring playlist management, streaming history analysis, and album and artist analytics like discography progress report.
☑️ Implemented Features:
- •Local-first client app with more control to user's data
- •Full Spotify OAuth integration with token refresh
- •Offline-first architecture using IndexedDB
- •Advanced track metadata and play dates tracking
- •Create and manage Spotify playlists with batch operations
- •Upload and analyze streaming history files (JSON)
- •Real-time sync progress with detailed analytics
- •Recently played tracks with library integration
- •Bulk data processing and deduplication
- •Responsive design with dark/light theme support
⚠️Work in ProgressExperimental
- 🚧Event-driven updates to local IndexedDB maps for real-time data consistency
- 🚧Researching Convex and ElectricSQL for better playlitst caching and diffs
🔮 Future Optimizations:
- •Background job system for automatic Spotify recent tracks sync
- •Remote syncing between different user logins with conflict resolution
- •Less Dependence on server calls
- •Multi-login data synchronization without cloud storage dependency
Next.jsTypeScriptLocal-First ArchitecturetRPCIndexedDBSpotify APITailwind CSS
About Me
Data Engineering is what lured me into web development which is why i choose an analytics application that transform raw data into meaningful insights as my first project.
This has led me to gain real knowledge at integrating multiple data sources, optimizing database performance, and building real-time synchronization systems.
All the backend code and API layer i wrote on my own, but used AI to help me with the fragmented IndexedDb apis and react memoization hooks.
Beyond Code
When I'm not coding, I listen toalternative rock musicCurrent obsession:Fiction by The xxwatch Anime - currently watching Dr. Stone 🧪
and sometimesplayVirtua Tennis World Touron myPSP