560.md

# Database guides

> 原文：[https://docs.gitlab.com/ee/development/database/](https://docs.gitlab.com/ee/development/database/)

*   [Database Reviews](#database-reviews)
*   [Tooling](#tooling)
*   [Migrations](#migrations)
*   [Debugging](#debugging)
*   [Best practices](#best-practices)
*   [Case studies](#case-studies)

# Database guides[](#database-guides "Permalink")

## Database Reviews[](#database-reviews "Permalink")

*   如果您要创建数据库 MR 进行审查，请查看我们的[数据库审查指南](../database_review.html) .

    它介绍了与数据库相关的更改，迁移和复杂的 SQL 查询.

*   如果您是数据库审阅者或想成为一名数据库审阅者，请查看我们的数据库审阅[简介](database_reviewer_guidelines.html) .

## Tooling[](#tooling "Permalink")

*   [Understanding EXPLAIN plans](../understanding_explain_plans.html)
*   [explain.depesz.com](https://explain.depesz.com/)或[explain.dalibo.com，](https://explain.dalibo.com/)用于可视化`EXPLAIN`的输出
*   [pgFormatter](http://sqlformat.darold.net/) PostgreSQL SQL 语法美化器

## Migrations[](#migrations "Permalink")

*   [What requires downtime?](../what_requires_downtime.html)
*   用于 SQL 查询的[SQL 准则](../sql.html)
*   用于创建安全的 SQL 迁移的[迁移样式指南](../migration_style_guide.html)
*   [Testing Rails migrations](../testing_guide/testing_migrations_guide.html) guide
*   [Post deployment migrations](../post_deployment_migrations.html)
*   [Background migrations](../background_migrations.html)
*   [Swapping tables](../swapping_tables.html)
*   [Deleting migrations](../deleting_migrations.html)

## Debugging[](#debugging "Permalink")

*   使用带有[Marginalia 的](../database_query_comments.html)查询注释来跟踪 SQL 查询的源
*   使用[详细查询日志](https://guides.rubyonrails.org/debugging_rails_applications.html#verbose-query-logs)在 Rails 控制台中跟踪 SQL 查询的源

## Best practices[](#best-practices "Permalink")

*   [Adding database indexes](../adding_database_indexes.html)
*   [Foreign keys & associations](../foreign_keys.html)
*   [Adding a foreign key constraint to an existing column](add_foreign_key_to_existing_column.html)
*   [`NOT NULL` constraints](not_null_constraints.html)
*   [Strings and the Text data type](strings_and_the_text_data_type.html)
*   [Single table inheritance](../single_table_inheritance.html)
*   [Polymorphic associations](../polymorphic_associations.html)
*   [Serializing data](../serializing_data.html)
*   [Hash indexes](../hash_indexes.html)
*   [Storing SHA1 hashes as binary](../sha1_as_binary.html)
*   [Iterating tables in batches](../iterating_tables_in_batches.html)
*   [Insert into tables in batches](../insert_into_tables_in_batches.html)
*   [Ordering table columns](../ordering_table_columns.html)
*   [Verifying database capabilities](../verifying_database_capabilities.html)
*   [Database Debugging and Troubleshooting](../database_debugging.html)
*   [Query Count Limits](../query_count_limits.html)
*   [Creating enums](../creating_enums.html)

## Case studies[](#case-studies "Permalink")

*   [Database case study: Filtering by label](../filtering_by_label.html)
*   [Database case study: Namespaces storage statistics](../namespaces_storage_statistics.html)