Filtering API: REST APIs with Some of GraphQL's Conveniences

on YouTube ↗39m

" summary

Shows how to add a query-string DSL to REST endpoints so clients can filter (eq, like, <, <=, >, >=, between), sort, paginate (limit/offset) and select fields without changing controllers. Presents a custom single-method PHP class that parses those operators and returns JSON, and also demonstrates using Spatie Query Builder with Eloquent for the same configurable, extensible behavior while noting the need for validation and careful placement to avoid surprising query semantics.

AI-written summary · about

" chapters (14)

1. 0:00Introduction
2. 3:18Talk context
3. 4:47REST filtering problems
4. 6:35Laravel Query Builder demo
5. 10:59Custom filtering class
6. 13:58Testing custom class
7. 18:31Eloquent Query Builder integration
8. 20:21Eloquent models and filters demo
9. 26:08Spatie Query Builder advanced ops
10. 29:35Configuration troubleshooting
11. 31:27Q&A: Multi-sort
12. 34:57Q&A: GraphQL similarities
13. 36:47Q&A: Model vs controller logic
14. 38:00Summary

" related talks

• 42mPerformant APIs with GraphQL and PHPAndrew Rota · Dutch PHP Conference 2019
• 50mGraphQL is right in front of us, let's do it, with SymfonyRenato Mendes Figueirdo · Dutch PHP Conference 2017
• 33mGraphQL Will Do To REST What JSON Did To XMLRoy Derks · NDC London 2019
• 46mIntroduction to GraphQLMichael Cullum · PHP UK Conference 2018
• 32mTradeoffs between leveraging FHIR REST APIs vs. GraphQL APIsSonya Huang · DevDays 2023
• 41mBuilding first-class REST APIs with SymfonyMichael Cullum · SymfonyLive London 2018
• 53mGraphQL: Improvements You Can Make TodayAnastasiya Lysenko · PHP fwdays'20 online
• 58mGraphQL -- Flexible APIs for Adaptive ClientsBrian Genisio · CodeMash 2018