Author: Yuri Gagarin

We understand PostgreSQL query plans even better

Six months ago, we launched explain.tensor.ru — a public service for analyzing and visualizing SQL query plans for PostgreSQL. In the months that followed, we presented about it at PGConf.Russia 2020, prepared a summary article on speeding up SQL queries based on the recommendations it provides… but most importantly, we collected your feedback and observed real use cases. And now we are ready […]

Engaging Conversations: The Gboard Keyboard Has Added an Emoji Panel

Google has added a new feature to its Gboard keyboard for Android for emoji lovers. A whole new panel — Emoji Bar — has been added for accessing the most frequently used emojis, where users can find their favorite emoticons. Naturally, if the feature proves to be not very useful, or if the virtual keyboard takes up too much space, this panel can be hidden or reset. It seems that […]

Release of Wine 5.10

An experimental release of the open implementation of WinAPI — Wine 5.10 — has taken place. Since the release of version 5.9, 47 bug reports have been closed and 395 changes have been made. The most significant changes are: the development of the WineD3D backend based on the Vulkan graphics API has continued; an initial implementation of a separate shared Unix library (.so) for NTDLL has been provided; support for Windows kernel drivers from anti-cheat systems has been improved […]

The release of the Pale Moon browser 28.10 has occurred.

The release of the Pale Moon 28.10 web browser has been announced, a spin-off from the Firefox codebase aimed at ensuring greater efficiency, maintaining a classic interface, minimizing memory consumption, and providing additional customization options. Pale Moon builds are available for Windows and Linux (x86 and x86_64). The project's code is distributed under the MPLv2 (Mozilla Public License). The project adheres to a classic interface design, without […]

The support period for the LTS versions of the Linux kernels 5.4 and 4.19 has been extended to six years.

The support period for the LTS versions of the Linux kernels 5.4 and 4.19, maintained by Greg Kroah-Hartman and Sasha Levin, has been extended until December 2025 and 2024 respectively. The Linux kernel 4.19 is used in Debian 10, is considered by Google as the basis for the universal core of Android, and is supplied in the Android 10 platform, while the kernel 5.4 is used in Ubuntu […]

Wine 5.10

On June 5, Wine 5.10 was released. Wine is a compatibility layer for Windows applications with POSIX-compatible operating systems, translating Windows API calls into POSIX calls on the fly instead of emulating Windows logic like a virtual machine. In addition to over 47 fixes in the bug tracker, the new release includes: Ongoing development of the WineD3D backend on Vulkan. Work has begun on a separate UNIX library for NTDLL. Improved […]

Similarities and Differences Between Wi-Fi 6 and 5G

I often hear debates in both professional and casual circles about Wi-Fi 6 and 5G. Which is better? What’s the difference? By the time 5G arrives, Wi-Fi 6 may no longer be necessary. It reminds me of childhood arguments over pressing topics: Who is stronger, a whale or an elephant? Who is a stronger actor, Van Damme or Schwarzenegger? My kung-fu is stronger than your karate! I decided to share some brief theses […]

MikroTik in repeater mode — as simple as One-Two-Three

First, reset the router without creating a default configuration, for example, through the console. /system reset-configuration no-defaults=yes skip-backup=yes Second, use the auto-configuration command, which will set up the wireless interface to connect to the access point and create a virtual interface, a bridge interface, and add both (main and virtual) interfaces to the bridge ports. In the parameters, specify the wireless interface, Wi-Fi network name, and […]

Installing Debian on Netgear Stora

Recently, I came across this marvel: netgear ms 2000 — stora. I decided to immediately ditch the built-in OS and install Debian on the hard drive. The information available online is somewhat scattered, links have long since died, so I decided to update the installation process of Debian on stora. Those interested are welcome under the cut. The main source was […]

Fedora plans to provide the ability to build packages in Clang instead of GCC.

A change in the compiler application rules in the distribution for Fedora 33 is planned, under which the compiler for building packages can be selected based on the recommendations and preferences of the upstream project. Currently, Fedora strictly requires the use of GCC for building all packages, except in cases where a package can only be built in Clang/LLVM. […]

In Firefox, the ability to export saved passwords in CSV format will be available.

The codebase for the upcoming Firefox 78 release has included the ability to export saved credentials from the password manager in CSV format (text fields with delimiters that can be imported into a spreadsheet). There are also plans to implement a password import function from a previously saved CSV file (implying that the user may require backup and recovery of saved […]

Beta version release of Protox v1.5, a Tox client for mobile platforms.

A new version of the client for the decentralized Tox protocol (toktok) has been released. Currently, only Android OS is supported, but since the application is written using the cross-platform framework Qt, porting to other platforms is possible. The project's code is distributed under the MIT license. Application builds are distributed under the GPLv3 license. Change log: Avatars have been added. Support for streams for file transfers has been added, which […]

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