Company
Date Published
Author
Stacey Christian, Cheng Chen, William Zhang
Word count
1417
Language
English
Hacker News points
None

Summary

SingleStore provides external user-defined and table-valued functions to call out to arbitrary remote services from inside SingleStore queries, enabling businesses to leverage large third-party code bases written in any programming language. The system allows developers to embed the functionality of a service like Amazon Translate into their database applications by creating a UDF that references an HTTP connection link, which securely authenticates requests to the remote service and passes credentials or settings through the HTTP header area. This setup is achieved in three easy steps: setting up an AWS Lambda function using the AWS API Gateway, defining the external function in SingleStore, and running standard SQL queries using the external function. By enabling external functions, businesses can tap into a wide range of remote services, including machine learning libraries, without having to rewrite their code or embed the service directly within the database.