Home / Companies / SingleStore / Blog / Post Details
Content Deep Dive

Using Vector Functions for Image Matching in SQL with SingleStoreDB

Blog post from SingleStore

Post Details
Company
Date Published
Author
Pranav Aurora
Word Count
647
Language
English
Hacker News Points
-
Summary

SingleStoreDB allows developers to solve AI problems, including face matching and product photo matching. The example demonstrates how to use the dot_product function to find a matching image from 7000 records in just three milliseconds. To do this, users need to sign up for a free trial account, create a workspace and database, import necessary libraries into a Python kernel or Jupyter notebook, create a connection string, create a table named "people" in the database, import a sample dataset, run an image matching algorithm using two lines of SQL, and optionally use a visualizer to see the results. The example uses Adam Sandler as a test subject and follows instructions from SingleStoreLab's github repository for more information.