v3.0

About MogDB
- MogDB Introduction
- Comparison Between MogDB and openGauss
- MogDB Release Notes
- Open Source Components
- Usage Limitations
- Terms of Use
Quick Start
- MogDB Playground
- Container-based MogDB Installation
- Installation on a Single Node
- MogDB Access
  - Use CLI to Access MogDB
    - gsql
    - pgcli
  - Use GUI to Access MogDB
  - Use Middleware to Access MogDB
    - Use WebLogic to Configure MogDB Data Sources
    - Use WebSphere to Configure MogDB Data Sources
  - Use Programming Language to Access MogDB
    - Java
    - C/C++
    - Python
    - Go
    - Rust
    - NodeJS
    - .Net
- Using Sample Dataset Mogila
Characteristic Description
Installation Guide
- Installation Preparation
  - Environment Requirement
  - Operating System Configuration
- Container Installation
- PTK-based Installation
- OM-based Installation
- Manual Installation
- Recommended Parameter Settings
Administrator Guide
AI Features Guide
- AI Features Overview
- AI4DB: Autonomous Database O&M
  - DBMind Mode
  - Components that Support DBMind
    - Prometheus Exporter
  - AI Sub-functions of the DBMind
    - X-Tuner: Parameter Tuning and Diagnosis
    - Index-advisor: Index Recommendation
    - AI4DB: Root Cause Analysis for Slow SQL Statements
    - AI4DB: Trend Prediction
    - SQLdiag: Slow SQL Discovery
- DB4AI: Database-driven AI
  - Native DB4AI Engine
  - Full-process AI
    - PLPython Fenced Mode
    - DB4AI-Snapshots for Data Version Management
- AI in DB
  - Intelligence Explain: SQL Statement Query Time Prediction
Security Guide
- Database Security Management
Developer Guide
- Application Development Guide
  - Development Specifications
  - Development Based on JDBC
  - Development Based on ODBC
  - Development Based on libpq
    - Dependent Header Files of libpq
    - Development Process
    - Example
    - Link Parameters
    - libpq API Reference
      - Database Connection Control Functions
        Description
        PQconnectdbParams
        PQconnectdb
        PQconninfoParse
        PQconnectStart
        PQerrorMessage
        PQsetdbLogin
        PQfinish
        PQreset
        PQstatus
      - Database Statement Execution Functions
        PQclear
        PQexec
        PQexecParams
        PQexecParamsBatch
        PQexecPrepared
        PQexecPreparedBatch
        PQfname
        PQgetvalue
        PQnfields
        PQntuples
        PQprepare
        PQresultStatus
      - Functions for Asynchronous Command Processing
        Description
        PQsendQuery
        PQsendQueryParams
        PQsendPrepare
        PQsendQueryPrepared
        PQflush
      - Functions for Canceling Queries in Progress
        PQgetCancel
        PQfreeCancel
        PQcancel
  - Psycopg-Based Development
  - Commissioning
- Stored Procedure
- User Defined Functions
- PL/pgSQL-SQL Procedural Language
  - Overview of PL/pgSQL Functions
  - Data Types
  - Data Type Conversion
  - Arrays and Records
  - DECLARE Syntax
  - Basic Statements
  - Dynamic Statements
  - Control Statements
  - Transaction Management
  - Other Statements
  - Cursors
  - Advanced Packages
    - Basic Interfaces
      - PKG_SERVICE
  - Retry Management
  - Debugging
  - package
- Scheduled Jobs
  - PKG_SERVICE API
- Autonomous Transaction
- Logical Replication
  - Logical Decoding
    - Overview
    - Logical Decoding by SQL Function Interfaces
  - Publication-Subscription
- Foreign Data Wrapper
- Materialized View
  - Materialized View Overview
  - Full Materialized View
  - Incremental Materialized View
- Partition Management
  - Partition Pruning
  - Recommendations For Choosing A Partitioning Strategy
Performance Tuning Guide
Reference Guide
Common Faults and Identification
- Common Fault Locating Methods
- Common Fault Locating Cases
  - Core Fault Locating
  - Permission/Session/Data Type Fault Location
  - Service/High Availability/Concurrency Fault Location
  - Table/Partition Table Fault Location
    - Table Size Does not Change After VACUUM FULL Is Executed on the Table
    - An Error Is Reported When the Table Partition Is Modified
  - File System/Disk/Memory Fault Location
  - SQL Fault Location
  - Index Fault Location
Source Code Parsing
FAQs
Glossary
Mogeaver
- Overview
- Release Notes

Release Notes

Version	Release Date	Overview
3.0.7	2023.12.29	MogDB 3.0.7 is a patch version of MogDB 3.0.0, which fixes the problem of coupling the join condition that can be pushed down to a subquery and the query_dop parameter when the join statement contains a subquery based on MogDB 3.0.6.
3.0.6	2023.09.15	MogDB 3.0.6 is a patch version of MogDB 3.0.0. It mainly involves some bug fixes based on MogDB 3.0.5.
3.0.5	2023.07.20	MogDB 3.0.5 is a patch version of MogDB 3.0.0, which is released on July 20 of 2023. It mainly involves bug fixes based on MogDB 3.0.4, and incorporate fixed defects in openGauss 3.0.3.
3.0.4	2023.03.24	MogDB 3.0.4 is an emergency bug fix release of MogDB 3.0.3, released on 2023.03.24, with the goal of resolving thread pool related and other known coredump issues.
3.0.3	2022.10.31	MogDB 3.0.3 is a patch version of 3.0.2, mainly based on 3.0.2 for 7*24h stability test fixes.
3.0.2	2022.09.16	MogDB 3.0.2 is a patch version of MogDB 3.0.0. Function modifications include version upgrade optimization (support direct upgrade from v2.0 to v3.0), and the gsql '\l' command adds the function of displaying the database. MogDB 3.0.2 fixed the known defects, and synchronize the fixes for openGauss 3.0.1.
3.0.1	2022.07.30	MogDB 3.0.1 is a patch version of MogDB 3.0.0, which fixed bugs of database kernel, CM and extensions.
3.0.0	2022.06.30	MogDB 3.0.0 is an enhanced version based on MogDB 2.1 and incorporated with new features of openGauss 3.0.0, such as row-store execution to vectorized execution, parallel logical decoding, publication-subscription, CM (Cluster Manager). At the same time, MogDB 3.0.0 support asynchronous commit of autonomous transactions, parallelism control achieved during index creation, dynamic partition pruning, optimized COPY (Import), monitoring the run status of SQLs, Brin Index, Bloom Index and other self-developed features.