Category: Blog

How to explain the difference between SQL and NoSQL to your grandma

One of the most important decisions a developer makes is which database to use. For many years, options were limited to various types of relational databases that supported Structured Query Language (SQL). These include MS SQL Server, Oracle, MySQL, PostgreSQL, DB2, and many others. In the last 15 years, many new […]

Cross-replication between PostgreSQL and MySQL

I will broadly discuss cross-replication between PostgreSQL and MySQL, as well as methods for configuring cross-replication between these two database servers. Typically, databases in cross-replication are referred to as homogeneous, and this is a convenient method for transitioning from one relational DBMS server to another. PostgreSQL and MySQL databases are considered relational, but […]

Project to add support for parallel compilation processes in GCC

As part of the Parallel GCC research project, work has begun on adding the capability to GCC that allows the compilation process to be divided into multiple concurrently executing threads. Currently, to increase build speed on multi-core systems, the make utility launches separate compiler processes, each of which compiles an individual source file. The new project experiments with providing […]

The XY Phenomenon: How to Avoid 'Incorrect' Problems

Have you ever wondered how many hours, months, and even lives have been wasted on solving the "wrong" problems? Once, some people started complaining about having to wait unbearably long for the elevator. Other people were concerned about these complaints and spent a lot of time, effort, and money trying to improve elevator operation and reduce wait times. But […]

Varlink – core interface

Varlink is a core interface and protocol that is easy to read by both humans and machines. The Varlink interface combines traditional UNIX command-line parameters, text formats for STDIN/OUT/ERROR, man pages, service metadata, and is equivalent to file descriptor FD3. Varlink is accessible from any programming environment. The Varlink interface defines the methods that will be implemented and how. Each […]

A new version of the exFAT driver has been proposed for the Linux kernel.

Korean developer Park Ju Hyung, specializing in porting Android firmware for various devices, has introduced a new version of the exFAT file system driver — exfat-linux, which is a fork of the "sdFAT" driver developed by Samsung. Currently, the exFAT driver from Samsung has already been added to the Linux kernel's staging branch, but it is based on the old driver codebase (1.2.9). […]

pg_stat_statements + pg_stat_activity + loq_query = pg_ash?

As a brief addition to the article Attempt to Create an ASH Analog for PostgreSQL. Task: It is necessary to link the history of pg_stat_statements and pg_stat_activity. As a result, using the execution plan history from the service table log_query, you can obtain a wealth of useful information for resolving performance incidents and optimizing queries. Warning: Due to ongoing testing and development, the article is not […]

The alpha version of the new XMPP server Xabber Server has been released

The developers of the XMPP client Xabber have released their own XMPP server based on a fork of ejabberd. The project code is distributed under the AGPLv3 license. Key features of Xabber Server include: Fast installation that allows you to automatically set up the server and configure all the necessary certificates; A new group chat protocol; Editing, deleting, and recalling messages; A quick client synchronization feature; A reliable message delivery protocol; Session management (the ability to log out (revoke the right […]

F9sim 1.0 — Falcon 9 First Stage Simulator

Reddit user u/DavidAGra (David Jorge Aguirre Gracio) has introduced the first version of his own rocket flight simulator – 'F9sim' 1.0. Currently, this is a free simulator written in Delphi using OpenGL technologies, but the project author is considering opening the source code and rewriting the project's code in C++/Qt5. The original goal of the project is to create a realistic 3D simulation of the flight of the first stage of a launch vehicle […]

Release of the Funtoo 1.4 distribution, developed by the founder of Gentoo Linux

Daniel Robbins, the founder of the Gentoo distribution who stepped away from the project in 2009, has presented the release of his now developed distribution Funtoo 1.4. Funtoo is based on the Gentoo package base and aims to further improve existing technologies. Work on the release of Funtoo 2.0 is planned to begin in about a month. Key features of Funtoo include support for automatic package building […]

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