Essential Guide to Databases
Explore the fundamental concepts of databases with our comprehensive collection of articles.
MySQL Vector Similarity Search: Options and SQL Examples
MySQL Community 9.x can store a VECTOR column, but it cannot compute the distance between two of them. The DISTANCE() function ships only in MySQL HeatWave on OCI and MySQL AI, so a team running stock MySQL ends up doing similarity math in application code or syncing embeddings into a second database that lags behind […]
Do we Really Need Specialized Vector Databases for Vector Stores?
A RAG prototype usually starts with an in-memory vector store that lives inside the application process. When the prototype heads to production, a common next step is to add a standalone vector database next to the existing application database, plus a job that copies embeddings and metadata between the two. That second system brings its […]
Step-by-Step Guide to LangChain Integration
Master LangChain integration with our step-by-step guide. Learn setup, configuration, practical examples, and advanced features for seamless integration.
LangChain Benefits: What It Actually Solves for Developers
LangChain revolutionizes development with seamless integration, flexibility, and enhanced productivity. Discover its key features, practical applications, and long-term benefits.
Hybrid Databases: Real-Time Analytics with OLTP & OLAP
Discover how hybrid databases integrate OLTP and OLAP for real-time analytics, debunking myths and showcasing TiDB's HTAP capabilities.
Real-Time Data Processing in Financial Services: How TiDB Powers Fraud Detection and Risk Management
Discover how real-time data processing with TiDB enhances risk management, fraud detection, and customer personalization in finance.
Achieving Ultra-Low Latency in Financial Transactions with TiDB
Discover how TiDB's features ensure ultra-low latency in financial transactions, enhancing speed and reliability in modern financial systems.
NewSQL Databases: Scalability Meets Consistency in 2026
Discover how NewSQL databases offer scalability and consistency, with a focus on TiDB's features and industry impact.
TiDB HTAP: From NoSQL Tradeoffs to Hybrid Processing
Discover NoSQL's evolution and TiDB's HTAP features for scalable, real-time analytics in modern data environments.
Real-Time Analytics With TiDB: HTAP Use Cases and the Business Case for Going Unified
Discover how HTAP systems like TiDB integrate OLTP and OLAP for real-time analytics, enhancing decision-making in e-commerce and finance.
In Age of LLM: How to Store Vectors with MySQL SQL Grammar
Adding vector search to an application usually means adopting a new client library and a new query language on top of the SQL your team already knows. TiDB takes a different approach. Vector storage and search use familiar MySQL syntax, extended with a native VECTOR data type and a small set of distance functions. If […]
How to Add Vector Search to a MySQL Application with TiDB
Adding vector search to an application that runs on MySQL usually means standing up a separate vector database next to it, then keeping the two in sync for one new feature. TiDB offers a simpler path. It’s a MySQL-compatible distributed SQL database with a native VECTOR data type and HNSW index. Move your MySQL workload […]