Разработка WEB-приложений для Postgres с помощью нового инструмента Live Universal Interface (LUI)
Will be demonstrated in the master-class the following: 1). The benefits of declarative programming. Rapid creation of complex LUI-forms using only SQL. 2). Support for long transactions and automatic locks. An example of a wizard with a record directly in the database. 3). The multilingual fields and columns. Rapid inclusion of multilingualism in existing forms. 4). Control the coloring of data in fields and columns of the form. Typical examples. 5). Live search in input fields using the example of address input. 6). How to configure the LUI to enter and display of application-specific data. 7). Design form Master Detail with retrieving data from two different databases. 8). How end-user builds of complex data queries without using SQL.
Слайды
Видео
Другие доклады
-
45 мин
Олег Правдин LingualeoОпыт плавной миграции высоконагруженного проекта (20+ млн. пользователей) c MySQL на PostgreSQL
A brief story how MySQL → PG migration could increase company efficiency tenfold times:
- Program code has been reduced 50 times, with optimization of backend team (from 15 to 3 engineers)
- Software development of new features has become measuring in days, not in months
- Infrastructure costs per 1M users have been reduced 20 times
- Database structure and technical documentation were simplified significantly, from 100K high-dependent tables to just 20 simple tables
- New security level because of total forbidden on external SQL commands to the database
- Quick analytics aggregation on multiple parameters, without external analytics systems
- The last, but not the least: the main business was keeping alive during migration
-
45 мин
Daria Vilkova Postgres Professional
Vadim Ipatov Zabbix SIAПлагин для мониторинга PostgreSQL для нового zabbix-agent
In Zabbix-server 4.4, a new Zabbix-agent has become available. It is written in Golang, has a plug-in structure, keeps a permanent connection and makes it possible to control metrics in runtime. We will make an overview of the Zabbix-agent 2 and talk about how to develop plugins for it, in particular, the PostgreSQL monitoring plugin developed by Postgres Professional in collaboration with Zabbix.
-
45 мин
Oleg Bartunov Postgres ProfessionalКак будет развиваться Postgres в ближайшие годы
A short overview of the main trends in Postgres development - both for the product itself and the community. What has changed in community goals?
-
22 мин
Александр Спирин Лига Цифровой Экономики
Кирилл Калистратов InCountryPostgreSQL Citus vs MongoDB sharded
We would like to share our test results (including performance testing) of PostgreSQL/Citrus and MongoDB for our company's data. It has been a very exciting process with unexpected turns and a somewhat controversial outcome.