Recap of PostgreSQL Technology Summit (Beijing) | Compatibility Innovation Practices under IvorySQL Dual-Parser Architecture

📅 Date: 2025-04-22 📍 Location: Beijing 🌍 Offline Event

On April 22, 2025, the "PostgreSQL Technology Summit (Beijing)," hosted by the PG Branch of China Open Source Software Promotion Alliance and co-initiated by Liu Huayang (PostgreSQL ACE/Head of PG Branch Beijing & Tianjin User Groups), was successfully held.

With the theme "Integration of PG and AI," IvorySQL R&D Engineer Jiao Shuntian was invited to deliver a keynote sharing — "IvorySQL V4: Compatibility Innovation Practices under Dual-Parser Architecture."

I. Compatibility Overview

1. Core Compatibility Features

• Oracle Compatibility Framework: Supports PL/iSQL, Oracle Package management, Invisible Columns, XML functions (11 new functions added), Sequences, etc.
• Heterogeneous Data Interaction: Provides Foreign Data Wrappers such as Oracle_fdw and Postgres_fdw.
• Key Innovations:
• Invisible Columns: Control column visibility via ALTER TABLE.
• Oracle Package: Supports package-level permission control and caching mechanisms.

2. Real-world Project Case (A Domestic Financial System)

• Objective: Replace Oracle stored procedures to meet requirements for core systems like the general ledger.
• Results: Performance and stability standards met; overcame memory overflow issues in massive data reading; provided deep support for Oracle Package functions.

II. Dual-Parser Architecture Design

Based on PostgreSQL 17, IvorySQL has expanded with a dual-parser (PG/Oracle parser) and dual-port design (5432/1521).

Key Technical Implementations

• Parser Hook Mechanism: Dynamically bind parsers via sql_raw_parser.
• Pluggable Design: Built-in IvorySQL_ORA plugin implementing data types, system views, MERGE commands, etc.

III. Community Development and Future Outlook

• Technical Direction: Developing IvorySQL V5 based on PostgreSQL 18, optimizing cloud-native support.
• Global Cooperation: Promoting project co-construction with OnGres (Spain) and Data Bene (France).
• Participation Incentives: Providing honorary certificates and limited-edition merchandise (hoodies, backpacks, mugs, etc.) as rewards.

Follow our WeChat Account [IvorySQL开源数据库社区] and reply with the keyword "20250419" to get the full PPT download link.