Data API

SingleStore provides the Data API to execute SQL statements against your database over an HTTP connection. The Data API can be used to integrate SingleStore with serverless architecture, develop custom applications, and build seamless integrations with applications.

SingleStore's Data API is authenticated to the server using the HTTP Basic and Bearer Authentication standards, which must be used in conjunction with SSL (HTTPS) for secure communication over the network. The Data API uses standard HTTP methods and response codes and supports URI versioning. It also uses JSON-encoded responses with support for conventional data type conversions. The Data API is accessible via a built-in HTTP server. It can be easily enabled or disabled using engine variables.

The Data API supports all SQL statements that can be run in a direct database connection with SingleStoreDB. To learn about the supported Data API endpoints, refer to Data API Endpoint Reference.

The Data API can support concurrent connections up to the value of the http_api_pool_capacity engine variable. If the value of the max_connection_threads engine variable is less than the value of http_api_pool_capacity, then the number of supported concurrent requests is limited to the value of max_connection_threads. In such cases, you can increase the values of both the max_connection_threads and the http_api_pool_capacity engine variables for your cluster. Refer to List of Engine Variables for more information. If the server is already running when you update the configuration, run the following command at the SingleStore command-line for the changes to take effect.

RESTART PROXY;