编程知识 cdmana.com

Interview with Mo Tianlun | ivorysql wangzhibin - ivorysql, an Oracle compatible open source database based on PostgreSQL

Sharing guests
Wang Zhibin
  Hangao IvorySQL The product manager
Arrangement
Mo Tianlun community

Reading guide

Hello everyone , I am a
Hangao IvorySQL
Product manager wangzhibin ,IvorySQL Is based on PostgreSQL Derivative open source projects . The content I share today is mainly divided into three parts : Who are we ? What we did ? And right IvorySQL Detailed introduction .

Who are we

1、 Who is Han Gao

As an enterprise with database as its core business, Henkel has been committed to providing customers with solutions with core competitiveness . We started with the first database maintenance service , During the service process, many database product requirements are collected , At the same time, we also see a business prospect of domestic databases . Through continuous learning and exploration , Henkel finally decided to base on PostgreSQL Database to develop database products .

At present, Hangao headquarters is set up in Jinan , At the same time, we are in Beijing 、 jinan 、 Qingdao 、 Chengdu 、 Baoding has R & D centers in these five places , It has a localized service capability covering the whole country , So as to quickly respond to the needs of customers .

At the same time, in order to strengthen cooperation with the international community , North American research institutes have also been set up overseas 、 Seattle R & D center and Islamabad R & D center .

null
chart 1  Introduction to Henkel

2、 The development of Henkel

I would like to introduce the development of Henkel . In the beginning , We still use Oracle The maintenance service is mainly provided , It mainly provides professional services for customers . But in practice , We also found a lot of customer needs , Including functionality 、 Security and so on .

With the continuous advancement of localization process , We see that there is no core product in the professional field of database , Development is actually subject to great limitations . So the company
stay 2009 Transformation started in , From the traditional operation and maintenance service to the research and development of an independent and controllable domestic database product , And in 2011 Launched its own database products in HighGo Database
. After entering the development period , We do constant iterations on product functions , Strive to build an ecosystem of products .

At present, the company has entered a breakthrough period of innovation , Expand product application scenarios in various business areas , So as to better serve customers . From the current core demand of the domestic database market , There is an urgent need to replace Oracle A relational database product of , What about this product , It can be controlled by a local technical resource , At the same time, it can also be supported by the global ecological space , It has a complete ecological environment .

null
chart 2  Han Gao's development history

What we did

Henkel's contribution to open source is mainly divided into three aspects : International exchanges and cooperation 、 Open source contribution and talent training .

Open source is inseparable from community construction , Henkel actively participates in international community activities , From the initial peripheral services to contributing code and core participation . So far , We have published in the blog system 100 Many technical articles , towards PostgreSQL The open source community has committed to 10 More than ten thousand lines of code .

null
chart 3  Henkel actively carries out international exchanges and cooperation

In terms of open source construction , from PG9.3.1 Start to participate in the translation of documents , The following figure shows the translation links of the main version documents .

null
chart 4  Henkel actively participates in the construction of open source

In the direction of talent training , We have close cooperation with colleges and universities , And Peking University 、 Shenzhen University and other universities have launched relevant open source general courses and development practice courses , At the same time, the senior engineers of Henkel participated in the preparation of the teaching plan 、 Courseware making , And the formulation of practical projects , Help build an open source ecosystem .

null
chart 5  Henkel actively carries out talent training and construction

IvorySQL  What is it?

1、IvorySQL  Project background

IvorySQL  How the project was born ? Mainly based on these four backgrounds : Data security 、 Service experience 、 Development appeal 、 Product needs .

First ,
Data security has become an important part of national security
. Database is the bottom storage platform of information system , Great responsibility . At the same time, the state is also vigorously promoting independent control , It is mentioned in different fields and industries “ Xinchuang ”, Han Gao is also involved .

The second background is the accumulation of Henkel's service experience
. Henkel has accumulated a very rich demand through customer service . Transform customers through application migration in the past , But such a practice will cause a bad user experience , In fact, it is also very intrusive to the user's business system , Cause some problems .

The third background is product demand
. Some customers have compatible product requirements , Specifically, the original commercial database is migrated to PG Database , This will also face the problem of compatibility .

The fourth background comes from developers
. In fact, some third-party development organizations and individuals have completed the compatible function code , But the international community does not recognize the inclusion of PG The major version , So we put forward IvorySQL Open source project , We hope to solve these problems mentioned above through cooperation and joint construction .

