Longda's Interesting World

Distributed Databases & AI Agent Engineering Practice

A recap of the Hands-on AI Workshop at the OceanBase Annual Conference: hundreds of developers, guided by experts from LangChain, Dify, and OceanBase, completed the full development flow of environment setup, Agentic RAG building, and constructing long-term-memory agents in two hours of hands-on practice based on seekdb.

Read more »

Feng Zhongyan (Lao Ji), General Manager of OceanBase's Open Source Ecosystem, systematically answers three questions—why seekdb was open sourced, how it differs in positioning from OceanBase, and whether the open source commitment is long-term—and explains the design thinking behind the AI-native hybrid search database seekdb in terms of data fusion, AI Inside, and lightweight architecture.

Read more »

This article systematically untangles the design logic of Session IDs in OceanBase. The two connection types — C connections and S connections — correspond to four encodings (cs_id, proxy_sessid, server_sessid, ss_id). Through a range of query-command examples and the pass-through / non-pass-through behavior of the kill command, it builds a framework for understanding and troubleshooting session issues.

Read more »

This article explains AI Memory in plain language. Starting from how the human brain classifies and operates on memory, it compares the storage areas and storage forms of agent memory, then dives into the implementation principles of mainstream memory frameworks such as Letta, Zep, and Mem0, and summarizes the technical trends of agent memory and the demands it places on underlying storage.

Read more »

A systematic introduction to OceanBase partitioning fundamentals, covering the role of partitioning in partition pruning, data maintenance, and data distribution; the applicable scenarios and design points of the three basic partitioning methods — Hash, Range, and List; and flexible partition management capabilities such as dynamic partitioning, automatic partition splitting, and composite secondary partitioning.

Read more »

vivo's internet business introduced OceanBase to replace MySQL, covering four scenarios — data archiving, horizontal sharding, high concurrency, and HTAP — achieving a 60% improvement in high-concurrency update efficiency, an 80% improvement in complex query performance, and a 50% reduction in storage cost, while building a unified in-house operations platform.

Read more »

An accessible, easy-to-understand explainer. Starting from the classification of structured, semi-structured, and unstructured data, it explains why vector databases became a must-have in the AI era, how multi-path hybrid retrieval over scalar, full-text, and vector data became the engine of knowledge bases and AI applications, and looks ahead to databases evolving toward built-in AI Functions.

Read more »

An introduction to the Merge-On-Write table launched in OceanBase 4.3.5. By splitting an update into delete + insert and writing the full set of columns, it solves the read amplification of Merge-On-Read queries under an LSM Tree architecture, significantly boosting real-time analytics performance in update-heavy workloads.

Read more »

Belle Fashion Group migrated its core financial system from a sharded MyCat architecture to OceanBase, achieving a 30x performance improvement, a 96.7% reduction in storage cost, and a 59.4% reduction in hardware cost. This article details its three-step migration experience covering data flow, data verification, and SQL compatibility tuning.

Read more »