SQL Datastore
Store and Retrieve data from a SQL datastore
The SQL Datastore capability provides WASM function developers the ability to store and retrieve data from SQL datastores. At the moment, Tarmac supports multiple SQL stores which can be enabled/disabled in the host configuration settings.
The Query function provides users with the ability to execute custom SQL queries against the database service. The returned data is in JSON format and base64 encoded to avoid format conflicts.
Interface Details
Namespace
Capability
Function
Input
Output
This callback uses JSON messages as input and output to facilitate communications between WASM functions and the Tarmac host.
To avoid format and data conflicts the query itself must be base64 encoded.
SQLQueryResponse
To avoid format and data conflicts the data returned is base64 encoded.
The Status structure within the response JSON denotes the success of the database call. The status code value follows the HTTP status code standards, with anything higher than 399 is an error.