United Russia (PostgreSQL DBMS)

2020: Creating a news portal

Task

The task is to make a modern news portal divided into regions. Transfer 1,300,000 existing publications and 500,000 photographs to it. The design of the previous site is outdated, in addition, a lot of legacy code has accumulated, the structure databases was suboptimal, which created technical difficulties.

Execution

Extyl specialists updated the party's website: they developed a portal on which news and comments from party representatives throughout the country are published daily. 1.3 million publications and other media content were transferred from the previous version of the site and adapted the portal to high loads - now it can withstand up to 20,000 simultaneous calls.

Database Integration

Party persons often change positions, so employees had to point-update information on all 85 regional subdomain sites manually. To automate this process, the site is integrated with a single database of batch persons, so that updates in the database are automatically reflected on all sites. Employees were divided into groups: by region and positions, so that the information is displayed correctly.

The development was carried out on PostgreSQL. This allowed you to use both the standard SQL approach and NoSQL solutions. So the speed and size of the database was optimized.

Content

Every day, more than a thousand news are published throughout Russia. Each region has a press center with its own agenda, commentators, speakers. Regional news is published on separate sub-domain sites.

In addition, there is a section with federal and especially important regional news. So that editors can quickly publish news, an HTML editor with a preview is configured and customized in the administrative panel. A typology of news sections with markups and separation of access rights of editors has been designed.

After that, an array of old publications was transferred to the site - more than a million news stories that had accumulated over the years were dismantled and structured. Provided site multiregionality - each subdomain site displays unique content. Search by site was implemented through NoSQL solutions.

Performance

To optimize content loading and accelerate the work of animated blocks, webpack, versioning, cache busting technology was used. The automatic code delivery system (CI/CD) allows you to make changes to the site without downtime. The server part is optimized to withstand peak loads. A monitoring system has been implemented that records server metrics and analyzes traffic and loads on all system nodes.

Achieved result

• The portal of the United Russia party has been developed with a modern design and optimal database structure.
• Easy downloading of content and easy management in the administrative panel are implemented. Thousands of hours of work were saved for site editors across the country.
• The portal with high loads is provided even during peak traffic periods. According to load testing, the site withstands up to 300 requests per second, which provides up to 20,000 simultaneous users.