Development

We continue our series of articles reviewing changes in PostgreSQL 19. This time we'll look at what emerged from the September 2025 CommitFest.

The highlights from the first July CommitFest are available here: 2025-07.

GROUP BY ALL
Window functions: NULL value handling
Event triggers in PL/Python
More precise error message for incorrect routine parameter names
random: random date/time within a specified range
base64url format for encode and decode functions
New debug_print_raw_parse parameter
The log_lock_waits parameter is now enabled by default
pg_stat_progress_basebackup: backup type
vacuumdb: collecting statistics on partitioned tables
Buffer cache: using clock-sweep algorithm to find free buffers
Fake table aliases in queries

We're launching a new series of articles covering the changes coming up in PostgreSQL 19. This first article focuses on the events from last summer's July CommitFest.

Connection service file in libpq parameter and psql variable
regdatabase: a type for database identifiers
pg_stat_statements: counters for generic and custom plans
pg_stat_statements: FETCH command normalization
pg_stat_statements: normalizing commands with parameter lists in IN clauses
EXPLAIN: Memoize node estimates
btree_gin: comparison operators for integer types
pg_upgrade: optimized migration of large objects
Optimized temporary table truncation
Planner: incremental sort in Append and MergeAppend nodes
Domain constraint validation no longer blocks DML operations
CHECKPOINT command parameters
COPY FROM: skipping initial rows
pg_dsm_registry_allocations: dynamic shared memory (DSM) usage

Build the project as follows:

This command is for downloading from GitHub: https://github.com/rexglue/rexglue-sdk

Warning: You can download a pre-built .exe file, which will allow you to decompile the game in C++ (but building it is unlikely). Furthermore, versions are updated frequently, and the latest versions (with more instructions) are worth building.

Prepare the necessary directory.
Specify it as REXSDK in the global variables.

Sometimes the project won't compile in x64, so it's worth adding these lines to CMakeList.txt.

Enable Windows developer mode to download the necessary packages.

And in the /thirdparty/libsmpack folder, enter the following commands.

Then the necessary updates for the package will be downloaded.

Try adding additional parameters here. If it doesn't compile, then:

And finish the build:

Testing

To test the tool, use the following commands:

