Deploying split-str Using pushwasm

The pushwasm tool will upload our WIT file and compiled Wasm module into the database. To use it, we'll need the following information. Since this depends highly on your specific environment, we'll just make some generic assumptions about their values.

• The hostname of the SingleStoreDB server (we'll call this myserver)
• The destination database name (we'll call this wasm_tutorial)
• The user ID and password of the database user (we'll call this user admin)
• The path to the compiled Wasm module (we'll use ./power.wasm below, but for the Rust example, you should use located in target/wasm32-wasi/debug/power.wasm instead)
• The path to the WIT file

Now, run the following command from within your work directory. Unlike the power-of example, we'll deploy the split-str function as a Table-Valued Function (TVF). This will require us to pass the --tvf flag.

pushwasm --tvf --prompt --wit ./split.wit mysql://admin@myserver/wasm_tutorial ./split.wasm split_str

The --prompt option will cause a prompt to appear, where you can enter your database user's password.

When the deployment has completed, you should see the following:

Wasm TVF 'split_str' was created successfully.

Finally, we're ready to run the TVF!