This year, a total of 182 open-source communities, 565 project tasks, and 2,290 students from 450 universities registered to participate.
Under more stringent application and review criteria, 518 students were selected for this year's OSPP. After three months of project development and one month of code merging, 437 students successfully completed the project after passing reviews by mentors, communities, and the organizing committee.
In the OSPP 2025 event, the IvorySQL community submitted 2 project topics: "Add One-Click Installation Script for IvorySQL" and "Develop sys_guid Function Based on uuid-ossp for IvorySQL". Each project was selected by one university student, and both successfully completed the project! Here, the IvorySQL community congratulates the two students on their successful project completion.
Completion Announcement Link:
https://summer-ospp.ac.cn/final
Introduction to IvorySQL Community Projects
This year, the IvorySQL community released 2 projects in OSPP, all focusing on the development of IvorySQL itself.
Project 1: Add One-Click Installation Script for IvorySQL
IvorySQL is an open-source Oracle-compatible database based on PostgreSQL, supporting multiple platforms and operating systems. Currently, IvorySQL requires manual execution of multiple commands for source code installation, lacking a one-click installation method. Although there are existing tutorials and commands for source code installation, the installation process varies across different operating systems, and manual execution is cumbersome and error-prone.
To address this, we plan to add a one-click installation script to enable users to quickly and easily install IvorySQL from source code. 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.
👨🎓 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: Develop sys_guid Function Based on uuid-ossp for IvorySQL
IvorySQL is an open-source database based on PostgreSQL, supporting various Oracle-compatible features. Currently, IvorySQL needs a powerful sys_guid function that ensures database-level uniqueness. Although the PostgreSQL kernel provides similar functions such as gen_random_uuid() based on pseudorandom numbers, there is still a lack of a dedicated sys_guid function.
Therefore, we plan to develop a 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 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
About Open Source Promotion Plan (OSPP)
The "Open Source Promotion Plan (OSPP)" is a series of summer activities guided by the "Open Source Software Supply Chain Promotion Plan" of the Institute of Software, Chinese Academy of Sciences. Co-hosted by the Institute of Software, Chinese Academy of Sciences 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, promote the vigorous development of excellent open-source software communities, and contribute to the construction of the open-source software supply chain.
The event collaborates with major open-source communities to provide projects for the development and maintenance of important open-source software, and opens registration to college students worldwide. Students can independently choose interested projects to apply for, and after being selected, develop under the guidance of senior developers (community mentors) of the project. Based on the difficulty and completion of the project, those who complete the project will receive project remuneration and completion certificates.
Event Official Website:
https://summer-ospp.ac.cn/
Official Email:
org@summer-ospp.ac.cn
Summary
OSPP is an effective way for college students to get in touch with and participate in open source. The IvorySQL community is honored to participate in it and assist two college students in successfully completing their projects. In the future, IvorySQL will invite the two students to join the IvorySQL community and continue to participate in open-source activities such as OSPP.