IvorySQL logoIvorySQL
β€”
Back to News
Community

Congratulations to the Selected Students for IvorySQL Projects in Open Source Summer 2025

After three rounds of review, the selected list for OSPP 2025 is officially revealed!

Jun 28, 2025

On June 28th, after three rounds of review by mentors, open source communities and the organizing committee, the official list of selected participants for Open Source Summer 2025 was announced! This year, a total of 518 university students from home and abroad stood out in the increasingly fierce competition and were successfully selected for the project tasks of Open Source Summer 2025.

Public List of Selected Participants:
https://summer-ospp.ac.cn/org/projectlist

In the Open Source Summer 2025 event, the IvorySQL community submitted 2 project topics, namely: Developing a one-click installation script for IvorySQL, and Building the sys_guid function based on uuid-ossp for IvorySQL. In the end, one university student was selected for each of the two projects. The IvorySQL community extends its congratulations to the two selected students and wishes them a smooth project completion.

Project Introduction by the IvorySQL Community

This year, the IvorySQL community released 2 projects for Open Source Summer, all focusing on the development of IvorySQL itself.

Project 1: Develop a One-Click Installation Script for IvorySQL

IvorySQL is an open-source Oracle-compatible database based on PostgreSQL, supporting deployment and usage across multiple platforms and operating systems. At present, IvorySQL requires manual execution of multiple commands for source code installation, with no one-click installation method available. Although tutorials and commands for source code installation already exist, the installation process varies across different operating systems, and the manual execution process is cumbersome and prone to errors.

To address this issue, we plan to add a one-click installation script, enabling users to install IvorySQL from source code quickly and easily. The ultimate goal is to provide a one-click installation script that allows users to complete the installation and startup of IvorySQL with a single command after simple configuration and script execution.

πŸ‘¨β€πŸŽ“ Selected Student: Wang Shuo

πŸ‘¨β€πŸ« Project Mentor: Jiao Shuntian

πŸ“¨ Contact Email: jiaoshuntian@highgo.com

πŸ”‘ Project Difficulty: Basic

⛏ Technical Field: PostgreSQL

β˜… Project Details: https://summer-ospp.ac.cn/org/prodetail/258430417

Project 2: Build the sys_guid Function Based on uuid-ossp for IvorySQL

IvorySQL is an open-source PostgreSQL-based database with a variety of Oracle-compatible features. Currently, IvorySQL is in need of a robust sys_guid function that ensures uniqueness at the database level. While the PostgreSQL kernel provides similar functions such as gen_random_uuid() based on pseudo-random numbers, a dedicated sys_guid function is still missing.

Therefore, we plan to develop a custom sys_guid function that meets the requirements based on the uuid-ossp/e2fs extension, and submit the final code to GitHub in the form of a Pull Request (PR).

πŸ‘¨β€πŸŽ“ Selected Student: Chong Penghao

πŸ‘¨β€πŸ« Project Mentor: Niu Shiji

πŸ“¨ Contact Email: niushiji@highgo.com

πŸ”‘ Project Difficulty: Basic

⛏ Technical Field: PostgreSQL

β˜… Project Details: https://summer-ospp.ac.cn/org/prodetail/258430418

Open Source Summer serves as an effective channel for university students to access and participate in open source. The IvorySQL community looks forward to co-building the community with the two selected students, and wishes them a smooth project completion and valuable progress throughout the process.

About Open Source Summer

Open Source Summer (OSPP for short) is a series of summer events guided by the "Open Source Software Supply Chain Lighting Program" of the Institute of Software, Chinese Academy of Sciences (ISCAS). Co-hosted by ISCAS and Huawei Technologies Co., Ltd., it aims to encourage college students to actively participate in the development and maintenance of open source software, cultivate and discover more outstanding developers, boost the vigorous development of excellent open source software communities, and support the construction of the open source software supply chain.

In collaboration with major open source communities, the event offers projects focusing on the development and maintenance of important open source software, and opens applications to university students worldwide. Students can independently select and apply for projects they are interested in; upon selection, they will carry out development under the guidance of senior project developers (community mentors). Based on the difficulty level and completion status of the projects, participants who successfully finish the projects will receive project completion rewards and certificates.

Official Website:
https://summer-ospp.ac.cn/

Official Email:
org@summer-ospp.ac.cn