Tagged articles
Database Tools
51 articles · Page 1 of 1
If you need a free, powerful MySQL client to replace Navicat, this guide compares three popular tools—DBeaver, MySQL Workbench, and HeidiSQL—covering their installation steps, key features, and suitability for developers and DBAs.
DBeaverDatabase ToolsHeidiSQL
0 likes · 5 min read

JetBrains quickly reverted the 2025.3 redesign of DataGrip’s SQL workflow, restoring the original Query Console as the default, and provides clear migration steps for users to delete, convert, or temporarily keep Query Files while outlining the impact and future plans.
DataGripDatabase ToolsIDE
0 likes · 6 min read

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 ToolsGUI
0 likes · 5 min read

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 deploymentWeb Management
0 likes · 8 min read

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.
Database ToolsOraclePLSQL
0 likes · 5 min read

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 ToolsMySQL
0 likes · 19 min read

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 ToolsMySQLPerformance Tuning
0 likes · 9 min read

This article introduces MySQL performance tuning utilities—including mysqltuner.pl, tuning-primer.sh, pt-variable-advisor, and pt-query-digest—provides download and usage commands with report‑analysis guidance, and then shifts to promotional content for ChatGPT‑4.0 services, a paid community, and related offers.
Database ToolsDevOpsLinux
0 likes · 12 min read

This article introduces four open‑source MySQL performance tools—mysqltuner.pl, tuning‑primer.sh, pt‑variable‑advisor, and pt‑query‑digest—explaining their purpose, how to download and run them, and how to interpret the diagnostic reports they generate for database optimization.
Database ToolsMySQLPerformance Tuning
0 likes · 12 min read

The MyBatis‑SQL‑Viewer plugin transforms MyBatis XML into executable SQL, offers mock data generation, SQL syntax and compliance checks, index analysis, performance stress testing, and seamless navigation between mapper interfaces and XML files, all without restarting the application.
Database ToolsIDE pluginMyBatis
0 likes · 11 min read

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 ToolsMyBatisSQL Mocking
0 likes · 11 min read

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 ToolsMySQLPerformance Tuning
0 likes · 8 min read

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 ToolsMySQLPerformance Tuning
0 likes · 9 min read


ITPUBApr 7, 2024 · Databases
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 ToolsUsability
0 likes · 8 min read

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 ToolsMySQLPerformance Tuning
0 likes · 7 min read

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

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

An in‑depth evaluation of three open‑source SQL audit platforms—SQLE, Yearning, and Archery—covers deployment simplicity, rule coverage, workflow integration, and product support, providing practical insights for teams selecting a solution to automate and govern SQL change management.
ArcheryDatabase ToolsSQL audit
0 likes · 10 min read

This article reviews five free or open‑source MySQL client applications—MySQL Workbench, phpMyAdmin, HeidiSQL, Sequel Pro, and DBeaver—detailing their main features, supported platforms, and how they help developers and DBAs design, query, and manage MySQL databases.
Database ToolsMySQLSQL Client
0 likes · 6 min read

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 ToolsMySQL
0 likes · 15 min read

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 ToolsIDE pluginWeb UI
0 likes · 8 min read

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 ToolsMySQLOceanBase
0 likes · 5 min read

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 ToolsMySQL
0 likes · 4 min read

This guide introduces RedisInsight and RedisMod, explains how to install them via Docker, demonstrates basic data operations, explores the CLI and Profiler features, and shows how to monitor Redis with Grafana and Prometheus, providing a comprehensive workflow for managing modern Redis deployments.
Database ToolsDockerGrafana
0 likes · 7 min read

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

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.
Database ToolsMVCCPostgreSQL
0 likes · 14 min read

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 ToolsMySQLPerformance Tuning
0 likes · 8 min read

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

This article introduces the open‑source pg_recovery tool for PostgreSQL, explains how to install it, and demonstrates recovering data lost through UPDATE, DELETE, ROLLBACK, and DROP COLUMN operations with practical command‑line examples.
Database ToolsPG recoveryPostgreSQL
0 likes · 8 min read

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 ToolsMySQLPerformance Tuning
0 likes · 9 min read

The DTLE 3.21.10.0 release introduces foreign‑key support, a new job parameter for foreign key checks, cascade operations, handling of large‑memory transactions, and various bug fixes and refactorings, providing a more robust MySQL data‑transfer solution.
DTLEData TransferDatabase Tools
0 likes · 4 min read

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 describes how to interpret their reports to identify configuration and query‑level issues.
Database ToolsMySQLSQL Optimization
0 likes · 8 min read

The DTLE 3.21.03.0 release introduces new MySQL data‑transfer configurations, performance improvements for Kafka full copies, and several bug fixes, while providing repository, documentation, and download instructions for users seeking a reliable open‑source replication component.
DTLEDatabase ToolsKafka
0 likes · 4 min read


ITPUBMar 21, 2021 · Databases
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.
Database ToolsGUIcomparison
0 likes · 11 min read

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 ToolsJDBC
0 likes · 5 min read

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

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 ToolsLinuxMySQL
0 likes · 25 min read

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 ToolsIDE
0 likes · 11 min read

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

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

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.
Database ToolsMongoDBPHP
0 likes · 9 min read

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 ToolsMySQLPerformance Tuning
0 likes · 9 min read


ITPUBMar 28, 2020 · Databases
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 ToolsMySQLSQL audit
0 likes · 6 min read

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 ToolsMySQLOperations
0 likes · 9 min read

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 ToolsMyCLIMySQL
0 likes · 9 min read

This article walks you through the complete installation process of Navicat for MySQL on Windows, covering download, version selection, license agreement, installation path, shortcut options, and final setup, with clear screenshots for each step.
Database ToolsMySQLNavicat
0 likes · 4 min read


21CTOAug 22, 2017 · Databases
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

This article introduces SQLPad, a lightweight browser‑based SQL client that offers smooth autocomplete, instant table and column browsing, and query saving across multiple databases, and explains how to install and start it via npm for a more efficient SQL writing experience.
Database ToolsSQLSQLPad
0 likes · 3 min read

This guide introduces MySQL Utilities, demonstrates how to configure master‑slave replication in seconds using the mysqlreplicate command, explains required user creation, showcases additional tools like mysqldiskusage and mysqlindexcheck, and provides installation and download instructions.
Database ToolsMySQLReplication
0 likes · 3 min read

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 ToolsMySQLTMySQLParse
0 likes · 12 min read

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 ToolsMySQLPerformance Analysis
0 likes · 5 min read
