I am trying to implement agentic behavior in Rust. Now I have figured out communication with the LLMs etc. Now I want some excel spreadsheet to be queried. So how do I work with actual spreadsheet? I can’t access the file from with the canister since I am in WASM land so do I find a way to use Stable memory and persist it in the canister and then work with it?
What if I needed to query an external database system? These capabilities would require some host native methods? Do we have them in the ICP or do we plan to support them? In short, what are my options here.
For external database, you can use http outcalls. Dunno about connecting to DB service via port number, I believe that is by design for security. Even then… ignoring blockchain/ICP altogether, better to expose endpoint. Expose rest endpoint to access database:
Some resources:
For your DB, I would probably use Juno… get quick prototype working, and then you can remove Juno dependency and use your own thing for giggles… or just keep using Juno whatever u prefer.