[Database Edition 08] Understand SQL Execution Plans! Essential Knowledge for Finding the Cause of Slow SQL

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

[Database Edition 02] Why you should learn SQL in the AI era

When people who have just started learning programming or have just entered the IT industry ask me, "What should I study ...
GitHub

mysql-database

MySQL is an open source relational database management system. Based in Structured Query Language (SQL), MySQL can run on most platforms and is mainly used for web-based applications. It is written in ...
blog.csdn

Docker部署MySQL 8.0：数据持久化与容器挂载实战解析

文章浏览阅读7次。容器化技术正在重塑数据库部署方式，而数据持久化是容器化数据库的基石。Docker通过镜像分层与可写层机制实现环境隔离，但容器删除会导致数据丢失，因此必须借助数据卷或绑定挂载将MySQL数据目录映射到宿主机。理解持久化原理后，可显著提升数据库部署的灵活性与可移植性 ...
blog.csdn

Prisma Database Connectors 详解：连接 MySQL 与 PostgreSQL 的多租户与迁移机制

本文深入解析 Prisma（1.x 版本）中 **Database Connectors** 的核心概念与实战配置。Connector 负责将 Prisma server 与一个或多个底层数据库连接起来，是 Prisma API 与数据存储之间的桥梁。读完本文，你将掌握 Prisma server 的两种数据库隔离模式（多租户 / 单租户）、迁移开关（Migrations）的取舍逻辑，并能够基于 ...