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. […]
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 […]
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 […]
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 […]
A study conducted on the portal BSD-Hardware.info indicates that hardware support in FreeBSD is not as poor as commonly claimed. The evaluation took into account that not all hardware on the market is equally popular. There are widely used devices that need support, and there are rare devices whose owners can be counted on one hand. Accordingly, the weight of each individual device in the assessment was considered […]
One of the common types of attacks is the spawning of a malicious process within a tree of otherwise legitimate processes. Suspicion may arise from the path to the executable file: malware often uses AppData or Temp folders, which is uncharacteristic of legitimate programs. Fairness dictates noting that some automatic update utilities run in AppData, so merely checking the location […]
The release of the Pale Moon 28.12 web browser has occurred, which branched from the Firefox codebase to ensure higher performance, maintain a classic interface, minimize memory consumption, and provide additional customization features. Pale Moon builds are created for Windows and Linux (x86 and x86_64). The project code is distributed under the MPLv2 license (Mozilla Public License). The project adheres to a classic interface organization, without […]
Riak CS (Cloud Storage) is user-friendly software for organizing object storage, built on top of Riak KV. Riak (KV) is a distributed NoSQL key-value database. Riak CS is designed to provide simplicity, availability, and distribution of cloud storage at any scale, and can be used for building cloud architectures — both public and private — or […]
Using Istio+Kiali for Running and Visualizing a Canary Deployment Articles in this series Canary Deployment in Kubernetes #1: Gitlab CI Canary Deployment in Kubernetes #2: Argo Rollouts (this article) Canary Deployment using Jenkins-X Istio Flagger Canary Deployment We hope you read the first part, where we briefly explained what Canary deployments are and showed how to implement it with […]
According to research by HeadHunter and Mail.ru, the demand for specialists in the field of Data Science exceeds supply, yet even so, young professionals do not always manage to find a job. We explain what graduates of courses lack and where to learn for those planning a significant career in Data Science. "They come in thinking they will earn 500k a second just because they know […]
Christoph Hellwig, a well-known Linux kernel developer and former member of the governing technical committee of the Linux Foundation, who was a plaintiff in a GPL-related lawsuit against VMware, has proposed to tighten protections against the binding of proprietary drivers to Linux kernel components exported only for GPL-licensed modules. To circumvent the limitation on exporting GPL symbols, producers […]
The release of the open-source platform for deploying decentralized social networks—Mastodon 3.2—has been announced, allowing users to create services on their own infrastructure that are not controlled by individual providers. If a user cannot launch their own node, they can choose a trustworthy public service for connection. Mastodon falls into the category of federated networks, where a set of […] is used to form a unified structure of connections.