Author: ProHoster

Release of the free 3D modeling system Blender 2.83

Introduced the release of the free 3D modeling package Blender 2.83, which includes more than 1250 fixes and improvements in the three months since the release of Blender 2.82. The main attention in preparing the new version was focused on optimizing performance - the work of undo, sketch pencil and rendering preview has been accelerated. Support for adaptive sampling has been added to the Cycles engine. Added new sculpting tools […]

VirtualBox 6.1.10 release

Oracle has published a corrective release of the VirtualBox 6.1.10 virtualization system, which contains 7 fixes. Major changes in release 6.1.10: In additions for guest systems and in the host environment, support for the Linux 5.7 kernel is provided; In the settings when creating new virtual machines, audio inputs and outputs are disabled by default; Guest Additions now handle resizing […]

Valve has released Proton 5.0-8, a package for running Windows games on Linux

Valve has published the release of the Proton 5.0-8 project, which is based on the developments of the Wine project and is aimed at enabling gaming applications created for Windows and presented in the Steam catalog to run on Linux. The developments of the project are distributed under the BSD license. Proton allows you to directly run Windows-only game applications on the Steam Linux client. The package includes a DirectX implementation […]

Deep dive into PostgreSQL internal statistics. Alexey Lesovsky

Transcription of the 2015 report by Alexey Lesovsky "Deep dive into PostgreSQL internal statistics" Disclaimer from the author of the report: I note that this report is dated November 2015 - more than 4 years have passed and a lot of time has passed. Version 9.4 discussed in the report is no longer supported. Over the past 4 years, 5 new releases have been released in which a lot of innovations, improvements […]

Understanding PostgreSQL query plans even more conveniently

Six months ago, we introduced explain.tensor.ru, a public service for parsing and visualizing query plans for PostgreSQL. Over the past months, we made a report about it at PGConf.Russia 2020, prepared a general article on speeding up SQL queries based on the recommendations it gives... but most importantly, we collected your feedback and looked at real use cases. And now we're ready […]

Recipes for Sick SQL Queries

A few months ago, we announced explain.tensor.ru, a public service for parsing and visualizing query plans for PostgreSQL. You've used it over 6000 times since then, but one handy feature that might have gone unnoticed is the structural cues that go something like this: Listen to them and your queries will "get silky smooth." 🙂 And […]

Video: Ninja Simulator lets you feel like a ninja on PC

RockGame has introduced a new action-adventure game with stealth elements called Ninja Simulator. As the name suggests, this PC project will put players in the role of a ninja hired for missions to infiltrate enemy lairs, spy and assassinate targets. According to the description, the player's actions will strengthen or overthrow rival clans in order to change the course of history. […]

Boring correspondence: the Gboard keyboard has got a panel for emoticons

Google has added a new feature to its Gboard keyboard for Android for those who love emojis. To access the most frequently used emoticons, a whole new panel has been added - Emoji Bar, where users will find their favorite emoticons. Of course, if the function turns out to be not very useful, or the virtual keyboard takes up too much space, this panel can be hidden or reset. It seems, […]

Fallen God expansion for SpellForce 3: endangered trolls resurrect a fallen deity...

Publisher THQ Nordic and studio Grimlore Games have unveiled a new Fallen God expansion for SpellForce 3, their mix of real-time strategy and RPG. It will be independent, will be released this year and will be dedicated to a new gaming faction - trolls. According to the description, a small tribe of nomadic trolls under the leadership of the young leader Akrog advances through the continent of Urgath, seeking only […]

LG 27QN880 QHD monitor attached to the edge of the table

LG has expanded its family of monitors by introducing the 27QN880 model on a high-quality IPS matrix measuring 27 inches diagonally. The new product has a QHD resolution (2560 × 1440 pixels) and provides 99% coverage of the sRGB color space. The main feature of the panel is a special Ergo Stand, with which the device is attached to the edge of the table. This allows you to minimize the space occupied by the monitor and free up additional […]

Dyson shares new photos and video of canceled electric car

Tycoon James Dyson, best known for his high-end vacuum cleaners, has revealed new photos and shared more information about his company's failed electric car project. He spent more than half a billion dollars of his own money on this idea. In a new post on his company's official blog, Mr. Dyson showed the first images of a real prototype taken before the project […]