Author: Yuri Gagarin

PostgreSQL Antipatterns: hitting the dictionary with a heavy JOIN

We continue our series of articles dedicated to exploring lesser-known ways to enhance the performance of seemingly simple queries in PostgreSQL: a rare entry will make it halfway through JOIN Sisyphus JOIN arrays harmful JOIN and OR CTE JOIN CTE. Don’t think I dislike JOIN that much… 🙂 But often, without it, the query is significantly more efficient than with it. So today, let’s try […]

The DDoS protection company admitted that it itself launched DDoS attacks, acknowledged its founder.

By 2016, vDos became the most popular service in the world for ordering DDoS attacks. If conspiracy theories are to be believed, antivirus companies themselves spread viruses, while DDoS protection services initiate these attacks themselves. Of course, this is just fiction… or is it? On January 16, 2020, the Federal District Court of New Jersey found 22-year-old Tucker Preston, a resident of Macon, […]

Intel has joined the CHIPS Alliance and gifted the world the Advanced Interface Bus.

Open standards are gaining more supporters. IT giants are not only forced to reckon with this phenomenon but also to give their unique developments to open communities. A fresh example is Intel's transfer of the AIB bus to the CHIPS Alliance. This week, Intel became a member of CHIPS Alliance (Common Hardware for Interfaces, Processors, and Systems). As derived from the acronym CHIPS, […]

A new ranking of the best antivirus programs for Windows 10 has been published.

AV-Test provided the results of testing the best antivirus programs for Windows. The site published a ranking for December 2019, showcasing the advantages of various protective applications. According to the published data, almost all antivirus programs provide a similar level of protection. The 'problematic' ones were eScan ISS and Total AV with 4.5 and 4 points respectively. The other solutions provided 5 and […]

The TrafficToll 1.0.0 utility for selective traffic limitation of applications has been released.

The TrafficToll 1.0.0 utility has been released, positioned as a Linux alternative to the proprietary NetLimiter program for Windows. This program simplifies the process of setting bandwidth limits for individual local applications as well as already running processes. For instance, it allows you to reduce the bandwidth for a download manager while increasing it for a video chat. Settings are defined in a simple configuration text file. Incoming and outgoing traffic limits are applied at […]

L1DES (CacheOut) and VRS — new vulnerabilities in the microarchitectural structures of Intel CPUs.

Intel has disclosed information about two new vulnerabilities in Intel CPUs, caused by data leakage from the L1D cache (CVE-2020-0549, L1DES — L1D Eviction Sampling) and vector registers (CVE-2020-0548, VRS — Vector Register Sampling). These vulnerabilities belong to the MDS (Microarchitectural Data Sampling) class and are based on the application of side-channel analysis methods to data in microarchitectural structures. AMD […]

Creating a fault-tolerant IT infrastructure. Part 2. Installation and configuration of the oVirt 4.3 cluster

This article is a continuation of the previous one – "Creating a Resilient IT Infrastructure. Part 1 – Preparing for the Deployment of the oVirt 4.3 Cluster." It will cover the process of basic installation and configuration of the oVirt 4.3 cluster for hosting highly available virtual machines, given that all preliminary steps for infrastructure preparation have already been completed. Introduction The main goal of this article is to […]

Understanding eSIM (+ interview with an expert)

Let's talk about eSIM (the full name embeddedSIM — that is, embedded SIM) — SIM cards soldered into gadgets (unlike the usual removable SIM cards). We'll discuss how they are better than traditional SIM cards and why major mobile operators are resisting the adoption of this new technology. This article is written with support from EDISON. We develop applications for Android and iOS, and we can also take on […]

Working with IPv6 in PHP

Recently, we received LIR status and a /29 block of IPv6. Following this, the need arose to keep track of assigned subnets. And since our billing system is written in PHP, we had to delve into the matter and realize that this language is not the most user-friendly for working with IPv6. Below, we present our solutions for the tasks concerning addresses and […]

LTS versions of Qt will only be available under a commercial license.

The Qt Company has announced changes to the licensing model of the Qt framework, which may have a significant impact on communities and distributions using Qt. Starting with version 5.15, LTS branches of Qt will be supported until the next major release is formed, i.e., for approximately six months (updates for LTS branches are issued for three years). This move is expected to accelerate the adoption of new branches and increase the number of […]

The "Dungeons and Dragons" desktop helped me learn English

In this article, we will tell the story of one of the employees at EnglishDom, who learned English through a rather unusual method — role-playing Dungeons & Dragons. Here and below, we present his story nearly unchanged. We hope you enjoy it. First, let me tell a little about Dungeons & Dragons for those who are hearing about this game for the first time. To summarize, […]

Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster