In recent months, the number of AI tools released has been increasing. ChatGPT is a powerful tool that is an advanced large language model (LLM) capable of understanding and engaging in human-like text conversations. While ChatGPT has been proven to generate conversational text, it can greatly benefit people across various industries. For data analysts, ChatGPT … Read more
In recent months, the number of AI tools released has been increasing. ChatGPT is a powerful tool, an advanced large language model (LLM) that can understand and engage in human-like text conversations. While ChatGPT has proven capable of generating conversational text, it can greatly benefit people across various industries. For data analysts, ChatGPT can enhance … Read more
Explorations of Large Models in Data Warehouse Applications Starting in the second half of 2024, the application ecosystem of large models has rapidly exploded. The first one that shocked me was Cursor, which achieved a remarkably high accuracy in intent recognition. The second was DeepSeek during the Spring Festival, which showed me the possibilities of … Read more
There are many JDBC connection parameters, and some settings can assist in the application’s processing logic. This article from the technical community, “Original | Analysis of JDBC and MySQL Temporary Table Space“, explains the useCursorFetch parameter and is worth learning from. Background When using the JDBC connection parameter with useCursorFetch=true, the query result set is … Read more
The Principle of Using Python to Operate Databases Python operates the database by calling the corresponding DB API Automation Testing Use Cases When initializing data Performing test assertions When unable to call the interface for data clearing Installing the PyMySQL Library pip install pymysql -i http://pypi.douban.com/simple –trusted-host pypi.douban.com Python Operates MySQL Database Operation Code import … Read more
This article is an original work by Liu Feng from Yunbei Education. Please respect intellectual property rights. When forwarding, please indicate the source. No plagiarism, adaptations, or unauthorized reproduction is allowed. 1. Theory Analysis of Cursors 1.1. Concept and Function of Cursors A cursor is a database programming mechanism used to handle query result sets. … Read more
In this blog, we will delve into how to build an intelligent SQL query assistant using LangChain and LangGraph. This assistant can convert natural language questions into SQL queries, execute the queries, and provide human-friendly answers. More importantly, it supports human-machine collaborative workflows, allowing users to intervene at critical steps. 0. Initialize SQL Data We … Read more
I want to import data from an Excel file into a MySQL database table. First, I converted the Excel file to a CSV file. But for some reason, MySQL Workbench’s Table Data Import Wizard crashes after selecting the CSV file. So I thought, why not use Github Copilot to generate SQL to handle this? It’s … Read more