Hi Airtable Community,
I'm building an Airtable-like application using React.js, Redux, Node.js, and MySQL. In my app, all records (raw data) are sent to the frontend, and I need to handle filtering, sorting, and grouping entirely on the client-side, without making API calls.
I want to ensure efficient data handling and real-time UI updates while maintaining good performance, especially for large datasets.
Some Considerations:
- How does Airtable handle large datasets on the frontend efficiently?
- Should I use IndexedDB, Web Workers, or in-memory filtering for better performance?
- How can I implement real-time UI updates when filtering/sorting large data in React.js?
- Are there any caching mechanisms (e.g., Apollo Client, Local Storage) that help optimize filtering/sorting?
- Any experience with virtualization (e.g., React Virtualized) for large lists to improve rendering speed?
- Would Redux be a good option for managing local state filtering and sorting?
If you have any references, articles, or documentation related to this, please share them with me. I'd love to learn more about best practices for handling large datasets efficiently in Airtable or similar apps.
Thanks in advance for your insights! 🚀
