Author: ProHoster

Release of LibreOffice 7.0

The Document Foundation announced the release of the office suite LibreOffice 7.0. You can download it from this link. This release features the following innovations: Writer Extended numbering of lists has been implemented. Numbering of the form is now available: [0045] [0046] Bookmarks and fields can be protected from changes Improved control of text rotation in tables The ability to create a translucent font has been implemented Bookmarks in the text are highlighted [...]

How Google's BigQuery democratized data analysis. Part 1

Hey Habr! Right now, OTUS is open to enrollment for a new stream of the Data Engineer course. In anticipation of the start of the course, we have traditionally prepared a translation of interesting material for you. Every day, over a hundred million people visit Twitter to find out what's going on in the world and discuss it. Every tweet and every other user action generates an event available to the internal […]

PostgreSQL Antipatterns: "There must be only one!"

In SQL, you describe "what" you want to get, not "how" it should be done. Therefore, the problem of developing SQL queries in the style of "as it is heard is how it is written" takes its place of honor, along with the peculiarities of calculating conditions in SQL. Today, using extremely simple examples, let's see 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++, nor is it JavaScript. Therefore, the evaluation of logical expressions is different, and this is not the same thing at all: WHERE fncondX() AND fncondY() = fncondX() && fncondY() In the process of optimizing the execution plan of a query, PostgreSQL can arbitrarily "rearrange" the equivalent conditions, do not calculate any of them for individual records, refer to […]

Rumors: Apple is seriously interested in buying TikTok

As you know, US President Donald Trump said on Monday that the country's government will block the operation of the Chinese video service TikTok in the United States if no American company acquires it by September 15. The situation has developed this way due to tense relations between the governments of the United States and China. As it became known earlier, its interest in purchasing [...]

Google has trouble buying Fitbit as EU launches full-scale antitrust investigation

The $2,1 billion acquisition by Google, part of the Alphabet holding, of the manufacturer of wearable devices for monitoring physical activity Fitbit, raised questions in the European Union. The answers are expected to be found in a large-scale antitrust investigation officially announced by the European Commission on Tuesday. The investigation will last four months and should be completed by December 9. This announcement was preceded by a preliminary review of the circumstances [...]

Fedora 33 will ship an official IoT edition

Peter Robinson of the Red Hat Release Engineering Team has published a proposal to accept the Internet of Things distribution as an official edition of Fedora 33. Thus, starting with Fedora 33, Fedora IoT will be shipped along with Fedora Workstation and Fedora Server. The proposal has not yet been officially approved, but its publication was previously agreed upon […]

Distributions fix GRUB2 update issues

Major Linux distributions have compiled a corrective update to the GRUB2 bootloader package to address issues that arose after the BootHole vulnerability was fixed. After installing the first update, some users experienced the inability to boot their systems. Booting issues have occurred on some systems with BIOS or UEFI in Legacy mode, and have been caused by retrogressive changes, causing […]

FreeBSD 13-CURRENT supports at least 90% of the popular hardware on the market

A study from BSD-Hardware.info suggests that FreeBSD's hardware support is not as bad as people say. The assessment took into account that not all equipment on the market is equally popular. There are widely used devices that require support, and there are rare devices whose owners can be counted on one hand. Accordingly, the weight of each individual device was taken into account in the assessment [...]

QVGE 0.6.0 release (visual graph editor)

The next release of Qt Visual Graph Editor 0.6, a multi-platform visual graph editor, has taken place. The main area of ​​application of QVGE is the “manual” creation and editing of small graphs as illustrative materials (for example, for articles), creation of diagrams and quick workflow prototypes, input-output from open formats (GraphML, GEXF, DOT), saving images in PNG /SVG/PDF, etc. QVGE is also used for scientific purposes […]

The ups and downs of the San Francisco construction industry. Trends and development history of construction activity

This series of articles is devoted to the study of the construction activity of the main city of Silicon Valley - San Francisco. San Francisco is the technological “Moscow” of our world, on the example of which (with the help of open data) one can observe the development of the construction industry in large cities and capitals. Plotting and calculations were carried out in Jupyter Notebook (on the Kaggle.com platform). Data on more than a million permits for […]