My team is an enterprise customer. I currently use infinite scrollling on an AgGrid as our data could be massive (>20M rows). We would like to use server-side functions e.g. pivoting and aggregations using server-side data. However, our tech stack is python + postgres. I can see a lot of front-end implementations for such functions using Vue,Angular etc but cannot see any python + postgres implementation. I am wondering if you can help me convert my AgGrid with infinite scrolling to a server-side version so I can use aggregations and pivots. Many thanks.
You should be able to get help from your Plotly Services rep on this.
I havent messed with things like aggregations and pivots, but the flow should still be the same.
AG Grid loads up, sends a request to the datasource, and then gets the response.
Here is documentation for it in JS:
These flows will be similar to how it works in JS, basically you need to parse the request from AG Grid and adjust your SQL query and then give back the desired result.
Here is an example of the request flow and then Python picks up the mantle:
