Author: Yuri Gagarin

The release of the free office suite LibreOffice 7.0.

The Document Foundation has announced the release of the LibreOffice 7.0 office suite. Ready-to-use installation packages have been prepared for various Linux distributions, Windows, and macOS, as well as an edition for deploying the online version in Docker. In preparing the release, 74% of the changes were made by employees from companies that oversee the project, such as Collabora, Red Hat, and CIB, while 26% of the changes were added by independent enthusiasts. Key innovations: […]

A New Look at the Clouds. What is a Private Cloud?

The growth of computing power and the development of x86 virtualization technologies on one hand, and the spread of IT outsourcing on the other, have led to the concept of utility computing (IT as a utility service). Why not pay for IT just like we do for water or electricity – precisely as much and precisely when it's needed, and not more. At this moment […]

The first update of Windows Package Manager Preview (v0.1.41821) has been released.

We present the first update for Windows Package Manager. If you are a participant of the Windows Insider or Package Manager Insider program, you should already have the latest updates installed. If you are an insider and do not have them, launch the store and check for updates. If you would prefer to simply download the client, go to the releases page at […]

Firefox has begun enabling tracking protection against redirects.

Mozilla has announced its intention to activate the Enhanced Tracking Protection (ETP) 2.0 mechanism. Initially, support for ETP 2.0 was added in Firefox 79 but was disabled by default. In the coming weeks, this mechanism is set to be rolled out to all user categories. The main innovation of ETP 2.0 is the addition of protection against tracking through redirects. To bypass […]

The composite server Wayfire 0.5 using Wayland is available

The release of the composite server Wayfire 0.5 has taken place, utilizing Wayland and allowing for the creation of resource-light user interfaces with 3D effects in the style of 3D plugins for Compiz (switching screens through a 3D cube, spatial window layout, morphing while working with windows, etc.). Wayfire supports extension through plugins and provides a flexible configuration system. The project code is written in C++ and is distributed […]

Release of BSD Router Project 1.97

Olivier Cochard-Labbé, the creator of the FreeNAS distribution, has presented the release of the specialized BSD Router Project 1.97 (BSDRP), notable for updating the codebase to FreeBSD 12.1. The distribution is designed for creating compact software routers that support a wide range of protocols such as RIP, OSPF, BGP, and PIM. Management is performed via a command-line interface resembling Cisco's CLI. The distribution is available in builds […]

Release of LibreOffice 7.0

The Document Foundation announced the release of the LibreOffice 7.0 office suite. You can download it using the link. This release highlights the following innovations: Writer Implemented extended list numbering. Numbering types available: [0045] [0046] Bookmarks and fields can be protected from changes Enhanced text rotation management in tables Implemented the ability to create semi-transparent fonts Bookmarks in the text are highlighted […]

How Google BigQuery Democratized Data Analysis. Part 1

Hello, Habr! Right now, OTUS is accepting applications for a new cohort of the 'Data Engineer' course. Ahead of the course start, we have traditionally prepared a translation of interesting material for you. Every day, over one hundred million people visit Twitter to find out what is happening in the world and discuss it. Every tweet and any other user action generates an event available internally […]

PostgreSQL Antipatterns: 'There Can Be Only One!'

In SQL, you describe 'what' you want to get, not 'how' it should be executed. Thus, the problem of developing SQL queries in a 'as it sounds, so it is written' style takes its honorable place, alongside the peculiarities of condition evaluation in SQL. Today, through very simple examples, we will look at what this can lead to in the context of using GROUP/DISTINCT and LIMIT together with them. […]

PostgreSQL Antipatterns: condition evaluation in SQL

SQL is not C++ or JavaScript. Therefore, the evaluation of logical expressions occurs differently, and this is not the same: WHERE fncondX() AND fncondY() = fncondX() && fncondY(). In the process of optimizing the execution plan of the query, PostgreSQL can arbitrarily 'rearrange' equivalent conditions, not evaluate some of them for individual records, relating to […]

Fedora 33 will start shipping an official edition for the Internet of Things

Peter Robinson from the Red Hat Release Engineering Team posted a proposal to accept a version of the distribution for the Internet of Things as one of the official editions of Fedora 33. Thus, starting with Fedora 33, Fedora IoT will be shipped alongside Fedora Workstation and Fedora Server. The proposal has not yet been officially approved, but its publication was preliminarily agreed upon in […]

Distributions have resolved issues with GRUB2 updates

The main Linux distributions have formed a corrective update for the GRUB2 bootloader package, addressing issues that arose after the BootHole vulnerability was patched. After the installation of the first update, some users encountered the inability to boot their systems. Boot issues occurred on some systems with BIOS or UEFI in 'Legacy' mode and were caused by regression changes that, in certain situations, led to crashes in […]

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