Tagged articles
51 articles
Page 1 of 1
Architecture Digest
Architecture Digest
Nov 21, 2025 · Databases

Top Free MySQL GUI Alternatives to Navicat: DBeaver, MySQL Workbench & HeidiSQL

This guide compares three free MySQL client tools—DBeaver, MySQL Workbench, and HeidiSQL—detailing their download links, installation steps, language settings, and key features such as multi‑database support, built‑in monitoring, and ER‑diagram capabilities, helping you choose the best replacement for Navicat.

DBeaverDatabase ToolsFree
0 likes · 5 min read
Top Free MySQL GUI Alternatives to Navicat: DBeaver, MySQL Workbench & HeidiSQL
macrozheng
macrozheng
Sep 9, 2025 · Operations

Master Web-Based Linux & Database Management with Mayfly-go: Install & Use Guide

This article introduces the open‑source web platform Mayfly-go, detailing its features for Linux system, MySQL, Redis, and MongoDB management, and provides step‑by‑step Docker installation and usage instructions with screenshots to help users quickly adopt the tool.

Database ToolsDocker deploymentLinux Administration
0 likes · 8 min read
Master Web-Based Linux & Database Management with Mayfly-go: Install & Use Guide
dbaplus Community
dbaplus Community
May 24, 2025 · Databases

How to Recover Data After an Oracle TRUNCATE Accident

When an Oracle table is accidentally truncated, this guide explains what TRUNCATE does, why recovery is difficult, and walks through four practical tools—Fy_Recover_Data, ODU, BBED, and GDUL—detailing step‑by‑step commands to restore the lost data safely.

Data RecoveryDatabase ToolsOracle
0 likes · 5 min read
How to Recover Data After an Oracle TRUNCATE Accident
Wukong Talks Architecture
Wukong Talks Architecture
Apr 28, 2025 · Databases

Comprehensive Guide to Popular Database Management Tools

This article provides an extensive overview of widely used database management tools across various platforms—including DBeaver, Navicat, PL/SQL Developer, Toad for Oracle, SQLyog, MySQL Workbench, HeidiSQL, Percona Toolkit, pgAdmin, SQLite Expert, and SSMS—detailing their supported databases, core features, licensing, download links, and related learning resources.

DBeaverDatabase ToolsNavicat
0 likes · 19 min read
Comprehensive Guide to Popular Database Management Tools
Liangxu Linux
Liangxu Linux
Feb 16, 2025 · Databases

Essential MySQL Tuning Tools: Diagnose and Optimize Your Database

This guide introduces four powerful MySQL performance‑tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining how to download, run, and interpret their reports to identify configuration issues, memory overload, and slow‑query problems.

Database Toolsmysqlpercona-toolkit
0 likes · 9 min read
Essential MySQL Tuning Tools: Diagnose and Optimize Your Database
Architect's Guide
Architect's Guide
Nov 6, 2024 · Databases

MyBatis SQL Viewer Plugin: Features, Installation, and Usage Guide

The MyBatis SQL Viewer plugin transforms MyBatis XML into executable SQL, provides mock parameters, syntax and compliance checks, index analysis, performance testing, data mocking, and comprehensive UI features, enabling developers to validate, benchmark, and manage SQL without restarting the application.

Database ToolsMyBatisPerformance Testing
0 likes · 11 min read
MyBatis SQL Viewer Plugin: Features, Installation, and Usage Guide
dbaplus Community
dbaplus Community
Sep 10, 2024 · Databases

Boost MySQL Performance: Essential Tools, Installation & Report Analysis

This guide introduces four popular MySQL performance‑tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—provides download commands, usage examples, and detailed tips for interpreting their diagnostic reports to improve database configuration and query efficiency.

Database ToolsShell Scriptsmysql
0 likes · 8 min read
Boost MySQL Performance: Essential Tools, Installation & Report Analysis
Liangxu Linux
Liangxu Linux
Apr 16, 2024 · Databases

Boost MySQL Performance: Essential Tools and How to Use Them

Learn how to assess and optimize your MySQL database using four powerful open‑source tools—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—complete with download links, command‑line usage examples, and guidance on interpreting their diagnostic reports to improve performance and security.

Database ToolsSQLmysql
0 likes · 9 min read
Boost MySQL Performance: Essential Tools and How to Use Them
ITPUB
ITPUB
Apr 7, 2024 · Databases

How to Choose the Right Database Management Tool: Expert DBA Insights

In this interview, a senior database operations manager shares why building a lightweight, purpose‑built tool is essential, outlines a systematic selection process based on clear operational needs, and highlights key criteria such as usability, security, and controllability while recommending practical solutions.

