Problem: Currently, when querying Supabase tables containing hundreds of rows using Flutterflow's native Supabase query functionality, the app fetches all rows simultaneously. This results in severe performance issues, including app crashes.
Data Table Limitations: While the Data Table widget exists, it also retrieves all rows from the Supabase table in one go, which negatively impacts performance and does not address the need for efficient data handling.
Current Workarounds:
REST API Approach:
This method works by incorporating offset and limit variables to control the data fetched.
Drawback: It does not integrate with Flutterflow's built-in Supabase row types, limiting its utility.
Custom Action Approach:
By creating a Custom Action, users can modify Supabase queries to work with Flutterflow's native Supabase row types.
Advantage: This is currently the better option for maintaining compatibility with Flutterflow's existing features.
Request:
Would you consider adding a built-in Supabase pagination feature in Flutterflow? This feature should allow users to paginate Supabase queries effectively, ensuring better performance while maintaining compatibility with Flutterflow's native Supabase row types.
This functionality would be highly beneficial for managing large datasets and enhancing app performance.