Tuning PosgreSQL/Wappler query performance

[Apple]

I believe the easiest way to speed up execution available at this time is to use something like NocoDB and its update API

Meaning you build a new array of "members" (your variable name) with your modified data and do an API Action to your NocoDB to bulk update:

https://docs.nocodb.com/developer-resources/rest-apis/#data-apis

Has the downside of needing to add a third-party software to the stack, so you're no longer solely using Wappler - more loose parts, more chance of breaking stuff

Here, one more feature request:

Database Insert/Update/Delete from JSON

Please consider a database query "users": [ { "id": 1, "name": "George", "country": "NL" }, { "id": 2, "name": "Teodor", "country": "BG" } ] That's a JSON representation of our rows. Through a series of steps, I modify the names: [ { "id": 1, "name": "George P.", "country": "NL" }, { "id": 2, "name": "Teodor T.", "country": "BG" } ] Now, I want to UPDATE the databas…

You can start betting which one is going to be picked first