DBADatabase ToolsSecurity
0 likes · 8 min read
How to Choose the Right Database Management Tool: Expert DBA Insights
Architecture Digest
Architecture Digest
Jan 11, 2024 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, and Percona Toolkit

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning-primer.sh, and Percona Toolkit’s pt-variable-advisor and pt-query-digest—explaining how to download, run, and interpret their reports to optimize database configuration, memory usage, and query efficiency.

Database ToolsSQL OptimizationServer Administration
0 likes · 7 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, and Percona Toolkit
Java Architect Essentials
Java Architect Essentials
Dec 11, 2023 · Databases

MyBatis SQL Viewer Plugin: Features, Installation, and Usage Guide

The MyBatis SQL Viewer plugin for IntelliJ IDEA converts MyBatis XML to executable SQL, offers comprehensive mock data generation, compliance and index checks, execution plans, stress testing, and project‑wide scanning, streamlining CRUD development without repeated application restarts.

Database ToolsIDE pluginMyBatis
0 likes · 10 min read
MyBatis SQL Viewer Plugin: Features, Installation, and Usage Guide
Top Architecture Tech Stack
Top Architecture Tech Stack
Nov 7, 2023 · Databases

How to Install and Activate DataGrip on Windows and macOS

This guide walks you through downloading the latest DataGrip version, installing it on Windows or macOS, and using provided activation scripts to successfully activate the IDE, including step‑by‑step instructions, required command‑line operations, and verification of activation status.

ActivationDataGripDatabase Tools
0 likes · 4 min read
How to Install and Activate DataGrip on Windows and macOS
Aikesheng Open Source Community
Aikesheng Open Source Community
Feb 28, 2023 · Databases

Using sync-diff-inspector for MySQL/TiDB Data Validation and Repair

This article introduces the open‑source sync‑diff‑inspector tool, explains how to download and install it, and provides detailed configuration and command‑line examples for schema‑level, table‑level, and range‑based data validation between MySQL instances, including automatic SQL repair generation and common troubleshooting tips.

ConfigurationDatabase ToolsSQL repair
0 likes · 15 min read
Using sync-diff-inspector for MySQL/TiDB Data Validation and Repair
Laravel Tech Community
Laravel Tech Community
Oct 8, 2022 · Databases

Comparative Review of Popular Redis Visualization Tools

This article compares a range of Redis visualization solutions—including desktop clients, a web‑based platform, and an IDE plugin—detailing their features, licensing, platform support, and command‑line integration to help developers choose the most efficient tool for their workflow.

Database ToolsDesktop ClientIDE plugin
0 likes · 8 min read
Comparative Review of Popular Redis Visualization Tools
Aikesheng Open Source Community
Aikesheng Open Source Community
Sep 9, 2022 · Databases

SQLE 1.2209.0-pre1 Release Notes and Feature Overview

The preview release SQLE 1.2209.0-pre1 introduces OceanBase TopSQL auditing, Alibaba Cloud RDS MySQL audit‑log support, and a sub‑query nesting rule, while providing project background, download links, demo environments, and a detailed list of new features and release notes for database professionals.

Database ToolsOceanBaseRDS
0 likes · 5 min read
SQLE 1.2209.0-pre1 Release Notes and Feature Overview
Programmer DD
Programmer DD
Apr 25, 2022 · Databases

Explore Yearning: A Lightweight MySQL SQL Audit Platform for SMEs

Yearning is a lightweight, self‑contained MySQL SQL audit platform that offers query auditing, SQL review, permission management, and automated rollback, with simple installation steps and no reliance on third‑party tools, making it ideal for small and medium enterprises.

BackendDatabase ToolsSQL audit
0 likes · 4 min read
Explore Yearning: A Lightweight MySQL SQL Audit Platform for SMEs
Programmer DD
Programmer DD
Feb 23, 2022 · Information Security

Navicat Premium Compromised: Detect the Threat and Choose Safer Database Tools

A recent threat intelligence report reveals that Navicat Premium has been poisoned via a cracked version distributed from www.macwk.com, prompting users to urgently check for infections, change database passwords, and consider safer alternatives like Sequel Pro or IntelliJ IDEA's built‑in database client.

Alternative ToolsDatabase ToolsNavicat
0 likes · 5 min read
Navicat Premium Compromised: Detect the Threat and Choose Safer Database Tools
Qingyun Technology Community
Qingyun Technology Community
Jan 24, 2022 · Databases

Recover Lost PostgreSQL Data: Tools, Techniques, and Best Practices

This article explains why PostgreSQL data loss occurs, compares DDL and DML causes, and reviews several recovery tools—including pg_resetwal, pg_dirtyread, pg_recovery, pg_filedump, WalMiner, and pageinspect—providing usage examples, summaries, and practical recommendations for effective data restoration.

