0 views collected around this technical thread.
This article provides an overview of MySQL and PostgreSQL, compares their performance in SELECT, INSERT, and UPDATE operations under identical hardware, and discusses suitable scenarios for each database, highlighting the strengths and weaknesses of both systems.
The SQL Quick Start Course introduces beginners to Structured Query Language, covering data insertion, querying, updating, deletion, schema creation, modification, and access control, and provides an online learning link and QR code for immediate access.
The article explains how DBus ingests data from relational databases and log sources by detailing its extractor, incremental conversion, and full‑pull modules, the use of Canal and Kafka, rule‑based log structuring, the unified UMS message format, and heartbeat monitoring for reliability.
MSQL+ is a plugin toolkit that embeds similarity‑search capabilities directly into distributed relational databases such as Tencent’s TDSQL, using B‑tree indexes on generated signatures, customizable DIST functions, and various pivot‑selection strategies to enable scalable, SQL‑standard, approximate queries across sharded data.