Category: Blog

PostgreSQL Antipatterns: harmful JOINs and OR

Beware of operations that bring buffers… We will look at some universal approaches to optimizing queries in PostgreSQL through a simple example. Whether to use them or not is up to you, but it's worth knowing about them. In some subsequent PG versions, the situation may change with a "smarter" planner, but for versions 9.4/9.6, it looks pretty much the same, as shown in these examples. Let’s take a quite realistic query: SELECT […]

Kubernetes 1.17: Overview of Key Innovations

On December 9, the latest release of Kubernetes—version 1.17—was announced. Following the traditions of our blog, we will discuss the most significant changes in the new version. The information used to prepare this material was sourced from the official announcement, the Kubernetes enhancements tracking table, CHANGELOG-1.17, and relevant issues, pull requests, as well as Kubernetes Enhancement Proposals (KEP). So, what’s new?.. Routing with […]

Yesterday, December 9, there was another Kubernetes release — 1.17.

Studying the history of disks is the starting point for understanding the principles of solid-state drives. The first part of our "Introduction to SSD" article series will provide a historical overview and allow for a clear comparison between SSDs and their closest competitor, HDDs. Despite the variety of information storage devices available, the popularity of HDDs and SSDs today is undeniable. The difference between […]

RAR Archiver 5.80

The release of the proprietary archiver RAR version 5.80 has occurred. Changes in the console version include: You can preserve the last access time of archived files using the -tsp option in the command line. This option can be combined with other options -ts, for example: rar a -tsc -tsp archive files. In the same -ts option, multiple modifiers can be combined. For example, -tscap can be used […]

AMD does not rule out the idea of supporting four threads with one processor core

The technical director of AMD claims that the company has not expressed any intentions to implement support for four threads on one core in future processors. The idea of SMT4 is not so premature — much in this area depends on the availability of software capable of realizing the advantages of multithreading in such a variant. For example, IBM has long offered server processors supporting such a number […]

Comparison of Performance of Unblocking Tools

As access to various resources on the internet is increasingly restricted, the question of how to circumvent these blocks becomes more relevant. Thus, the question of 'How can we bypass restrictions more quickly?' is more pertinent. We will leave the topic of effectiveness regarding DPI white/blacklist circumvention for another time and simply compare the performance of popular circumvention tools. Note: The article discusses […]

Creating a Discord bot on .NET Core with deployment on a VPS server

Hello, Habr readers! Today you will learn about how to create a bot using C# on .NET Core and how to run it on a remote server. The article will consist of background information, preparatory steps, writing logic, and transferring the bot to a remote server. I hope this article will help many beginners. Background It all started one sleepless […]

We present the equation of linear regression in matrix form.

The purpose of this article is to support beginner data scientists. In the previous article, we explained three ways to solve the linear regression equation: analytical solution, gradient descent, and stochastic gradient descent. For the analytical solution, we applied a formula. In this article, as indicated by the title, we will justify the use of this formula or, in other words, derive it ourselves. Why does it have […]

Firefox Preview 3.0 browser is available for Android

Mozilla has released the third significant version of the experimental browser Firefox Preview, developed under the codename Fenix. This version will soon be available in the Google Play Store (requires Android 5 or newer). The code is available on GitHub. The first stable release is expected in the first half of 2020. After the project stabilizes and all planned features are implemented, the browser will replace […]

Release of the new stable branch Tor 0.4.2.

The release of Tor 0.4.2.5 toolkit, used to organize the work of the Tor anonymous network, has been announced. Tor 0.4.2.5 is recognized as the first stable release of the 0.4.2 branch, which has been in development for the past four months. Updates for older branches 0.4.1.7, 0.4.0.6, and 0.3.5.9 have also been proposed. The 0.4.2 branch will be supported within the regular maintenance cycle — updates will cease after 9 months or after 3 […]

A 'paper' fiber optic has been created, which will revolutionize the world of humidity sensors

Some time ago, a study by Finnish scientists was published in the journal Cellulose, detailing the creation of optical fibers from cellulose. The idea of creating light-conducting fiber structures first took shape in 1910. Many decades later, fiber optic cables became an everyday reality and an indispensable means of energy-efficient information transmission over thousands of kilometers. The optical fiber created by Finnish scientists from cellulose is not suitable […]

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