title: Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐºÐ° ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾ÑÐ° SQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð´Ð»Ñ Ð°ÑÐ¸Ð½Ñ ÑÐ¾Ð½Ð½Ð¾Ð³Ð¾ ÐºÐ»Ð¸ÐµÐ½ÑÐ° ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL
title: Ð²ÑÐ¿ÑÑÐºÐ½Ð°Ñ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð°Ñ ÑÐ°Ð±Ð¾ÑÐ° Ð±Ð°ÐºÐ°Ð»Ð°Ð²ÑÐ°
titleType: Subtitle
title: Development of query builder for asynchronous database management system PostgreSQL client
Creators: name: ÐÑÑÐµÐ½ÐºÐ¾, ÐÐ»ÐµÐºÑÐ°Ð½Ð´ÑÐ°
Publisher: name: Ð¡Ð°Ð½ÐºÑ-ÐÐµÑÐµÑÐ±ÑÑÐ³ÑÐºÐ¸Ð¹ Ð¿Ð¾Ð»Ð¸ÑÐµÑÐ½Ð¸ÑÐµÑÐºÐ¸Ð¹ ÑÐ½Ð¸Ð²ÐµÑÑÐ¸ÑÐµÑ ÐÐµÑÑÐ° ÐÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾
Year: 2024
Subjects: postgreSQL
Ð°ÑÐ¸Ð½Ñ ÑÐ¾Ð½Ð½ÑÐ¹ ÐºÐ»Ð¸ÐµÐ½Ñ Ð±Ð°Ð·Ñ Ð´Ð°Ð½Ð½ÑÑ
SQL
C++
asynchronous client of database

