Azure SQL Database vs TiDB Cloud

Azure SQL Database is a cloud-native relational database service built on the SQL Server engine and delivered as a fully managed PaaS. Microsoft manages provisioning, patching, backups, monitoring, and high availability. The service supports standard T-SQL and can be accessed through the Azure portal, SQL Server Management Studio, Visual Studio Code's MSSQL extension, and compatible application frameworks. It supports native JSON and REST and GraphQL APIs through Data API builder. Hyperscale independently scales compute and storage and supports scale-out with up to 30 named replicas. For AI application development, it offers native vector search and connections to Azure OpenAI and Azure AI Search. It can connect to Azure Functions and replicate SQL data into Microsoft Fabric for near-real-time querying and analysis. Security and governance include a multilayered approach with Microsoft Defender for SQL; recovery features include disaster recovery and snapshot-based backups. The free offer allows up to 10 General Purpose databases per subscription, each with 100,000 vCore seconds, 32 GB of data, and 32 GB of backup storage monthly. Once limits are reached, a database can auto-pause or remain online with excess use billed at standard rates.

TiDB Cloud is a managed cloud database service built around an open-source distributed SQL database with MySQL compatibility. It supports transactional and analytical workloads, horizontal scaling, multi-region deployment, and geo-partitioning across Starter, Essential, Premium, and Dedicated plans. Starter includes up to 25 GiB of row storage, 25 GiB of column storage, and 250 million Request Units per month per organization, for up to the first five instances. Its on-demand compute scales to zero when idle, and vector storage and search are in public preview. CSV, Parquet, and SQL file imports are supported across the listed plans. Email and password login, SSO options, private and public endpoints, and console audit logging are listed across all four plans. Prometheus, Grafana, and Datadog integrations are listed for Essential, Premium, and Dedicated in public preview. All users can submit billing and account support tickets; guaranteed technical-ticket response times require paid support plans. The service is available through web and API platforms. Starter is free; the Dedicated plan is listed as starting at $0.22 a month and from $1376 / month.