ProHoster > Blog

Category: Blog

Blog Section

PostgreSQL Antipatterns: CTE x CTE

Posted on

In my line of work, I often encounter situations where a developer writes a query and thinks, "the database is smart, it will handle everything!" In some cases (partly due to a lack of knowledge about the capabilities of the database, partly due to premature optimizations), this approach leads to the creation of "Frankensteins." First, I will provide an example of such a query: — for each key pair, we find the associated field values WITH RECURSIVE cte_bind AS […]

Introducing the programmable AWS Landing Zone in the Terraform module

Posted on

Hello everyone! In December, OTUS is launching a new course - Cloud Solution Architecture. In anticipation of this course, we are sharing an interesting material on the topic. AWS Landing Zone is a solution that helps customers quickly set up a secure AWS environment with multiple accounts based on best practices. For more than five years, we have been […]

Release of Qt for MCUs 1.0, the Qt5 edition for microcontrollers.

Posted on

The Qt project has released the first stable version of Qt for MCUs 1.0, a version of the Qt 5 framework for microcontrollers and low-power devices. The package allows developers to create graphical user interface applications similar to smartphone interfaces for various consumer electronics, wearables, industrial equipment, and smart home systems. Development is done using the familiar API and standard developer tools used […]

Release of NomadBSD 1.3 distribution

Posted on

The release of the Live distribution NomadBSD 1.3 is now available, which is a FreeBSD edition adapted for use as a portable desktop bootable from a USB drive. The graphical environment is based on the Openbox window manager. DSBMD is used for mounting drives (supporting mounting of CD9660, FAT, HFS+, NTFS, Ext2/3/4), wifimgr is used for wireless network configuration, and DSBMixer is used for volume control. The size of the boot image is 2.3 […]

Release of the Pale Moon browser 28.8.0

Posted on

The release of the web browser Pale Moon 28.8 has been introduced, which forks from the Firefox codebase to provide higher performance, maintain the classic interface, minimize memory usage, and offer additional customization options. Pale Moon builds are created for Windows and Linux (x86 and x86_64). The project's code is distributed under the MPLv2 license (Mozilla Public License). The project adheres to a classic interface organization, without […]

The new version of the Edge browser has launched collections for all users.

Posted on

Microsoft has announced that the Collections feature is now available to all users of the Edge browser on the Canary and Dev channels. This feature allows users to collect, organize, export, and share content from the Internet, resembling an advanced version of bookmarks. Previously, the company tested the innovation with a limited group of users, but it is now adding it for everyone. New features include collection synchronization, header editing, and support […]

How to use MySQL without a password (and security risks)

Posted on

It is said that the best password is one that you don’t have to remember. In the case of MySQL, this is made possible thanks to the auth_socket plugin and its version for MariaDB — unix_socket. Both of these plugins are not new, and there has been much discussion about them in this blog, for example in an article on changing passwords in MySQL 5.7 using the auth_socket plugin. […]

True channel aggregation of internet connections — OpenMPTCPRouter

Posted on

Is it possible to combine multiple Internet channels into one? There are many misconceptions and myths surrounding this topic, and even experienced network engineers often do not know that it is possible. In most cases, what is mistakenly referred to as channel aggregation is actually NAT-level load balancing or failover. However, true summation allows a single TCP connection to simultaneously use all Internet channels, such as in video streaming […]

How to connect to a corporate VPN in Linux using openconnect and vpn-slice

Posted on

Do you want to use Linux at work, but the corporate VPN doesn't allow it? This article might help, although it's not guaranteed. I want to warn you in advance that I have a limited understanding of network administration, so it's possible I did everything wrong. On the other hand, I might be able to write a guide that's understandable for regular people, like […]

Release of the Lustre 2.13 clustered FS

Posted on

The release of the Lustre 2.13 clustered file system has been published, which is used in the majority (~60%) of the largest Linux clusters containing tens of thousands of nodes. Scalability in such large systems is achieved through a multi-component architecture. The key components of Lustre include metadata processing and storage servers (MDS), management servers (MGS), object storage servers (OSS), object storage (OST, supported to work over ext4 and ZFS), and clients. […]

Microsoft will soon cease support for Office on Windows 10 Mobile

Posted on

In the coming days, Windows 10 Mobile will receive its final updates, and Microsoft is preparing to completely discontinue support for the mobile OS. This is partly reflected in the abandonment of support for other applications. Reportedly, Word, Excel, PowerPoint, and OneNote for the mobile system will no longer receive security updates, non-security fixes, free assisted support, or new […]

My implementation of a ring buffer in NOR flash

Posted on

Background There are self-developed vending machines. Inside are Raspberry Pi and some additional circuitry on a separate board. They are connected to a coin acceptor, a bill validator, and a banking terminal… Everything is controlled by custom software. All operation history is written to a log on a flash drive (MicroSD), which is then transmitted via the internet (using a USB modem) to a server, where it is stored in a database. Sales information is uploaded to 1C, and there is also […]

« to the beginning 879 880 881 882 883 884 885 886 887 888 to the end »
Buy reliable website hosting with DDoS protection, VPS VDS servers 🔥 Buy reliable website hosting with DDoS protection, VPS VDS servers | ProHoster