Database guides · Gitlab 中文文檔

# 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)