# 开发指南

- 开发指南
  - [概览](/docs-cn/develop/dev-guide-overview.md)
  - 快速开始
    - [使用 TiDB Cloud (DevTier) 构建 TiDB 集群](/docs-cn/develop/dev-guide-build-cluster-in-cloud.md)
    - [使用 TiDB 的增删改查 SQL](/docs-cn/develop/dev-guide-tidb-crud-sql.md)
    - 构建简单的 CRUD 应用程序
      - [Java](/docs-cn/develop/dev-guide-sample-application-java.md)
      - [Golang](/docs-cn/develop/dev-guide-sample-application-golang.md)
  - 示例程序
    - [使用 Spring Boot 构建 TiDB 应用程序](/docs-cn/develop/dev-guide-sample-application-spring-boot.md)
  - 连接到 TiDB
    - [选择驱动或 ORM 框架](/docs-cn/develop/dev-guide-choose-driver-or-orm.md)
    - [连接到 TiDB](/docs-cn/develop/dev-guide-connect-to-tidb.md)
    - [连接池与连接参数](/docs-cn/develop/dev-guide-connection-parameters.md)
  - 数据库模式设计
    - [概览](/docs-cn/develop/dev-guide-schema-design-overview.md)
    - [创建数据库](/docs-cn/develop/dev-guide-create-database.md)
    - [创建表](/docs-cn/develop/dev-guide-create-table.md)
    - [创建二级索引](/docs-cn/develop/dev-guide-create-secondary-indexes.md)
  - 数据写入
    - [插入数据](/docs-cn/develop/dev-guide-insert-data.md)
    - [更新数据](/docs-cn/develop/dev-guide-update-data.md)
    - [删除数据](/docs-cn/develop/dev-guide-delete-data.md)
    - [预处理语句](/docs-cn/develop/dev-guide-prepared-statement.md)
  - 数据读取
    - [单表读取](/docs-cn/develop/dev-guide-get-data-from-single-table.md)
    - [多表连接查询](/docs-cn/develop/dev-guide-join-tables.md)
    - [子查询](/docs-cn/develop/dev-guide-use-subqueries.md)
    - [查询结果分页](/docs-cn/develop/dev-guide-paginate-results.md)
    - [视图](/docs-cn/develop/dev-guide-use-views.md)
    - [临时表](/docs-cn/develop/dev-guide-use-temporary-tables.md)
    - [公共表表达式](/docs-cn/develop/dev-guide-use-common-table-expression.md)
    - 读取副本数据
      - [Follower Read](/docs-cn/develop/dev-guide-use-follower-read.md)
      - [Stale Read](/docs-cn/develop/dev-guide-use-stale-read.md)
    - [HTAP 查询](/docs-cn/develop/dev-guide-hybrid-oltp-and-olap-queries.md)
  - 事务
    - [概览](/docs-cn/develop/dev-guide-transaction-overview.md)
    - [乐观事务和悲观事务](/docs-cn/develop/dev-guide-optimistic-and-pessimistic-transaction.md)
    - [事务限制](/docs-cn/develop/dev-guide-transaction-restraints.md)
    - [事务错误处理](/docs-cn/develop/dev-guide-transaction-troubleshoot.md)
  - 优化 SQL 性能
    - [概览](/docs-cn/develop/dev-guide-optimize-sql-overview.md)
    - [SQL 性能调优](/docs-cn/develop/dev-guide-optimize-sql.md)
    - [性能调优最佳实践](/docs-cn/develop/dev-guide-optimize-sql-best-practices.md)
    - [索引的最佳实践](/docs-cn/develop/dev-guide-index-best-practice.md)
    - 其他优化
      - [避免隐式类型转换](/docs-cn/develop/dev-guide-implicit-type-conversion.md)
      - [唯一序列号生成方案](/docs-cn/develop/dev-guide-unique-serial-number-generation.md)
  - 故障诊断
    - [SQL 或事务问题](/docs-cn/develop/dev-guide-troubleshoot-overview.md)
    - [结果集不稳定](/docs-cn/develop/dev-guide-unstable-result-set.md)
    - [超时](/docs-cn/develop/dev-guide-timeouts-in-tidb.md)
  - 引用文档
    - [Bookshop 示例应用](/docs-cn/develop/dev-guide-bookshop-schema-design.md)
    - 规范
      - [命名规范](/docs-cn/develop/dev-guide-object-naming-guidelines.md)
      - [SQL 开发规范](/docs-cn/develop/dev-guide-sql-development-specification.md)
  - 云原生开发环境
    - [Gitpod](/docs-cn/develop/dev-guide-playground-gitpod.md)