1 views collected around this technical thread.
This guide walks developers through downloading, installing, and using OceanBase Desktop on macOS, covering dependency setup with OrbStack, GUI features, cluster startup, tenant management, and how the tool simplifies local OceanBase cluster deployment.
This article presents a curated list of thirteen MySQL graphical management tools, describing their main features, platform support, and official download links, to help developers and administrators choose the most suitable GUI for database administration tasks.
This article introduces Chat2DB, an AI‑enhanced SQL client and reporting tool, walks through its key features, Docker‑based installation, practical usage with a SpringBoot‑Vue e‑commerce project, and demonstrates how its built‑in AI can generate SQL queries automatically.
This guide introduces the open‑source DBeaver database manager, walks through downloading, installing, and configuring it, demonstrates its use with a SpringBoot3 + Vue e‑commerce project, and covers theme settings, data source creation, table operations, SQL editing, and its support for various database types.
This article introduces three free, open-source MySQL client tools—MySQL Workbench, DBeaver, and phpMyAdmin—detailing their main features, cross‑platform support, and suitability for developers and administrators seeking powerful yet user‑friendly database management solutions.
The article outlines the growing difficulties of managing diverse databases in cloud-native environments, introduces Apache ShardingSphere as a comprehensive open‑source solution with three core capabilities—connectivity, enhancement, and pluggability—and guides readers through a three‑step learning path from fundamentals to deployment and testing.
This article provides 10 detailed Python code examples demonstrating how to connect to, query, insert, update, delete, and manage MySQL databases with proper error handling and resource management.
This case study details how Industrial and Commercial Bank of China's software development center tackled growing complexity, multi‑database client fragmentation, password‑storage risks, and data tampering by creating a centralized online platform that streamlines test data maintenance across thousands of databases while ensuring security and traceability.
This article provides an in‑depth comparison of the open‑source SQL quality management platforms SQLE and Yearning, covering their architecture, supported data sources, UI design, SQL workbench capabilities, user management, ticket workflow, system settings, and overall suitability for different database environments.
This article provides a detailed walkthrough of using the SQLE platform to create users, configure data sources, submit SQL tickets, perform reviews, and execute releases, illustrating each step with screenshots and practical tips for effective database change management.
This article introduces DBeaver, an open‑source, cross‑platform database management tool, outlines its key features, provides step‑by‑step usage instructions, and shares the project’s GitHub link, helping developers efficiently handle MySQL, PostgreSQL, Oracle and many other databases.
This article introduces Sequel Pro, a macOS GUI client for MySQL and MariaDB, explains how to configure standard connections with required fields, describes the main interface features such as database selection, table structure and content viewing, and highlights additional tools like Query and Table Info.
This article explains how OceanBase's recycle bin works, covering error causes when flashing back tables, methods to obtain a table's database, handling of multiple same‑name tables, visibility across tenants, and the ability to flash back tables or tenants even after the recycle bin is disabled.
The 2023 DAMS China Data Intelligence Management Summit in Shanghai featured a technical presentation by Zhang Shenbo on an open‑source SQLE solution for SQL quality control, covering multi‑database auditing, automated review workflows, and practical tips to reduce DBA workload and cross‑department communication.
This article provides a detailed tutorial on installing, configuring, and efficiently using JetBrains' DataGrip database client, covering connection setup, UI navigation, SQL editing shortcuts, data import/export, and advanced features for streamlined database management.
This article explains the background, environment setup, overall process, and detailed SQL commands required to safely lock, kill sessions, and permanently delete a MySQL tenant in OceanBase, including optional recycle‑bin handling.
This article details ZuanZuan's journey of automating TiDB operations, covering the initial operational pain points, the implementation of metadata and resource management, comprehensive upgrades, alarm redesign, and the development of a work‑order‑driven platform that streamlines node, scaling, decommission, and monitoring tasks while significantly reducing manual effort and costs.
This article introduces eleven popular MySQL graphical management tools—including DBeaver, DataGrip, phpMyAdmin, MySQLDumper, Navicat, MySQL GUI Tools, MySQL ODBC Connector, MySQL Workbench, SQLyog, MySQL‑Front, and dbForge Studio—detailing their features, platform support, and official download links to help developers choose the right solution.
This article provides a detailed tutorial on JetBrains DataGrip, covering installation, driver management, connection configuration, SQL editing shortcuts, data import/export, schema visualization, and various productivity features for efficiently working with relational databases.
Chen Yang, a senior DevOps engineer at Bilibili, brings over a decade of database expertise from multinational IT firms and major internet companies, having designed trillion‑scale architectures for billion‑user services, specialized in MySQL, automated and cloud‑native database operations, and holds several patented innovations.