dasini.net – Diary of a MySQL expert

Discover how to build an AI-powered search engine for your applications using HeatWave GenAI. This approach leverages large language models (LLMs) for semantic search, offering a smarter alternative to traditional SQL and full-text search methods. By using embeddings—vector representations of words—the search engine understands context and intent, delivering more relevant results.

In this article, I’ll guide you through building an AI-powered search for a WordPress blog using HeatWave GenAI, focusing on its in-database LLMs and vector store capabilities. We’ll create embeddings for post titles and excerpts to enable semantic search, ensuring users find the most relevant content quickly.

In the previous episode we’ve seen how to use an OCI Bastion session in order to provide a restricted and time-limited access to administer our MySQL instance.
One more step to our Discovering MySQL Database Service journey.

In this episode, we’ll learn how to connect to our MySQL Database Service instance using the fantastic MySQL Shell – an interactive Javascript, Python, or SQL interface supporting development and administration for the MySQL Server.