Question:
I just started using Wix and would like some help implementing some functionabilities in it. I want to be able to fetch some data from a url, process it, then save it for later use.
Product:
Wix Editor
What are you trying to achieve:
If this was a self-hosted Node.JS server, I would put a fetch function on start (and on a timer), process the data normally and save it inside a file inside my backend (like sqlite3, for example). This would be used in API calls as requested by the frontend.
What have you already tried:
I can fetch the data fine, but saving it with Node.fs gives me the “this is a read only” error, as expected.
I read around Velo’s documentation, and it one way to do it would be saving to CMS, but, while the data itself isn’t heavy (it’s sitting at 8mb in my pc), the number of entries is (14k+).
I also noticed there’s the possibility to integrate an external database, but it would be nice to find an option that doesn’t require additional costs.
Additional information:
Another option seems to be using Google Sheets, since the number of requests should be within the sheets quota for now.
It’s also important to know that this processing takes a few minutes (like 5~10 in my machine), so fetching it and processing at each requests doesn’t seem like a good alternative.