News
Entertainment
Science & Technology
Life
Culture & Art
Hobbies
News
Entertainment
Science & Technology
Culture & Art
Hobbies
Querying the Unstructured: Natural Language to SQL for JSON Data | dasini.net - Diary of a MySQL expert
In Ask Your Database Anything: Natural Language to SQL (NL2SQL) in MySQL HeatWave, we have explored the innovative MySQL HeatWave GenAI technology that converts Natural Language into SQL, making it easier for you to interact with databases. This feature collects information on the schemas, tables, and columns that you have access to, and then uses
Let Your AI DBA Assistant Write Your MySQL Queries | dasini.net - Diary of a MySQL expert
Having explored the innovative MySQL HeatWave technology that converts Natural Language into SQL (Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave), our next article in this series, dives into a practical use case demonstrating how an AI DBA Assistant can significantly simplify your query generation workflow. The code is available on my
Ask Your Database Anything: Natural Language to SQL in MySQL HeatWave | dasini.net - Diary of a MySQL expert
The ability to query data efficiently has always been central to unlocking insights, but writing SQL can be a barrier for many users who aren’t fluent in the language of databases. Analysts, product managers, and business users often know the questions they want to ask—just not how to express them in SQL. With the rise
Archive Smarter, Query Faster: Unlocking MySQL Performance with HeatWave | dasini.net - Diary of a MySQL expert
Managing large volumes of data is a challenge every organization faces as applications grow. For MySQL users, this often means deciding what to do with historical or less frequently accessed data: keep it in production tables at the cost of performance, or archive it and lose the ability to query it efficiently. Traditionally, archiving has
How do you upgrade MySQL HeatWave when deploying with Terraform? - lefred blog: tribulations of a MySQL Evangelist
Have you already tried to upgrade the MySQL version of your MySQL HeatWave instance in OCI that is deployed with Terraform? When you tried, you realized, I hope you didn't turn off backups, that the instance is destroyed and recreated new! This is our current MySQL HeatWave DB System deployed…
Uplevel the MySQL REST Service - lefred blog: tribulations of a MySQL Evangelist
The MySQL REST Service is a next-generation JSON Document Store solution, enabling fast and secure HTTPS access to data stored in MySQL, HeatWave, InnoDB Cluster, InnoDB ClusterSet, and InnoDB ReplicaSet. The MySQL REST Service was first released on https://labs.mysql.com in 2023 using MySQL Router. During spring 2025, it was released…
HeatWave MySQL Database Audit | dasini.net - Diary of a MySQL expert
A few years ago (in 2018), I wrote a MySQL Security series and one of the episode was about the MySQL Enterprise Audit feature — MySQL Security – MySQL Enterprise Audit — a powerful auditing capability that enables you to track and monitor database activity to ensure data integrity, strengthen security, and maintain compliance with
Handle CSV files with HeatWave MySQL | dasini.net - Diary of a MySQL expert
When it comes to loading data from CSV files into your MySQL environment, there’s no shortage of options. In this post, I’ll walk you through two efficient, developer-friendly and MySQL-ish approaches: the powerful MySQL Shell with its built-in parallel import utility, and the fully automated HeatWave Auto Parallel Load feature. Both can save you time
MySQL Hypergraph Optimizer - lefred blog: tribulations of a MySQL Evangelist
During the last MySQL & HeatWave Summit, Wim Coekaerts announced that a new optimizer is available and is already enabled in MySQL HeatWave. Let's have a quick look at it and how to use it. The first step is to verify that Hypergraph is available: MySQL > SET SESSION optimizer_switch='hypergraph_optimizer=on';…