LLM Reasoning vs. Vector Search: Lessons from Building CrowdSnap’s Sentiment Analytics
CrowdSnap, a TiDB Cloud user, builds an AI analytics platform where teams upload datasets—like reviews or surveys—and pull natural language insights: sentiment trends, correlations, turning messy data into sharp decisions. In shaping their Prompt Analysis feature, the team hit a familiar AI crossroads: Lean on direct LLM calls (GPT via Azure OpenAI) for on-demand sentiment […]
Prompt To Production: Building Scalable AI on TiDB with Kiro
A technical deep dive into letting an AI reason directly over your database. Food waste is a quiet horror story. Every year, roughly 1.3 billion tons of food are discarded globally, often because we simply forget what’s in the back of our fridges. Half-used onions, forgotten spinach, and that single, lonely tomato—they aren’t just ingredients; […]
OpenClaw Memory Architecture: Building a Local-First RAG with SQLite
Editor’s Note: At PingCAP, we build distributed systems (TiDB), but we appreciate elegant engineering at any scale. OpenClaw demonstrates a perfect use case for local-first RAG databases: when you need zero-ops, total data privacy, and instant startup for a single user, SQLite is a highly pragmatic choice. We believe in choosing the right tool for […]
The Fire-and-Forget Pattern: Scaling Game Analytics with TiDB Cloud and Convex
Three developers, one hackathon, and a viral meme turned into a mission. This is the story of B40 Life Simulator, a financial literacy game inspired by the real B40 experience and the financial struggles faced by Malaysian youth. It balances social impact with a clever technical strategy. By pairing Convex for real-time gameplay with TiDB […]
TiDB AgentX Hackathon 2025 Recap: Double the Submissions, Real-World AI on Display
The results are in, and they are spectacular. When we challenged the community to move beyond simple RAG demos, we never imagined the sheer ingenuity we’d see. With 219 incredible submissions, the AgentX Hackathon 2025 proved one thing: the era of sophisticated, multi-step AI agents is here. A New Chapter for TiDB Hackathons Last year’s […]
From Plan to Execution: Zhihu’s Guide to Petabyte-Scale TiDB Database Migration
Author: Xiaolei Dai, Database lead at Zhihu Efficient and reliable data migration is crucial for large-scale online services. Zhihu, one of China’s largest knowledge-sharing platforms, recently undertook the complex task of online migration for dozens of TiDB databases, totaling petabytes (PB) of data. This blog post, based on the expertise of Zhihu’s database lead, Dai […]
Celebrating the TiDB Future App Hackathon 2024
During the recent HTAP Summit, I had the honor of celebrating another successful TiDB Future App Hackathon and announcing our winners. This year, we had close to 2,100 participants–about 40% increase from 2023–joining us from 80+ countries. If you visit the Hackathon project gallery, you will be able to see the winners and all other […]
Dify.AI x TiDB: Build Scalable AI Agent with Knowledge Base
Introduction Building AI Agents can be an intricate affair, but it doesn’t have to be with the right tools. The combination of TiDB’s new Serverless Vector Search, now welcoming users in its Public Beta phase, alongside Dify’s intuitive low-code platform, simplifies the creation of scalable, efficient AI solutions. This guide offers a clear pathway to […]
Announcing the TiDB Future App Hackathon 2024
We’re excited to announce that another edition to TiDB Future App Hackathon will be taking place between July 26 – August 23, 2024! Our first global Hackathon last year was an amazing success with almost 1,500 participants from 87 countries (see the recap blog for more details) and we’re looking forward to an even bigger […]
Why Documentation is Important
Documentation (or “docs”) is such a key part of any open-source software project. If you have good docs, users will find it easy to get started. They’ll also be able to find answers on their own for the majority of questions as they use the software. Even before I start evaluating technical products or organizations, […]
How to Query Data from TiDB with SQL or Java
You’ll learn how to query data from a SQL database with SQL and Java respectively.
Building a Web Application with Spring Boot and TiDB
This post shows you how to quickly build an application by leveraging Spring Boot and TiDB.