ProHoster > Articles on: Yuri Gagarin

Author: Yuri Gagarin

A technical specialist at ProHoster with over six years of experience in server administration, VPN solutions, and network security. I manage infrastructure setup and support, monitor service stability, and implement solutions to protect client data. I also contribute to performance optimization and compliance with modern security and privacy requirements.

A Study on Implementing Row Level Security in PostgreSQL

Posted on

As an addition to the study on implementing business logic at the level of PostgreSQL stored functions, and primarily as a detailed response to the comment. The theoretical part is well described in the Postgres Pro documentation — Row-Level Security Policies. Below is a practical implementation of a small specific business task — hiding deleted data. The study dedicated to the implementation of the Role-Based Model using RLS is presented […]

A Study on Implementing Business Logic at the Level of Stored Functions in PostgreSQL

Posted on

The motivating factor for writing this study was the article "During quarantine, the load increased 5 times, but we were ready." How Lingualeo transitioned to PostgreSQL with 23 million users. An article published 4 years ago — Implementing business logic in MySQL — also seemed interesting. It was intriguing that the same idea — 'to implement business logic in the database' — came up in […]

For Chrome, an API for direct TCP and UDP communications is being developed.

Posted on

Google has begun implementing a new Raw Sockets API in Chrome, allowing web applications to establish direct network connections using TCP and UDP protocols. In 2015, the W3C consortium attempted to standardize the "TCP and UDP Socket" API, but the working group members did not reach consensus, and the development of this API was halted. The need to add a new API […]

Public testing of the Firefox Relay anonymous email address service

Posted on

Mozilla has made the Firefox Relay service available for testing to all interested users. Previously, access to Firefox Relay was by invitation only, but now it is available to any user with a Firefox Account. Firefox Relay allows users to generate temporary email addresses for signing up on websites, helping to protect their real addresses. Users are allowed […]

Vulnerability in chrony

Posted on

A vulnerability (CVE-2020-14367) has been identified in chrony, the NTP protocol implementation used for synchronizing accurate time across various Linux distributions, which allows overwriting any file in the system with access to the local unprivileged chrony user. The vulnerability can only be exploited through the chrony user, which reduces its danger. However, the issue compromises the isolation level in chrony and can be utilized in […]

ELK SIEM Open Distro: Visualizing ELK and SIEM dashboards in ELK

Posted on

This post will describe the setup of information panel visualization for ELK and SIEM in ELK. The article is divided into the following sections: 1- Overview of ELK SIEM 2- Default dashboards 3- Creating your first dashboards. Table of contents for all posts. Introduction. Deployment of infrastructure and technologies for SOC as a Service (SOCasS) ELK stack — installation and configuration. A walk through open Distro […]

Post Mortem on Quay.io Downtime

Posted on

Note: In early August, Red Hat publicly addressed the availability issues that users of its Quay.io service experienced in the preceding months (the service is based on a container image registry that came to the company with the acquisition of CoreOS). Regardless of your interest in this service per se, the journey taken by the company's SRE engineers is informative […]

The new QNAP expansion card will empower the computer with two USB 3.2 Gen2 ports

Posted on

QNAP Systems has announced the QXP-10G2U3A expansion card designed for use in personal computers, workstations, and network-attached storage (NAS). The new card allows the system to be equipped with two USB 3.2 Gen2 Type-A ports. This interface provides a bandwidth of up to 10 Gbps. The card is based on the ASMedia ASM3142 controller. A PCIe Gen2 x2 slot is required for installation. It is said to be compatible with […]

Making the Linux terminal beautiful and convenient

Posted on

All Linux distributions come with a functional and customizable terminal emulator. There are plenty of ready-made themes on the internet, and sometimes even within the terminal itself, to make it look appealing. However, to transform the standard terminal (in any DE, of any distribution) into something beautiful yet convenient and easy to use, I spent a lot of time. So, how can we make the default […]

Overview of flexible data warehouse design methodologies

Posted on

Developing a data warehouse is a long and serious task. Much in the life of a project depends on how well thought out the object model and database structure are from the start. The common approach has been and remains a combination of the 'star' schema with the third normal form. Generally, the principle is: source data — 3NF, data marts — star. This approach, tried and tested over time, is backed by […]

Creating match-making for Dota 2014

Posted on

Hello everyone. This spring, I came across a project where the guys learned to run a 2014 version Dota 2 server and, accordingly, play on it. I am a big fan of this game and couldn't pass up the unique opportunity to dive into my childhood. I dove in very deeply, and it turns out that I wrote a Discord bot that responds to almost […]

« to the beginning 564 565 566 567 568 569 570 571 572 573 to the end »
Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster