This topic was automatically generated from Slack. You can find the original thread here.
Is it possible to perform a query on a datastore? In particular I need to retrieve not all the key/entries, but just the most recent ones (e.g. the last 5 in terms of datetime creation). Is it possible to achieve this result?
Hi , Pipedream data store is a simple key-value store, it only offer simple query for key, so it doesn’t offer the operation for your usecase out-of-the-box.
For you usecase, I think you will need to fetch all the keys & values in the datastore, then using Node.js/Python code to query
I read that there is a 1024 limit on the number of stored key-value pairs. Is there a limit on the size of each entry?
I couldn’t find any specific information on the size limit of each key-value pair in the datastore. However, if you need more clarification or have concerns about the limits, I recommend reaching out to Pipedream support at https://pipedream.com/support for more assistance.
Hi , I think the value size limit is not documented. Though I would suggest that you keep it at a reasonable number, or it might make your workflow eats up credit faster
Was thinking of keeping just one key-value, and use the value to store an array of my custom items. So I can loop/query/delete the items according to my application logic. But it would be nice to know if there is a size limit on each key-value datastore pair 
, Pipedream has a datastore get all records action so you don’t need to use just one key. Use just one key might make it inefficient for you if you want to get one particular key
thanks for the suggestion!