Author: ProHoster

Smartphone Samsung Galaxy S11 will receive a "leaky" display

Online sources have obtained a new piece of information about the Galaxy S11 series smartphones, which Samsung will announce next year. If you believe the blogger Ice universe, who has previously repeatedly provided accurate data about upcoming new products from the mobile world, the devices are being designed under the code name Picasso. It is alleged that smartphones will be supplied to the market with the Android Q operating system, […]

Optimization of database queries on the example of a B2B service for builders

How to grow 10 times the number of queries to the database without moving to a more productive server and maintain system functionality? I will tell you how we dealt with the decline in the performance of our database, how we optimized SQL queries to serve as many users as possible and not increase the cost of computing resources. I am making a service for managing business processes [...]

An overview of the free tool SQLIndexManager

As you know, indexes play an important role in a DBMS, providing a quick search to the required records. That’s why it’s so important to service them in a timely manner. Quite a lot of material has been written about analysis and optimization, including on the Internet. For example, this topic was recently reviewed in this publication. There are many paid and free solutions for this. For example, there is […]

How pod priorities in Kubernetes caused downtime at Grafana Labs

Note trans.: We present to your attention technical details about the reasons for the recent downtime in the cloud service maintained by the creators of Grafana. This is a classic example of how a new and seemingly extremely useful feature designed to improve the quality of infrastructure... can cause harm if you do not provide for the numerous nuances of its application in the realities of production. It’s great when materials like this appear that allow you to learn not only [...]

Microsoft may improve Windows 10 Pro for PC enthusiasts

At one time, there were rumors that Microsoft was preparing a build of Windows 10 Home Ultra for enthusiasts. But these turned out to be just dreams. There is still no special version. But, as expected, it may appear in the Windows 10 Pro edition. The Pro version fills the gap between Windows 10 Enterprise and Windows 10 Home, but is more focused on system […]

EA CEO announces major Apex Legends event

Electronic Arts CEO Andrew Wilson announced a new major in-game event in Apex Legends. He made the statement during the company's report for the first quarter of the current fiscal year. The event will take place in the next few weeks, before the start of the third gaming season. Details have not yet been announced. Wilson said that the success of the second season of Apex legends exceeded all expectations. He […]

The power of rock in We Happy Few: Lightbearer launch trailer

In April, Gearbox Publishing and Compulsion Games unveiled the first addition, Roger & James in They Came from Below, to the We Happy Few adventure. It immersed players in a completely new story from the life of deliriously happy Wellington Wells, created with humor in the spirit of 1960s science fiction. Now it's time for the second of three DLCs promised as part of the season pass […]

Piranha Games explained the reason for the transfer of MechWarrior 5: Mercenaries to the Epic Games Store

It was recently announced that MechWarrior 5: Mercenaries has become a limited-time Epic Games Store exclusive. Fans, as expected, were outraged, but Piranha Games studio president Russ Bullock revealed the reason for this decision on Reddit. The president of Piranha Games wants to dispel misconceptions that the agreement with Epic Games was concluded due to greed. According to Bullock, he feels that […]

Progress MS-11 cargo spacecraft left the ISS

The Progress MS-11 cargo spacecraft undocked from the International Space Station (ISS), as reported by the online publication RIA Novosti with reference to information received from the Central Research Institute of Mechanical Engineering (FSUE TsNIIMash) of the state corporation Roscosmos. The Progress MS-11 apparatus, we recall, went into orbit in April of this year. The “Truck” delivered over 2,5 tons of various cargo to the ISS, including equipment […]

YubiKey touch detector

This is a tool that will tell you when the YubiKey is waiting for the user to touch it for authorization. Integrates with the UI to display an indicator. YubiKey may require physical touch to confirm the following operations: sudo command (via pam-u2f) gpg --sign gpg --decrypt ssh to a remote host (and related commands like scp, rsync, etc.) ssh from one remote host to [ …]

Valve releases Proton 4.11, a suite for running Windows games on Linux

Valve has published a new branch of the Proton 4.11 project, based on the work of the Wine project and aimed at ensuring the launch of gaming applications created for Windows and presented in the Steam catalog on Linux. The project's developments are distributed under the BSD license. As they are ready, the changes developed in Proton are transferred to the original Wine and related projects, such as DXVK and vkd3d. […]

xrdesktop project for using GNOME and KDE in VR headsets

Developers from Collabora presented the xrdesktop project, within which, with the support of Valve, they are developing a library with elements for interacting with traditional desktops inside three-dimensional environments formed using 3D glasses and virtual reality helmets. The library code is written in C and is distributed under the MIT license. Ready builds are prepared for Arch Linux and Ubuntu 19.04/18.04. […]