null
chart 6 IvorySQL Project background

2、IvorySQL  Project introduction

IvorySQL  The project was initiated by Henkel , Based on PostgreSQL The open source branch of . The current version is IvorySQL Release 1.3, We followed Apache 2.0  Open source licenses , meanwhile 100% And PostgreSQL compatible .

Shown below , We should keep PostgreSQL Basic functions of , Also add some compatibility , At the same time, there should be new features , This is also  IvorySQL  Our overall vision .

null
chart 7 IvorySQL Project introduction

3、IvorySQL  development history

since IvorySQL Released today 1.3 edition , It has gone through four milestones , The whole project adopts the agile development method .

2021 year 12 month 15 Number ,IvorySQL 1.0 Official release , Focus on data types and functions .IvorySQL 1.1 The version of is published in 2022 Year of 1 month 25 Number , This version solves 1.0 There are some problems in the version bug, Also fixed small features .2022 year 2 month 28 Number , We released 1.2 edition , Compared with the previous version , We have added a larger feature called hierarchical query . Abreast of the times 1.3 Version in 2022 year 5 month 27 No release , Added anonymous block support .

From the release timeline , It basically follows PostgreSQL The development route of , And some feature development work has been done with its version . This also realizes what we just said IvorySQL 100% and PostgreSQL compatible , And it can improve 、 Increase its functionality and compatibility .

null
chart 8 IvorySQL Project history

4、IvorySQL 1.3 Version introduction

The latest version is IvorySQL 1.3, The new version is based on PostgreSQL 14.3, It includes the following features :

  • Oracle compatible - Packages and functions
  • Oracle compatible -PL/iSQL Process language
  • adopt GUC Parameter switching Oracle and PostgreSQL Pattern
  • Oracle compatible - Varied DDL and DML grammar
  • Oracle compatible - date / Time function
  • Support hierarchical query
  • Supports anonymous blocks

Our R & D team is actually from outside and inside IvorySQL Project planning for . We will come from github Receive some comments and suggestions from external channels , Then, it will be incorporated into the plan through sorting, analysis and summary ; On the other hand , We have also made some internal R & D plans based on our previous experience . In the end, we hope that through this internal and external combination , Create better open source projects .

null
chart 9 IvorySQL The roadmap

Starting from the overall structure , We made great efforts to make IvorySQL100% And PostgreSQL Is compatible with the overall architecture , Ensure that the original work is not affected , And support more compatibility .

null
chart 10 IvorySQL The overall architecture

IvorySQL  stay  PostgreSQL  The main features added on the basis of include :

  • Oracle  Compatible with the package
  • Oracle  compatible  PL/iSQL  Process language
  • GUC  stay  Oracle  and  PostgreSQL  Switch between modes
  • Oracle  Compatible with all kinds of  DDL  The syntax of operation
  • Oracle  Compatible dates  /  Time function
  • built-in  Orafce

Welcome to IvorySQL  In open source projects , Here are the ways to contribute and report problems .

null
chart 11 IvorySQL Contribution path

null
chart 12 IvorySQL Problem reporting approach

In fact, through the previous Introduction , You should also be able to understand the continuous investment attitude of Henkel in the open source field . We also hope that more and more partners can participate , Give Way IvorySQL This open source project can continue to grow .

We are willing to be contributors to open source projects , We are serious about open source , Thank you. !

More highlights , Welcome to watch live video playback and video playback of conference materials :
https://www.modb.pro/video/6500
Conference materials :
https://www.modb.pro/doc/64403



  • Look at the original :
    https://www.modb.pro/db/416303
  • see 【 Domestic database salon 】 Special article on open source ecology 、 Video playback resources :
    https://www.modb.pro/topic/412121

For more information, you can enter
Mo Tianlun community
, Provide one-stop comprehensive service around the learning and growth of data people , Create a news collection 、 Online Q & A 、 Live broadcast of the event 、 Online courses 、 Document reading 、 Download resources 、 A unified platform for knowledge sharing and online operation and maintenance , Continue to promote knowledge dissemination and technological innovation in the field of data .

Official account :  Mo Tianlun 、  Motianlun platform 、 Motianlun Growth Camp 、 Database localization  、 Database information

版权声明
本文为[InfoQ]所创,转载请带上原文链接,感谢
https://cdmana.com/2022/174/202206231832548076.html

Scroll to Top