dasini.net – Diary of a MySQL expert

Bridging natural language processing with semi-structured data brings both opportunity and complexity.

MySQL HeatWave GenAI’s NL2SQL feature shows how natural language can simplify data interaction — even for JSON documents. Yet, because JSON embeds both data and metadata within a single column, LLMs may struggle without explicit schema cues.

By creating well-structured views that reveal JSON’s internal organization, you can transform unstructured data into a relational format the model understands — improving both query accuracy and overall usability.

This approach highlights how MySQL HeatWave continues to evolve as a powerful engine for intelligent, natural language–driven analytics.

As databases grow, DBAs and developers often face a tough choice:
+ Keep historical data in production tables and risk slow queries
+ Archive it and lose fast access

With HeatWave, you don’t have to choose. You can archive old partitions, keep recent data in production, and still run lightning-fast queries across all your data.

HeatWave MySQL Database Audit brings powerful enterprise-grade auditing capabilities to the cloud, allowing organizations to monitor and track database activity for security, compliance, and performance optimization. With features like customizable filters, real-time monitoring, minimal overhead, and seamless integration with MySQL tools, it enables administrators to log critical operations, detect threats, and maintain detailed records for regulatory requirements. The audit system is easy to set up, supports granular activity tracking, and provides actionable insights directly through the SQL interface.

In this latest post, the final part of my series on building an AI-powered search engine with HeatWave GenAI, I dive into enhancing AI-powered search by embedding full article content into HeatWave.

By cleaning HTML, chunking content, generating embeddings, and running semantic similarity searches directly within HeatWave, we unlock highly relevant, context-rich search results.
If you’re building smart search engines or working with RAG pipelines, you’ll find practical tips and SQL-powered techniques you can apply right away.

This series demonstrates the powerful capabilities of HeatWave GenAI for building sophisticated, in-database AI-driven search solutions. Check out the article to level up your understanding of semantic search!

In this part 2 we focused on enhancing search relevance. We introduced reranking techniques using weighted distances of titles and excerpts to refine initial search results. Then we delved into leveraging article summaries for more effective semantic search, utilizing HeatWave’s capability to execute JavaScript stored procedures for sanitizing HTML content and generating these summaries. Finally, we demonstrated how to create embeddings from these summaries and perform similarity searches, showcasing HeatWave GenAI’s power for advanced information retrieval directly within the database.

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.

AI-powered applications require robust and scalable database solutions to manage and process large amounts of data efficiently. HeatWave is an excellent choice for such applications, providing high-performance OLTP, analytics, machine learning and generative artificial intelligence capabilities.

In this article, we will explore a Python 3 script that connects to an HeatWave instance and enables users to interact with different large language models (LLMs) dynamically.

This tutorial explores HeatWave GenAI, a cloud service that simplifies interacting with unstructured data using natural language. It combines large language models, vector stores, and SQL queries to enable tasks like content generation, chatbot, and retrieval-augmented generation (RAG). The focus is on RAG and how HeatWave GenAI’s architecture helps users gain insights from their data.

This new AI tech, called generative AI (or GenAI), can dive deep into what people are saying and tell us if they’re feeling positive, negative, or neutral.
Let’s see how HeatWave GenAI, can help you to enhance your understanding of customer sentiment, improve decision-making, and drive business success.

This article guides you through setting up replication between a HeatWave MySQL instance (source) and an on-premise standalone MySQL instance (replica).
It highlights key steps like creating a replication user, securing the connection, and using MySQL Shell utilities for data transfer.