Implementation of PostgreSQL Wire Protocol in ClickHouse

Student: Elbakian Movses

Supervisor:

Educational Programme: Applied Mathematics and Information Science (Bachelor)

Year of Graduation: 2020

Databases are an essential part of most modern programs. There are many types of databases for different purposes, but one of the most common high-level classifications is SQL/NoSQL. SQL databases (ClickHouse and PostgreSQL are some of those) have similar syntax for making queries. Theoretically, a client of the one database can be used to make queries to a server of another. In practice, they are not compatible. That is why most databases provide specifications of wire protocols, which can be implemented on the server-side to support queries from another database client and vice-versa. This work provides an overview of PostgreSQL database server-side wire protocol implementation in Yandex ClickHouse analytical database.

Student Theses at HSE must be completed in accordance with the University Rules and regulations specified by each educational programme.

Summaries of all theses must be published and made freely available on the HSE website.

The full text of a thesis can be published in open access on the HSE website only if the authoring student (copyright holder) agrees, or, if the thesis was written by a team of students, if all the co-authors (copyright holders) agree. After a thesis is published on the HSE website, it obtains the status of an online publication.

Student theses are objects of copyright and their use is subject to limitations in accordance with the Russian Federation’s law on intellectual property.

In the event that a thesis is quoted or otherwise used, reference to the author’s name and the source of quotation is required.

Search all student theses