🗄

Database

MySQL、PostgreSQL、MongoDB、Redis 等数据库查询参考与工具

51 tools

数据库是应用的数据基础。本分类提供 MySQL、PostgreSQL、SQLite、MongoDB、Redis、Elasticsearch、Cassandra 等数据库的 SQL/查询语法速查、索引优化指南、数据建模参考、备份策略和 ORM（Sequelize、TypeORM、Prisma）使用参考。

🗄

MySQL Query Builder

MySQL SELECT/JOIN/GROUP BY guide 🗄

MySQL Index Guide

MySQL index types & optimization 🗄

Transaction Guide

MySQL transaction isolation levels 🗄

Stored Procedures

MySQL stored procedure syntax 🗄

MySQL Optimization

MySQL query & config optimization 🐘

Window Functions

PostgreSQL window functions guide 🐘

JSONB Guide

PostgreSQL JSONB operations guide 🐘

Full-Text Search

PostgreSQL full-text search guide 🐘

Extensions Reference

PostgreSQL common extensions 🐘

Table Partitioning

PostgreSQL table partitioning 🍃

Aggregation Pipeline

MongoDB aggregation operators 🍃

Index Strategies

MongoDB index types & selection 🍃

Schema Patterns

MongoDB schema design patterns 🍃

MongoDB Transactions

MongoDB multi-doc transactions 🔴

Data Structures Reference

Redis five data structure commands 🔴

Pub/Sub Guide

Redis publish/subscribe patterns 🔴

Redis Lua Scripts

Redis Lua scripting guide 🔴

Sentinel Guide

Redis Sentinel HA config guide 📄

SQLite Commands

SQLite CLI commands cheatsheet 📄

SQLite JSON Support

SQLite JSON functions reference 🔍

Query DSL Reference

ES Query DSL search reference 🔍

Aggregation Reference

ES aggregation query reference 📈

Flux Query Reference

InfluxDB Flux query reference 📈

Line Protocol Reference

InfluxDB Line Protocol format 👁

CQL Reference

Cassandra CQL query reference 👁

Data Modeling Guide

Cassandra data modeling guide 🔗

Cypher Guide

Neo4j Cypher query language guide 🔗

Graph Patterns

Neo4j graph database patterns 💎

Prisma Schema Guide

Prisma schema.prisma syntax guide 💎

Prisma Migrations

Prisma DB migration commands 📘

TypeORM Entities

TypeORM Entity decorators guide 📘

TypeORM Migrations

TypeORM migration commands & API 🟢

Sequelize Models

Sequelize model definition guide 🟢

Sequelize Associations

Sequelize model associations 🟡

Drizzle ORM Reference

Drizzle ORM schema & query guide NEW 🗄

MySQL Performance Guide

MySQL slow query & index tuning 🐬

MySQL完全指南

51个深度专题从入门到架构师级别 HOT NEW 🐘

PostgreSQL Advanced

Window functions, JSONB, FTS 🍃

MongoDB Aggregation Guide

Aggregation pipeline optimization 🔴

Redis Patterns Guide

Cache, session, queue patterns 🔍

Elasticsearch Query Guide

Search, filter & aggregation guide 📐

Database Design Guide

Normalization & ER diagram guide 🗃

SQL Window Functions

OVER/PARTITION BY/RANK functions 📑

Database Indexing Guide

B-tree, hash, composite index tips 📊

NoSQL Comparison

MongoDB/Redis/Cassandra comparison 🔄

DB Migration Guide

Migration strategy & rollback guide 🗄

SQLite Guide

SQLite lightweight DB operations 🗄

Cassandra Guide

Cassandra data model & CQL guide 🕸

Neo4j Guide

Neo4j Cypher query language guide 📊

ClickHouse Guide

ClickHouse columnar storage guide 💾

Database Backup Guide

MySQL/PostgreSQL backup & restore