We use the azure blob store for our project and save the JSON string in the blob container. For some purpose, we parse this JSON string to break it into rows and columns, and then show it in the Grid control in the user interface. Grid management offers features such as filtering, grouping, etc. On the client side. However, when the data is huge, such operations take time, so the user interface becomes unresponsive. So, now we want to perform such operations on the server so that the grid loads with the corresponding data from the server faster, and not all the rows.
To do this, we believe that we need to request JSON data for filtering, grouping, swapping, etc., but are not sure that such functions are stored in block storage or any other cloud storage (DocumentDB). We have the opportunity to go with PostgreSQL, but we would like to stick to the cloud infrastructure in the first place.
Any ideas on how to request JSON data while on AZURE and use azure storage (not Azure SQL, but table storage, block storage, etc. less expensive)
source
share