Jhonatan Arenas 🎨
Explore a curated selection of my projects and case studies that showcase my ability to turn ideas into impactful digital products.
Client For:
Internal Project
Services:
API Design, Data Modeling, Query Optimization, Auth Integration
https://www.canticlesapp.comOverview
NestJS REST API powering the Canticles mobile app, delivering hymnal data with advanced search and filtering. Implements optimized text search, pagination, and multi level filtering across nested MongoDB collections, and integrates self hosted Appwrite authentication to validate sessions and restrict access to authorized users.
Challenges
Balancing rich text queries with low latency, access control, and data consistency.
Text Search & Filtering
- Challenge: Fast queries by title, number, author, and lyrics.
- Solution: Compound and text indexes in MongoDB, selective projections, and cursor based pagination where appropriate.
Appwrite Integration
- Challenge: Validating self hosted sessions without adding noticeable latency.
- Solution: Auth middleware validating Appwrite JWTs with short lived cache of session metadata.
Scalable Data Shape
- Challenge: Multi level filtering across nested collections while keeping the domain model clear.
- Solution: Well structured aggregation pipelines, strict DTOs, and bounded page/limit parameters to protect the backend.
Results/Conclusion:
Consistent, fast endpoints under moderate load, with clear access controls and a smooth search experience in the mobile app.
