Hands-On RESTful API Design Patterns and Best Practices
by Harihara Subramanian J, Anupama Murali, Pethuru Raj
Discarding SQL join
A noteworthy tip for better data management is to avoid the SQL join operation. As every database is logically separated in the MSA world, doing SQL join function is very tedious and time-consuming. It's going to be a technical and security nightmare. However, there can be different application requirements. For example, suppose the messaging application mandates for timeline view. That is, the timeline view has to show the most recent message from each friend of the authenticated user. Also, this new view has to show the friend's name and other details along with the message sent.
It's still possible to implement this complicated view using the basic REST API. That is, the client has to employ several API calls to different ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access