1 views collected around this technical thread.
The article examines SQL's recent drop to 12th place in the TIOBE June 2025 ranking, recounts its historical highs and removal from the list, highlights its pervasive use in everyday systems, and discusses how the rise of AI and NoSQL databases may reshape its future role.
An interview-style SQL challenge asks you to identify records where a professor teaches a course belonging to a different college than their own, providing table definitions, sample data, and the expected result, while inviting readers to devise the correct query.
This article explains MySQL's four transaction isolation levels—READ UNCOMMITTED, READ COMMITTED, REPEATABLE READ, and SERIALIZABLE—through step‑by‑step examples, demonstrating their effects on dirty reads, non‑repeatable reads, phantom reads, and performance considerations, helping developers choose the appropriate level.
This article explains how MySQL's InnoDB engine implements full‑text search using inverted indexes, shows how to create and use full‑text indexes with various query modes, demonstrates Boolean operators and query expansion, and covers index removal techniques.
This article presents a series of MySQL interview questions and answers that illustrate typical situations where indexes become ineffective—such as leading wildcards in LIKE, NOT IN, NOT EXISTS, functions, inequality operators, OR conditions, mismatched ORDER BY, large result sets, and explains how to analyze execution plans and use FORCE INDEX to improve performance.
DuckDB's DuckLake is an open‑standard, SQL‑driven data lake and catalog format that simplifies lakehouse architecture by managing metadata in a database while storing data in scalable Parquet files, offering multi‑user collaboration, time‑travel queries, and MIT licensing.
This guide outlines a step‑by‑step method to diagnose and release MySQL table locks by checking open tables, inspecting running processes, querying InnoDB transaction and lock tables, and generating KILL statements to terminate blocking sessions.
This article explains the evolution of data storage, the fundamentals of computer storage devices, and how database indexes—especially clustered and non‑clustered indexes—leverage binary search to dramatically speed up query performance while outlining their drawbacks and common SQL optimization techniques.
This article provides a comprehensive walkthrough of JDBC for MySQL, covering driver loading, connection creation, statement and prepared statement objects, SQL execution with examples, batch processing, and performance considerations for test engineers using Java.
This article provides a comprehensive overview of database transactions, explaining ACID properties, transaction states, explicit and implicit transaction control, isolation levels, and how to configure and use them in MySQL with practical SQL examples and code snippets.
The article explains why using a VARCHAR(20) column to store billions of phone numbers is safer and more flexible than INT or BIGINT, covering range limits, data integrity, query convenience, interview expectations, and common pitfalls such as insufficient field length, charset issues, missing indexes, and lack of encryption.
This article details the design and implementation of an AI‑driven Intelligent SQL Assistant that automates query parsing, index recommendation, execution‑plan visualization, and supports SQL generation, diagnosis, and explanation across multiple dialects, while outlining its layered architecture, core modules, code examples, and future enhancements.
This article explains the concept of SaaS multi‑tenant architecture, compares three data‑isolation designs, and demonstrates how to implement elegant tenant‑level data isolation in Java using MyBatis‑Plus’s tenant plugin, complete with configuration, handler code, SQL examples, and troubleshooting tips.
This tutorial explains how to build logistics tracking and delivery management features for an e‑commerce platform using PHP, covering database table creation, inserting, updating, and querying of tracking and delivery records with complete code examples.
This tutorial walks through adding Dataway to a Spring Boot project, covering Maven dependencies, configuration properties, required database tables, data‑source setup, Hasor module integration, enabling Hasor, launching the application, and creating and testing APIs using both SQL and DataQL without writing any service code.
The article outlines why deleting tens of millions of rows in one statement harms performance and reliability, then presents safe, efficient tactics—such as indexed batch deletes, partition drops, creating a new table, or using TRUNCATE—plus pre‑deletion planning, post‑delete validation, monitoring, and space reclamation.
This article presents ten practical SQL optimization techniques—including replacing DISTINCT with GROUP BY, using UNION ALL instead of OR, avoiding functions on indexed columns, leveraging EXISTS over IN, creating covering indexes, partitioning large tables, and more—each illustrated with before-and-after code examples to dramatically improve query speed and reduce server load.
The author compares IntelliJ IDEA's built‑in database tool with Navicat for running massive SQL dump files, showing that IDEA consistently achieves higher execution speed, lower CPU usage, and no freezes even on multi‑gigabyte scripts, contrary to common expectations.
This tutorial explains how to set up and use the easy-data-scope library in a Spring Boot project to implement dynamic SQL data‑permission rules with MyBatis, covering database preparation, Maven dependencies, core annotations, configuration files, and example queries for various permission scenarios.
This tutorial demonstrates how to connect to a MySQL database in PHP using mysqli_connect, execute queries with mysqli_query, and retrieve each row as an associative array using mysqli_fetch_assoc, providing complete code examples and a full script for efficient backend data handling.