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