Add it to the assets/default.xex folder (you'll need to create it and add it to the project that rexglue will create).

This video can be useful for installing clang-cl and preparing default.xex from an Xbox 360 ISO image (which was dumped).

The program will display all missing instructions and replace them with placeholders (but it's best to create an issue with the required instructions, and once they're implemented, return to the project).

Don't forget to support the developers with well-deserved stars and share with your friends. Also, subscribe so you don't miss the next part, which will explain how to run the recompiled project.

Mandelbrot set. 32-bit TrueColor. 60 FPS. 80-bit long double. OpenMP. Supersampling 2x2 (4 passes). Color rotation. I want to say. This is the most necessary thing in the Universe. The most profound. And now, in my entire life, I finally started writing code and did it. Quite complex. And the most beautiful. Download and see! It's an executable file, on GitHub.

github: Download Latest Version Windows And Source code

I like AI and have been working with the technology for over a decade. It’s been exciting, interesting, and inspiring — until recently.

As I write this in mid-February of 2026, software stocks are in freefall and social media is inundated with videos of AI company CEOs predicting the looming collapse of the software industry.

They tell us the story we’ve heard on loop for two years:

LLMs fail at elementary math. Corporations spend billions, but ultimately are forced to attach calculators to computing machines of incredible power. All attempts to fix this via Chain-of-Thought, fine-tuning on arithmetic tasks, or context expansion have failed.

I conducted a series of experiments to understand why, and came to the conclusion that neural networks are simply not meant for discrete arithmetic. Their true purpose is continuous transformations.

This article describes the implementation of a novel neural network architecture that combines the precision of symbolic AI with the generalization capabilities of LLMs. As always, experiments and code are included.

Windows 11 is a modern and beautiful operating system, but sometimes it can run slower than you'd like. This is especially noticeable on older or less powerful PCs. The good news is that there are several simple and effective ways to improve system performance, making it faster and more convenient to use.

In this article, we'll look at how to properly configure Windows 11, get rid of unnecessary processes, and optimize its performance so that your computer runs smoothly and stably.

By the way, if you're interested in IT and useful tools, check out my Telegram channel. I regularly post fresh news, life hacks, and other useful things there. And now, to the heart of the article.

Accessing Claude from Russia might seem like a daunting task due to the service's regional restrictions. In this article, I will explain in detail how to register for the web version and API of Claude, what tools are needed to bypass the restrictions, and how to use the service safely in the future. This guide is based on personal experience and includes registration methods that are current as of late 2024 and have been tested in practice.

After searching Russian-language resources, I realized that there is very little practically useful information, or it might not account for changes in the service's operation. Ordinary users have to gather information piece by piece - from various YouTube videos, forums, or superficial articles.

Therefore, I decided to create an up-to-date guide based on my personal experience and knowledge, taking into account all the pitfalls that an inexperienced Claude user might encounter.

In the previous article, we got acquainted with the Meshtastic project. We learned that it's possible to build your own radio chat based on a Mesh network, a regular smartphone, and a radio modem. The next logical questions people started asking were: What's next? How do I build this network? What should I buy?

The second part will describe several commercial kits for a Meshtastic modem from Aliexpress, their differences, and application features. If for some reason you are not interested in ready-made products, you can build a radio modem yourself. It's not difficult at all and is manageable even for the youngest and most novice radio amateur. Interested? Welcome to the second part under the cut.

November 20 marked the official launch Nano Banana Pro (Gemini-3-Pro-Image-Preview) with the powerful Gemini 3 Pro as its foundation. This is a more mature tool for design, infographics, and content. We will not only look at the new features and why this particular model is a breakthrough, but we will also see it in action with real examples.

Yesterday I wrote about the graphical shell Launcher for GoodbyeDPI, which allows you to intuitively use the GoodbyeDPI solution from ValdikSS to solve the problem of YouTube throttling and the unavailability of a number of sites in Russia. Everything was fine, but these were solutions only for Windows. In the comments, the main questions were about what to do with Android, Linux, and Mac, and why not in the source code. Alas, the repressions of the RKN (Roskomnadzor) force the Habr administration to censor articles, I am forbidden from making changes to yesterday's article, and the link itself is only available outside of Russia, so I am explaining about Android, Linux, and Mac here, with links to the source code.

So, for Android there are a lot of projects, I liked Release ByeDPI 1.0.0 · dovecoteescapee/ByeDPIAndroid · GitHub. For Mac and Linux I would install https://github.com/xvzc/SpoofDPI/releases. All in source code.

ByeDPI for Android is an application that runs a local VPN service to bypass DPI (Deep Packet Inspection) and censorship. A SOCKS5 proxy ByeDPI is launched locally on your device and all traffic is redirected through it.

In this guide, we will install the v2rayA package on OpenWRT using the stable 23.05.0. A router with at least 128 MB of RAM (256 is preferable) and more than 16 MB of storage is recommended (the installation takes about 30 MB of storage)

v2rayA is a simple-to-use and powerful client focused on Linux. Despite its name, the current version uses xray-core, although it's also possible to use v2ray-core. It has a web interface for managing settings and importing configurations and subscriptions. It supports everything that xray-core supports:

Shadowsocks (incl. 2022), ShadowsocksR, Trojan, Vless (including XTLS-Reality, XHTTP), Vmess, Juicity, Tuic

The guide will include:

1. Installation from the repository

2. Configuring v2rayA and bypassing blocks using Re:filter, Antifilter GeoIP, Geosite

Wireshark is a widely used tool for capturing and analyzing network traffic, actively used for both educational purposes and for troubleshooting computer or network issues. Wireshark works with almost all OSI model protocols, has a user-friendly interface, and a convenient data filtering system. In addition, the program is cross-platform and supports the following operating systems: Windows, Linux, Mac OS X, Solaris, FreeBSD, NetBSD, OpenBSD.

Recently, I needed to run a VLESS subscription on Windows, make it work with my work VPN, and deal with all the associated 'joys.' I tried v2rayN, Nekoray, and Hiddify—and quickly realized I wanted to write my own client.
And so, singbox-launcher was born:
👉 https://github.com/Leadaxe/singbox-launcher

Below are a few details about why and what came of it.

Hello! How often in your work have you needed to run some strange application that you really don't want to or it's very dangerous to run on your personal smartphone, but you don't have a test device (a victim of future experiments) on hand to run it?

Yes, you can run Android Studio, but this software requires a preliminary study of the manual - without it, you won't be able to run anything on it, but there isn't always time and desire for such tasks. It is believed that the best task is one that can be delegated to another person, and all their emerging questions can be answered with a link to an article.

Unfortunately, I couldn't find such an article, and not to go far, I wrote one myself. In short, it's a common problem: if you can't find a good comparison, figure it out yourself.

Are you familiar with that feeling of slight panic when your laptop suddenly starts beeping plaintively, and a sinister warning appears on the screen: 'Disk almost full'? This happened to me recently too. I opened File Explorer and was stunned – my 1 TB external drive was filled to the brim – 95% full!

The culprits weren't movies or games, but a giant graveyard of photos. Twelve folders with the generic name 'DCIM,' mountains of screenshots I had copied five times 'just in case,' and heaps of nearly identical sunset shots taken in burst mode. Trying to manually find identical photos was like looking for a needle in a haystack the size of Siberia.

In a previous article, I discussed how to best sort photos, and even then I realized it was time to declare war on duplicates. And that moment has come. After testing more than 15 tools (and wasting a lot of nerves), I've selected 5 free programs that really help solve the problem. I'll share this experience with you.

Regular expressions (also called regexp, or regex) are a mechanism for finding and replacing text. In a string, a file, multiple files... They are used by developers in application code, testers in autotests, and even just when working on the command line!

Why is this better than a simple search? Because it allows you to specify a pattern.

For example, you receive a date of birth in the DD.MM.YYYYY format. You need to pass it on, but in the YYYY-MM-DD format. How can you do this with a simple search? You don't know in advance what the exact date will be.