UFADEVCONF 2017 Conference Overview

PostgreSQL for hipsters, Modbankbank backend and more.

October 14, in the sunny city of Ufa, the UFADEVCONF conference was held. This is the first event in Ufa of such a scale, it was organized by the Ufa community of developers Ufacoder and the Open Region company. Sections of reports - Backend, Frontend, Mobile, Common.

We offer a review of the conference and the most interesting reports of the Backend section.

Members

900 participants were registered, and almost all of them came, which is rare for a freeboard event.

The speakers are the first persons of PostgreSQL Professional, members of the Modbank development teams, Tensor (an SBIS product), specialists from Yandex, Kaspersky, Sberbank-Technologies, 1C-Bitrix, Avito.ru and others. By the standards of the regional conference, the organizers put together a really cool program.

Reports

Reports were held in four sections: Backend, Frontend, Mobile, Common. In Common gathered project management and other common topics.

The list can be found here . Links to all slides will be at the end of the article. For us, the most interesting section, of course, was Backend.

Backend is our everything!

The main topic of the section is PostgreSQL.

PostgreSQL

Most of the section reports were devoted to him.

General Director of PostgreSQL Professional Oleg Bartunov in the report “PostgreSQL for hipsters” told about the advantages of this DBMS and about the planned innovations.

Spoilers:
- a new version of json / sql is being developed: not mainstream yet, but it is already possible to use;
- master-master replication interests everyone: it is planned, but the dates are not yet clear;
- certification is planned when licenses for educational activities are obtained: training courses in Russian and English are available now;
- PGconf 2018 will be held February 5-7 in Moscow, come!

On this report, the hall of the Backend section was simply packed to capacity, and then several hours in a hall around the crowd crowded with visitors who lacked a 40-minute report.
Link to report: Postgres for hipsters

Ivan Panchenko from PostgreSQL Professional told about server-side programming in Postgres on PL / {Perl, Python, V8}.

Link to report: PL / {Perl, Python, V8}: server-side programming in Postgres in human language

Kirill Borovikov, technical director of the company "Tenzor" (developer SBIS.RU) shared the experience of mass optimization of databases PostgreSQL, on the basis of what internal service explain.sbis.ru was created (there is now a well-known analogue https://explain.depesz.com/ ). By the way, Tensor operates 250 database servers and thousands of databases with a total “weight” of 400 TB. explain.sbis.ru is not yet open to public access, but in theory it will be open soon.

Link to report: Bulk query optimization in PostgreSQL - explain.sbis.ru

How is the backend of "Modbank"

Another interesting report: about the backend of “Modbank” was told by the technical backend developed by Rustem Musairov.

Modbank uses 2 main bases on PostgreSQL (of course, there are more servers). Redis is used for cache, RabbitMQ for servers of queues, horizontal scaling is actively used.

I remember that the guys do not use something unreal, many people know these technologies, but everything is optimized to the limit.

For example, all calls to services pass through agents and servers of queues; no one directly contacts the database. Developers use tools to optimize work, and if there is a ready-made solution, try not to write "bikes". The speed of development and scaling (Rustem spoke about a sharp increase from 2013 to 2017) dictates its own conditions. Since I haven’t heard about the problems and the feil, then the team is coping with these tasks :).
Link to report: How the Modbankbank backend works

Three more reports dealt with video editing in python on the moviepyf and ffmpeg library (told by Rustem Salavatov), ​​innovations in PHP 7.x (Yaroslav Annenkov) and monitoring the infrastructure of the Internet service (Nikita Voronov).

Optimization of projects on 1C-Bitrix under Highload

The conference was also Alexander Serbul from 1C-Bitrix. He spoke in the Common section, but we managed to talk on the topic of optimizing projects on Bitrix under Highload.

Since the central topic was databases, then questions about them:

• There is no sharding DB yet and it is not known about the plans; if you need database scaling for 1C-Bitrix projects, our way is mysql master-master clusters or master-slave.
• The company abandoned Oracle a long time ago, PostgreSQL also does not, so our way is mysql

Another advice from Alexander for visited and high-loaded projects: watch caching and “left” requests to the database when not only the site but also mobile applications access the database, there is an active exchange with 1C, etc.

By the way, on system administration in 1C-Bitrix, questions can be asked just Alexander Serula.

Reports slides

The organizers have reports available only on VKontakte:

Backend - https://vk.com/ufacoder?w=wall-105462043_284
Frontend - https://vk.com/ufacoder?w=wall-105462043_285
Mobile - https://vk.com/ufacoder?w=wall-105462043_283
Common - https://vk.com/ufacoder?w=wall-105462043_282

With the permission of the organizers, we posted the reports of the Backend section on Google Slides:

1. Rustem Musairov, technical development backend, JSC Modbank, Ufa. How the modbank backend works
2. Oleg Bartunov, General Director of Postgres Professional, Moscow. Postgres for hipsters
3. Rustam Salavatov, founder of life2film.com, Advisor to the Director of the Council of Bashkir State University for Informatization, Sterlitamak. Video editing in python on the moviepy and ffmpeg library
4. Kirill Borovikov, technical director, chief database expert, Tensor, Yaroslavl. Mass optimization of queries in PostgreSQL - explain.sbis.ru
5. Nikita Voronov, Backend Developer, SMENA, Ufa. Monitoring Farfor delivery restaurant infrastructure
6. Ivan Panchenko, Deputy General Director of Postgres Professional, Moscow. PL / {Perl, Python, V8}: server-side programming in Postgres in the human language
7. Yaroslav Annenkov, Web Developer, Ufa. The main thing about PHP 7.x

Thanks to the organizers, speakers and all involved!

The author: Vadim Isakanov