TOC-develop.md

Table of Contents

QUICK START

• Create a {{{ .starter }}} Cluster
• TiDB Basics
• CRUD SQL in TiDB

GUIDES

• Connect to TiDB
  • Overview
  • CLI & GUI Tools
    • MySQL CLI Tools
    • JetBrains DataGrip
    • DBeaver
    • VS Code
    • MySQL Workbench
    • Navicat
  • Drivers & ORMs
    • Choose a Driver or ORM
    • Java
      • JDBC
      • MyBatis
      • Hibernate
      • Spring Boot
      • Configure Connection Pools and Connection Parameters
      • Best Practices for Developing Java Applications
    • Go
      • Go-MySQL-Driver
      • GORM
    • Python
      • mysqlclient
      • MySQL Connector/Python
      • PyMySQL
      • SQLAlchemy
      • peewee
      • Django
    • Node.js
      • node-mysql2
      • mysql.js
      • Prisma
      • Sequelize
      • TypeORM
      • Next.js
      • AWS Lambda
    • Ruby
      • mysql2
      • Rails
    • C#
      • C#
  • TiDB Cloud Serverless Driver
    • Overview
    • Node.js Example
    • Prisma Example
    • Kysely Example
    • Drizzle Example
• Design Database Schema
  • Overview
  • Create a Database
  • Create a Table
  • Create a Secondary Index
• Write Data
  • Insert Data
  • Update Data
  • Delete Data
  • Periodically Delete Expired Data Using TTL (Time to Live)
  • Prepared Statements
• Read Data
  • Query Data from a Single Table
  • Multi-table Join Queries
  • Subquery
  • Paginate Results
  • Views
  • Temporary Tables
  • Common Table Expression
  • Read Replica Data
    • Follower Read
    • Stale Read
  • HTAP Queries
• Vector Search
• Manage Transactions
  • Overview
  • Optimistic and Pessimistic Transactions
  • Transaction Restraints
  • Handle Transaction Errors
• Optimize
  • Overview
  • SQL Performance Tuning
  • Best Practices for Performance Tuning
  • Best Practices for Indexing
  • Additional Optimization Methods
    • Avoid Implicit Type Conversions
    • Unique Serial Number Generation
• Troubleshoot
  • SQL or Transaction Issues
  • Unstable Result Set
  • Timeouts

INTEGRATIONS

• Third-Party Support
  • Third-Party Tools Supported by TiDB
  • Known Incompatibility Issues with Third-Party Tools
• ProxySQL
• Amazon AppFlow
• WordPress

REFERENCE

• Development Guidelines
  • Object Naming Convention
  • SQL Development Specifications
• Bookshop Example Application
• Cloud Native Development Environment
  • Gitpod