The meeting participants, And and Camier, discussed the use of add-ons and inner joins in their project. And shared their screen to demonstrate the queries and tables they were working with. And explained that they had been trying to query multiple tables with inner joins but were encountering issues related to the size of the data they were trying to retrieve. They also mentioned using add-ons to simplify their queries, but were unsure if they were using them correctly.
Camier advised starting with simpler queries using "for each" loops and then optimizing for efficiency if needed. They also mentioned that joins are typically used for reading data and filtering, but may not be necessary in this case. Camier recommended focusing on the specific needs of each screen and creating endpoints accordingly. They also suggested using add-ons before diving into inner joins as they may be easier to work with. And also raised a specific issue they were facing with a parse error in their query. Camier explained that the error occurred due to using a list in an equality comparison with a string and suggested using "in" instead of "=". They emphasized the importance of testing and understanding the output of queries to determine if they are working correctly. And requested further clarification on add-ons, specifically regarding external queries. Camier explained that external queries are JSON-encoded objects that can be used to set preferences for filtering, sorting, and paging. They mentioned that external queries are an advanced feature and may not be necessary for And's current project. Overall, the meeting focused on best practices for using add-ons and inner joins, troubleshooting specific issues, and optimizing queries for efficiency. And expressed their willingness to follow Camier's advice and improve their understanding of these concepts.
(Source: Office Hours 8/23 )
