How Identical Are 'Identical Characters' in Japanese? Measuring MySQL and PostgreSQL Collations and Full-Width Character Handling to Create a Duplicate Insp…

When applying UNIQUE constraints to Japanese names or addresses, or matching them via JOIN, the database collation determines ...

Backups must be restored and verified—I measured the conditions under which SQLite, PostgreSQL, and MySQL fail to restore and created a verification script

When judging whether a backup can be restored based solely on exit codes and integrity checks, I found conditions in SQLite, ...

Control Databases with Java, AI and MCP: Google’s MCP Toolbox

Java developers can use Google’s toolbox to address their databases via AI using MCP – currently with limitations.
blog.csdn

MySQL 中列出数据库与数据表：SHOW DATABASES 与 SHOW TABLES 实战指南

在 MySQL 客户端会话中快速摸清一个实例里有哪些数据库、某个库里有哪些表，是日常排查与开发联调的高频操作。本篇以 til 仓库的 list-databases-and-tables.md为核心，系统讲解 SHOW DATABASES、SHOW TABLES ...