description: ÐÑÐµÐ´Ð¼ÐµÑ Ð¸ÑÑÐ»ÐµÐ´Ð¾Ð²Ð°Ð½Ð¸Ñ: ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾Ñ pgSQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð². Ð¦ÐµÐ»Ñ Ð²ÑÐ¿ÑÑÐºÐ½Ð¾Ð¹ ÐºÐ²Ð°Ð»Ð¸ÑÐ¸ÐºÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð¹ ÑÐ°Ð±Ð¾ÑÑ: ÑÐ°Ð·ÑÐ°Ð±Ð¾ÑÐ°ÑÑ ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾Ñ SQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð´Ð»Ñ Ð°ÑÐ¸Ð½ÑÑÐ¾Ð½Ð½Ð¾Ð³Ð¾ ÐºÐ»Ð¸ÐµÐ½ÑÐ° ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL. ÐÐ°Ð´Ð°ÑÐ¸, ÑÐµÑÐ°ÐµÐ¼ÑÐµ Ð² ÑÐ¾Ð´Ðµ ÑÐ°Ð±Ð¾ÑÑ: 1. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°ÑÑ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ðµ ÐºÐ»Ð¸ÐµÐ½ÑÑ ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL 2. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°ÑÑ ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ðµ ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾ÑÑ SQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² 3. ÐÑÑÐ»ÐµÐ´Ð¾Ð²Ð°ÑÑ Ð¿ÑÐ¾ÑÐ¾ÐºÐ¾Ð» Ð²Ð·Ð°Ð¸Ð¼Ð¾Ð´ÐµÐ¹ÑÑÐ²Ð¸Ñ Ñ ÑÐ¸ÑÑÐµÐ¼Ð¾Ð¹ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL 4. ÐÐ¿ÑÐµÐ´ÐµÐ»Ð¸ÑÑ ÑÑÐµÐº Ð¸ÑÐ¿Ð¾Ð»ÑÐ·ÑÐµÐ¼ÑÑ ÑÐµÑÐ½Ð¾Ð»Ð¾Ð³Ð¸Ð¹ 5. ÐÐ¿ÑÐµÐ´ÐµÐ»Ð¸ÑÑ Ð°ÑÑÐ¸ÑÐµÐºÑÑÑÑ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ 6. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°ÑÑ ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾Ñ SQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð² ÑÐ°Ð¼ÐºÐ°Ñ Ð°ÑÐ¸Ð½ÑÑÐ¾Ð½Ð½Ð¾Ð³Ð¾ ÐºÐ»Ð¸ÐµÐ½ÑÐ° ÑÐ¸ÑÑÐµÐ¼Ñ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL 7. ÐÑÐ¾Ð²ÐµÑÑÐ¸ ÑÐµÑÑÐ¸ÑÐ¾Ð²Ð°Ð½Ð¸Ðµ ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾ÑÐ° SQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ñ Ð¿Ð¾Ð¼Ð¾ÑÑÑ Ð´ÐµÐ¼Ð¾Ð½ÑÑÑÐ°ÑÐ¸Ð¾Ð½Ð½Ð¾Ð³Ð¾ Ð¿ÑÐ¸Ð»Ð¾Ð¶ÐµÐ½Ð¸Ñ Ð ÑÐ¾Ð´Ðµ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ ÑÐ°Ð±Ð¾ÑÑ Ð±ÑÐ» Ð¿ÑÐ¾Ð²ÐµÐ´ÐµÐ½ Ð°Ð½Ð°Ð»Ð¸Ð· ÑÑÑÐµÑÑÐ²ÑÑÑÐ¸Ñ ÑÐµÑÐµÐ½Ð¸Ð¹, Ð²ÑÑÐ²Ð»ÐµÐ½Ð° Ð¿Ð¾ÑÑÐµÐ±Ð½Ð¾ÑÑÑ Ð² ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð¿ÑÐ¾ÑÐ¾ÐºÐ¾Ð»Ð° Ð°ÑÐ¸Ð½ÑÑÐ¾Ð½Ð½Ð¾Ð³Ð¾ Ð²Ð·Ð°Ð¸Ð¼Ð¾Ð´ÐµÐ¹ÑÑÐ²Ð¸Ñ Ñ ÑÐ¸ÑÑÐµÐ¼Ð¾Ð¹ ÑÐ¿ÑÐ°Ð²Ð»ÐµÐ½Ð¸Ñ Ð±Ð°Ð·Ð°Ð¼Ð¸ Ð´Ð°Ð½Ð½ÑÑ PostgreSQL. ÐÐ»Ñ ÑÐµÐ°Ð»Ð¸Ð·Ð°ÑÐ¸Ð¸ Ð°ÑÐ¸Ð½ÑÑÐ¾Ð½Ð½Ð¾Ð³Ð¾ ÐºÐ»Ð¸ÐµÐ½ÑÐ° Ð±ÑÐ» Ð²ÑÐ±ÑÐ°Ð½ ÑÑÐµÐ¹Ð¼Ð²Ð¾ÑÐº Seastar. Ð Ð°Ð·ÑÐ°Ð±Ð¾ÑÐ°Ð½Ð½ÑÐ¹ ÐºÐ¾Ð½ÑÑÑÑÐºÑÐ¾Ñ SQL Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð¿Ð¾Ð·Ð²Ð¾Ð»ÑÐµÑ ÑÐ¾Ð·Ð´Ð°Ð²Ð°ÑÑ Ð¿ÑÐ¾ÑÑÑÐµ Ð¸ ÑÐ»Ð¾Ð¶Ð½ÑÐµ (ÑÐ¾Ð´ÐµÑÐ¶Ð°ÑÐ¸Ñ ÑÑÐ»Ð¾Ð²Ð¸Ñ, Ð³ÑÑÐ¿Ð¿Ð¸ÑÐ¾Ð²ÐºÑ) Ð·Ð°Ð¿ÑÐ¾ÑÑ Ð´Ð»Ñ Ð°ÑÐ¸Ð½ÑÑÐ¾Ð½Ð½Ð¾Ð³Ð¾ ÐºÐ»Ð¸ÐµÐ½ÑÐ° Ð¡Ð£ÐÐ PostgreSQL, Ð¾Ð±ÑÐ°Ð±Ð°ÑÑÐ²Ð°ÑÑ Ð¸ ÑÑÐ°Ð½Ð¸ÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÑ Ð²ÑÐ¿Ð¾Ð»Ð½ÐµÐ½Ð¸Ñ Ð·Ð°Ð¿ÑÐ¾ÑÐ¾Ð² Ð´Ð»Ñ Ð¿Ð¾Ð»ÑÐ·Ð¾Ð²Ð°ÑÐµÐ»ÑÑÐºÐ¸Ñ ÑÐ¸Ð¿Ð¾Ð², Ð° ÑÐ°ÐºÐ¶Ðµ Ð²ÑÐ²Ð¾Ð´Ð¸ÑÑ ÑÐµÐ·ÑÐ»ÑÑÐ°ÑÐ¾Ð² Ð² ÑÐµÐ»Ð¾Ð²ÐµÐºÐ¾ÑÐ¸ÑÐ°ÐµÐ¼Ð¾Ð¼ Ð²Ð¸Ð´Ðµ.
description: Subject of research: plSQL query builder. The final qualifying work purpose: development of query builder for asynchronous database management system PostgreSQL client Tasks that were solved during the work: 1. Research clients of database management system PostgreSQL 2. Research SQL query builders 3. Research wired PostgreSQL protocol 4. Define a technologies stack 5. Define the architecture of application 6. Develop SQL query builder for asynchronous client of database management system PostgreSQL 7. Test application Research of current solutions has shown the need for wired PostgreSQL protocol implementation. Seastar framework was chosen as a source of asynchrony primitives. The developed SQL query builder allows to create simple and complex (include clauses) queries for asynchronous database client, handle and store query results as objects of user types, output of results in human-readable format is also supported.