This guide compiles over 70 essential Oracle SQL queries, shell commands, and scripts for inspecting version, configuration, tablespace usage, performance metrics, backup details, and cluster status, providing DBAs with a ready‑to‑use reference for comprehensive database health checks.
The article compares MySQL and MariaDB, tracing MySQL’s historic rise, explaining why MariaDB was forked, detailing their governance, enumerating MariaDB’s additional storage engines and performance optimizations, highlighting new features, and analyzing recent adoption trends that suggest MariaDB may eventually overtake MySQL.
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.
This article explains eight key reasons why SQL and relational database systems remain the dominant data management solution half a century after their invention, covering performance, maturity, community, simplicity, popularity, open‑source options, powerful query capabilities, and their continued relevance alongside newer technologies.
This article outlines eight key reasons why SQL and relational databases remain the dominant data management solution half a century after their invention, covering processing power, proven reliability, community support, simplicity, widespread adoption, open‑source growth, practical query power, and their role alongside NoSQL technologies.
This article compares MySQL and PostgreSQL, covering their histories, architecture differences, benchmark results, suitable application scenarios, and a concise summary of PostgreSQL's advantages and disadvantages relative to MySQL.
The 2023 first‑half newsletter compiles a comprehensive overview of the database sector, highlighting the surge of domestic vendors, key technological breakthroughs such as HTAP and serverless, and detailed version updates across RDBMS, NewSQL, graph, time‑series, big‑data, and cloud databases, offering valuable insights for practitioners and decision‑makers.
This 2023 comparison examines MySQL and PostgreSQL across history, features, performance, scalability, cost, and migration trends, helping developers decide which relational database best fits their specific application requirements.
A former Oracle MySQL optimizer lead publicly denounces MySQL as a poorly designed database, praises PostgreSQL's strengths, critiques MariaDB, and highlights real‑world migration experiences, offering a balanced view of the ongoing open‑source relational database debate.
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.
This newsletter compiles the most important updates from June 2021 across RDBMS, NoSQL, NewSQL, time‑series, big‑data, domestic and cloud databases, highlighting new versions, major features, performance improvements and security enhancements for products such as Oracle 21c, MySQL 8.0.24/8.0.25, PostgreSQL 14 Beta, TiDB 5.0, OceanBase V3.1 and many others.
The 2019 dbaplus Newsletter compiles a detailed overview of major RDBMS, NoSQL, NewSQL, big‑data, Chinese and cloud database releases, highlighting key features, performance improvements, security enhancements, and future road‑maps for each product.
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.
This article explains the ACID principles of relational databases versus the CAP principles of NoSQL systems, illustrates why distributed systems can only satisfy two of consistency, availability, and partition tolerance, and discusses how Eureka and Zookeeper embody AP and CP choices, especially during high‑traffic events like Double‑11.
The January 2019 DB-Engines newsletter compiles the newest releases, feature highlights, and performance improvements across RDBMS, NoSQL, NewSQL, time‑series, big‑data, domestic, and cloud database families, while also explaining the ranking methodology and providing download links for the full issue.
The 2018 DB-Engines ranking crowned PostgreSQL as the top DBMS, highlighting its 30‑year evolution, strong community, and expanding features, while MongoDB and Redis secured the runner‑up and third places respectively, and the January 2019 popularity scores showed continued shifts among major database systems.
This article compares SQLite, MySQL, and PostgreSQL across architecture, features, scalability, use cases, and limitations, helping developers choose the most suitable relational database for their specific application requirements.
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.
The March 2018 DBAplus Newsletter compiles the latest releases across RDBMS, NoSQL, NewSQL, time‑series and big‑data ecosystems, highlighting new features, performance improvements, compatibility updates and key technical links for Oracle, MySQL, MariaDB, SQL Server, DB2, PostgreSQL, TiDB, CockroachDB, InfluxDB, Hadoop and several Chinese‑made databases.
This article explains how to avoid data races in high‑traffic distributed systems by comparing pessimistic and optimistic concurrency control, demonstrating RDBMS row locks and a Redis‑based distributed lock implementation with Python code examples.
The October 2017 DBAplus Newsletter summarizes the newest releases across RDBMS, NoSQL, NewSQL, time‑series, big‑data and domestic databases, highlighting key features, performance improvements, and ecosystem updates while providing links to official documentation and source repositories.
Based on a 2017 Stack Overflow survey of 64,000 developers, this article explains why SQL remains the second‑most used programming language, detailing eight technical, community‑driven and practical reasons that keep relational databases indispensable despite the rise of newer technologies.
The April 2017 DBAplus Newsletter compiles the latest database releases, DB‑Engines ranking data, feature updates for Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, Hadoop, and emerging domestic systems, while summarizing key new‑SQL, NoSQL, and big‑data developments for database professionals.
The DBAplus Newsletter reviews recent DB‑Engines ranking trends, highlights major releases across RDBMS, NoSQL, NewSQL and big‑data ecosystems, analyzes shifting market dynamics, and lists upcoming community events and resources for database professionals.