Data RecoveryDatabase ToolsMVCC
0 likes · 14 min read
Recover Lost PostgreSQL Data: Tools, Techniques, and Best Practices
Top Architect
Top Architect
Jan 7, 2022 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑diagnostic utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run them, and shows how to interpret their reports for optimizing database configuration and query performance.

Database ToolsMySQLTunermysql
0 likes · 8 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 10, 2021 · Databases

DTLE 3.21.11.0 Release Notes – New Features and Fixes

The DTLE 3.21.11.0 release introduces MySQL‑specific enhancements such as partitioned table creation, geometry type support, multi‑threaded replay with unique columns, and large‑transaction handling, while also fixing an alter‑table rename issue, and provides download links and related reading resources.

DTLEData TransferDatabase Tools
0 likes · 3 min read
DTLE 3.21.11.0 Release Notes – New Features and Fixes
Java Architect Essentials
Java Architect Essentials
Nov 17, 2021 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download, install, and run them, and shows how to interpret their diagnostic reports to identify configuration issues and optimize database performance.

Database Toolsmysqlmysqltuner.pl
0 likes · 9 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
ITPUB
ITPUB
Mar 21, 2021 · Databases

Which Redis GUI Tool Is Best? A Hands‑On Comparison of 11 Options

This article evaluates eleven popular Redis visualization tools—desktop clients, web applications, and IDE plugins—detailing their features, platform support, pricing, and pros and cons, while providing URLs and screenshots to help developers choose the most efficient solution for debugging and monitoring.

ComparisonDatabase ToolsGUI
0 likes · 11 min read
Which Redis GUI Tool Is Best? A Hands‑On Comparison of 11 Options
Java Architect Essentials
Java Architect Essentials
Feb 10, 2021 · Databases

Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide

This article introduces DBeaver, a free open‑source, cross‑platform database management tool that supports numerous databases via JDBC, outlines its rich features such as data editors, ER diagrams, import/export, and provides step‑by‑step installation instructions for Windows, macOS, and Linux, plus tips for creating connections.

Data ManagementDatabase ToolsInstallation
0 likes · 5 min read
Master DBeaver: Free Open‑Source Database Tool and Easy Installation Guide
macrozheng
macrozheng
Sep 16, 2020 · Databases

Explore AnotherRedisDesktopManager: Free, Beautiful Redis GUI with Cluster Support

This guide introduces AnotherRedisDesktopManager, a free and visually appealing Redis GUI that supports cluster connections, walks through installation from GitHub, explains key features such as dark mode, command console, and versatile data operations for strings, lists, and hashes, and demonstrates practical cluster usage.

AnotherRedisDesktopManagerDatabase ToolsGUI
0 likes · 5 min read
Explore AnotherRedisDesktopManager: Free, Beautiful Redis GUI with Cluster Support
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 30, 2020 · Databases

Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage

This article provides a comprehensive guide to gh-ost, the GitHub‑released online MySQL schema migration tool, covering its design principles, three migration modes, download and RPM installation, common command‑line options, interactive socket commands, and a step‑by‑step example of altering a column type while monitoring progress and performing a safe cut‑over.

Database ToolsSchema Changegh-ost
0 likes · 25 min read
Using gh-ost for Online MySQL Schema Migration – Introduction, Architecture, Installation, and Practical Usage
Architecture Digest
Architecture Digest
Jul 25, 2020 · Databases

A Comprehensive Guide to Using JetBrains DataGrip for Database Management

This article provides a detailed walkthrough of JetBrains DataGrip, covering installation, connection setup, UI customization, SQL editing features, data import/export, and numerous productivity shortcuts, helping developers efficiently manage and interact with various relational databases.

DataGripDatabase ManagementDatabase Tools
0 likes · 11 min read
A Comprehensive Guide to Using JetBrains DataGrip for Database Management
Programmer DD
Programmer DD
Jun 11, 2020 · Databases

13 Must-Have MongoDB GUI Tools for Efficient Database Management

This article introduces thirteen popular MongoDB graphical tools—including Robo 3T, Navicat, Compass, NoSQLBooster, ClusterControl, NoSQLClient, Studio 3T, Mongo Management Studio, Aqua Data Studio, phpMoAdmin, Mongotron, Mongolime, and mongo‑express—detailing their key features, platform support, and download links to help users choose the best visual interface for database administration.

AdministrationDatabase ToolsGUI
0 likes · 15 min read
13 Must-Have MongoDB GUI Tools for Efficient Database Management
macrozheng
macrozheng
Jun 1, 2020 · Databases

