BestHub
Sign in
Aikesheng Open Source Community
Author

Aikesheng Open Source Community

The Aikesheng Open Source Community provides stable, enterprise‑grade MySQL open‑source tools and services, releases a premium open‑source component each year (1024), and continuously operates and maintains them.

1.4k
Articles
0
Likes
3.5k
Views
1
Comments
Recent Articles

Latest from Aikesheng Open Source Community

100 recent articles max
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 17, 2025 · Databases

How SQLFlash Stands Up to the SCALE Benchmark: Deep Dive into AI‑Powered SQL Optimization

This report evaluates the AI‑driven SQLFlash tool against the upgraded SCALE benchmark dataset, presenting core metrics on syntax compliance, logical equivalence, and optimization depth, and analyzes strengths, limitations, and future improvement directions for production‑grade SQL tuning.

AI ModelsDatabase PerformanceLLM evaluation
0 likes · 10 min read
How SQLFlash Stands Up to the SCALE Benchmark: Deep Dive into AI‑Powered SQL Optimization
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 16, 2025 · Databases

How to Build Predictive and Generative AI Apps with MySQL AI

MySQL AI adds built‑in LLMs, embeddings, vector storage, AutoML and a graphical console to on‑premise MySQL, enabling developers to create predictive and generative AI applications—including fraud detection, semantic search, RAG and NL2SQL—without external vector databases or GPUs.

AutoMLGenerative AIMySQL AI
0 likes · 15 min read
How to Build Predictive and Generative AI Apps with MySQL AI
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 10, 2025 · Databases

Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It

A production migration from Oracle to OceanBase caused a column‑length change to trigger offline DDL, leading to connection errors, INSERT latency spikes, and complete table blockage; the article reproduces the fault, analyzes the OMS conversion and OceanBase DDL rules, and provides a two‑step remediation and a method to verify online DDL execution.

DDLDatabase MigrationOceanBase
0 likes · 11 min read
Why OceanBase DDL Expansion Can Crash Your Service and How to Fix It
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 9, 2025 · Frontend Development

How I Built an AI-Powered OceanBase Parameter Comparison Web App in Under an Hour

The author describes using an AI code‑assistant to quickly create a web page that lists all released OceanBase versions, extracts their default parameter files from the source code, and highlights differences between selected versions, all without writing any manual code and deploying it on GitHub Pages.

GitHub PagesOceanBaseParameter Comparison
0 likes · 5 min read
How I Built an AI-Powered OceanBase Parameter Comparison Web App in Under an Hour
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 7, 2025 · Information Security

How to Secure AI Vector Embeddings in MySQL: Risks and Best Practices

AI applications rely on vector embeddings for search and recommendation, but these rich vectors expose new security and privacy threats; this article explains the main risks, attack methods, and mature MySQL strategies—including secure storage, access control, encryption, auditing, and compliance—to protect vector data.

AI securityMySQLaccess control
0 likes · 12 min read
How to Secure AI Vector Embeddings in MySQL: Risks and Best Practices
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 4, 2025 · Artificial Intelligence

Gemini 3 Pro vs DeepSeek‑V3.2‑Exp: Which LLM Dominates SQL Understanding, Optimization, and Dialect Conversion?

This report evaluates the professional‑grade LLMs Gemini 3 Pro and DeepSeek‑V3.2‑Exp on three SQL‑related dimensions—understanding, optimization, and dialect conversion—using the SCALE benchmark, presenting detailed scores, strengths, weaknesses, and practical recommendations for database engineers and decision makers.

DeepSeekGeminiLLM
0 likes · 16 min read
Gemini 3 Pro vs DeepSeek‑V3.2‑Exp: Which LLM Dominates SQL Understanding, Optimization, and Dialect Conversion?
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 26, 2025 · Databases

Why INSERT…SELECT Slows Down on OceanBase and How to Fix It

During an Oracle‑to‑OceanBase migration, a client encountered extremely slow INSERT…SELECT batch jobs due to a global unique non‑partitioned index, and the article walks through extracting logical and physical plans, pinpointing the bottleneck operators, and demonstrates converting the index to a partitioned one to cut execution time from over 30 minutes to 14 minutes.

INSERT SELECTIndex TuningOceanBase
0 likes · 16 min read
Why INSERT…SELECT Slows Down on OceanBase and How to Fix It