Master DataGrip: Essential Tips for Efficient MySQL & MongoDB Management

This guide walks you through downloading DataGrip, configuring its appearance, creating MySQL and MongoDB data sources, managing tables, applying powerful SQL editing shortcuts, and leveraging export and execution‑plan features to write higher‑quality database code.

DataGripDatabase ToolsMongoDB
0 likes · 7 min read
Master DataGrip: Essential Tips for Efficient MySQL & MongoDB Management
dbaplus Community
dbaplus Community
May 18, 2020 · Databases

Deploy and Use the Open‑Source MongoDB Visual Monitoring Tool (mongo_monitor)

This guide explains how to set up the mongo_monitor tool—a PHP‑based graphical monitor for MongoDB—by installing required PHP extensions, configuring a MySQL schema, adding MongoDB credentials, customizing email and WeChat alerts, scheduling data collection via cron, and accessing the web dashboard.

AlertingDatabase ToolsDeployment
0 likes · 9 min read
Deploy and Use the Open‑Source MongoDB Visual Monitoring Tool (mongo_monitor)
Liangxu Linux
Liangxu Linux
Apr 12, 2020 · Databases

Essential MySQL Performance Tuning Tools and How to Use Them

This guide introduces four open‑source MySQL tuning utilities—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download and run each tool, and shows how to interpret their AWR‑style reports for concrete performance and security improvements.

Database ToolsSQLmysql
0 likes · 9 min read
Essential MySQL Performance Tuning Tools and How to Use Them
ITPUB
ITPUB
Mar 28, 2020 · Databases

Explore Yearning: An Open‑Source MySQL SQL Audit Platform

Yearning is an open‑source MySQL SQL audit platform that offers query auditing, workflow‑driven review, execution, rollback, fine‑grained permission control and notification integrations, with detailed installation steps and a public Gitee repository for easy deployment.

Database ToolsSQL auditYearning
0 likes · 6 min read
Explore Yearning: An Open‑Source MySQL SQL Audit Platform
Top Architect
Top Architect
Mar 3, 2020 · Databases

MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest

This article introduces several MySQL performance‑tuning utilities—including mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explains how to download, install, run them, and interpret their reports to identify configuration issues and optimize database performance.

Database ToolsOperationsSQL Optimization
0 likes · 9 min read
MySQL Performance Tuning Tools: mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest
NetEase Game Operations Platform
NetEase Game Operations Platform
Sep 28, 2019 · Databases

Introducing mycli: A Feature‑Rich MySQL Command‑Line Client

This article introduces mycli, a Python‑based MySQL command‑line client that offers easy installation via pip, advanced auto‑completion, high‑risk operation confirmations, customizable syntax highlighting, output paging, command bookmarking, logging, multiline editing, flexible credential handling, and additional features such as SSL support and query looping.

Database ToolsMyCLISQL
0 likes · 9 min read
Introducing mycli: A Feature‑Rich MySQL Command‑Line Client
21CTO
21CTO
Aug 22, 2017 · Databases

Mastering Redis Replication in Java: How Redis‑Replicator Works and Extends

Redis‑replicator is a lightweight Java library that implements Redis master‑slave synchronization, parses RDB and AOF files, supports Redis 2.6‑4.0 (including modules), and offers extensible command and module hooks, making it suitable for embedding in backend systems.

AOFDatabase ToolsJava
0 likes · 5 min read
Mastering Redis Replication in Java: How Redis‑Replicator Works and Extends
Efficient Ops
Efficient Ops
Nov 23, 2015 · Databases

How Tencent’s TMySQLParse Automates MySQL SQL Auditing and Cuts DBA Workload

This article explains the background, implementation, usage, and real‑world integration of TMySQLParse, a MySQL‑compatible SQL audit tool developed by Tencent to automatically detect syntax errors and high‑risk statements, thereby streamlining the game‑cloud change‑order workflow.

Database ToolsTMySQLParsemysql
0 likes · 12 min read
How Tencent’s TMySQLParse Automates MySQL SQL Auditing and Cuts DBA Workload
MaGe Linux Operations
MaGe Linux Operations
Apr 1, 2015 · Databases

Master MySQL Slow Query Log: Enable, Analyze, and Choose the Best Tools

This guide explains how to enable MySQL's slow query log, configure it in my.cnf, and compares five popular analysis tools—mysqldumpslow, mysqlsla, mysql-explain-slow-log, mysql-log-filter, and myprofi—detailing their features, output formats, and advantages to help you select the most suitable solution.

Database ToolsSlow Query Logmysql
0 likes · 5 min read
Master MySQL Slow Query Log: Enable, Analyze, and Choose the Best Tools