In this article, we will not only install a local (and free) alternative to ChatGPT, but also review several open LLMs, delve into the advanced settings of LM Studio, connect the chatbot to Visual Studio Code, and teach it to assist us with programming. We will also look at how to fine-tune the model's behavior using system prompts.
What do we have at the end of 2025?
Mass layoffs, tightening of the screws by the state and marketplaces. An increase in VAT, which means a rise in store prices. The SMO continues, leading to high government spending, a high Central Bank rate, and consequently, a business freeze.
I spoke with the owners of manufacturing companies, an IT company, and an analytical agency who have already been through crises, and I asked:
'What are you going to do in 2026 to survive?'.
In short: in the year of the horse, you'll have to work like a horse.
Hello everyone!
I want to note right away that this article is written exclusively for people who are just starting their journey in learning SQL and window functions. It may not cover complex applications of functions or use complicated definitions—everything is written in the simplest language possible for a basic understanding.
P.S. If the author didn't cover or write about something, it means they considered it non-essential for this article)))
For the examples, we will use a small table that shows student grades in different subjects. In the database, the table looks like this:
Hello, Habr!
I've been putting off writing this article for a long time, but the time has come.
There are quite a few materials on the internet about how to run macOS on regular, IBM-compatible PCs. Their problem is exactly the same as with Wine, which I also wrote my own article about - they are too... vague on the details of how to create an installation media and what to do after installation.
In this article, I will be following the guide from Dortania. There is a Russian version, but it's always older than the most current one, so I will use the original. I will also be taking some screenshots and links from there.
Before we begin, I'd like to enlighten those who are not aware of what a Hackintosh is.
A Hackintosh is the process of installing macOS on regular PCs. What's the difficulty?
All MacBooks use their own hardware (at least now, in 2025). They used to use different processors - in classic Macintoshes they used processors from Motorola. Later models featured processors from IBM PowerPC (during this period they were called PowerMacs). And in the early 2000s, Apple switched to Intel processors. It was during this period that the system we are most interested in appeared - OSX, later renamed to macOS.
When the question of describing a system's architecture arises, there are several main solutions for where and how to do it. Among the popular notations for visualizing architecture diagrams, one can choose C4, developed by Simon Brown.
In this article, I want to show an example of applying the C4 notation, which you can use as a guide in your work, as well as tools for creating it. In particular, I highlight Structurizr.
This article is useful for system analysts, architects, developers, project managers, and anyone involved in creating and making decisions about project architecture.
Since I'm a fan of self-hosting, I have a home infrastructure:
Orange Pi - a media server;
Synology - a file dump;
Neptune 4 - a 3D printer with a web interface and a camera feed. And I'd like to have secure access to it externally via my phone and PC, while also having internet access outside the RF. I used to use OpenVPN for these needs, but it's no longer reliable. So I started studying the documentation for an excellent tool from our Chinese comrades - Xray!
What you'll need:
A server with an external IP for the infrastructure. In my case, it's an Orange Pi, hereinafter - Bridge
The server you want to access - Server
A server outside the RF for internet access. Hereinafter - Proxy
A client of your choice. Hereinafter - Client
Client and server on Linux - Xray-core, which can be installed via the official Xray installation script
Client for Android - v2rayNG
More clients can be found in the Xray-core repository
Let's take the VLESS-TCP-XTLS-Vision-REALITY configuration file as a base and start reading the Xray documentation
Routing is done on the client. For example, if the client accesses the xray.com domain, we route the traffic to the Bridge, and for all other connections - to the Proxy. Then the Bridge routes the traffic to the Server if the client accessed server.xray.com.
It looks like this:
My second article—an analysis of MAX's network requests and why this analysis is my biggest disappointment! I certainly didn't expect this, but I described everything as it is.
Under the cut: my story of how I decided not to pay for a VPN, but to deploy my own instead. Then I thought: why not make a full-fledged service? And then... well, the rest is business as usual.
I set up servers, hired a designer, launched ads, and tried not to get disappointed. Spoiler: I haven't gotten what I wanted yet. But the hope for ships sailing the vast expanses still warms my heart.
Programmers, sysadmins, DevOps engineers, and testers are often united by the use of some common technologies. For example, the ability to have remote access to a server would be useful to anyone in the aforementioned anecdotal company. Therefore, in this article, we will cover the basics of working with the SSH protocol at a fundamental level (without generating keys, signatures, moms, dads, and credits). We'll look at 'advanced' usage separately next time. This material was prepared by Max, the author of the YouTube channel PyLounge. Let's go!
This weekend was all about 'Connection Reset.' While news channels vaguely reported that 'users are complaining about outages,' we were in chats and on test servers trying to understand the physics of the process.
On November 18, 2025, Google introduced a new combination: the Gemini 3 Pro model and the Google Antigravity IDE. The first is about controlled reasoning, long context, and multimodality. The second is about multi-agent development with artifacts and "transparent" steps. Headlines immediately flooded the feeds: "Cursor is dead.".
In this article, we break down what exactly Google has launched, why the words "the smartest model" are an exaggeration, how Antigravity differs from Cursor, which development scenarios are already changing, and where it's still too early to abandon your familiar stack.
Now you won't have to blush in front of your employer or teacher because an AI wrote the text for you. Just make the detectors believe that the author is a human. In this article, we'll tell you how to do it and what the trick is.
Lately, articles have been coming out about how to watch torrents on a TV. I read them and realize that the topic is not fully covered; people suggest putting in maximum effort for the bare minimum.
What do you need for watching movies at home, and how does it work for me...
Jokes, memes, AI-generated images—even large companies have jumped on the Dolina bandwagon.
But here's a detail no one has mentioned yet: the name 'Larisa Dolina' is actually an officially registered trademark with Rospatent.
By law, you can claim compensation of up to 5,000,000 rubles for each trademark infringement. And from January 3, 2026, this limit will increase to 10,000,000 rubles.
It seems absurd to sue for money over internet jokes. But what do you think of the apartment ruling itself?
I am an intellectual property lawyer. Trademarks, patents, and copyrights are my profession.
How many more apartments do you think Dolina will be able to buy with the compensation money?
Let me show you what Dolina has registered with Rospatent, and using the best jokes as examples, we'll analyze the risks for everyone who has jumped on this topic.
A couple of weeks ago, I launched "Reverse VPN" – a VPN with a Russian IP for accessing websites that are unavailable from abroad. I've already been contacted by more than 1,000 people. I was able to help most of them. A huge thank you to everyone for the donations and kind words!
I'll tell you about the ways you can install the Chinese model locally and use it without the internet. And do it in a way that you work not through the console, but through a user-friendly chatbot interface.
Friends, today I want to share a story that made me believe in miracles for half an hour. And at the same time, I'll break down a new scam scheme that showed me that criminals are evolving too.
Welcome back, dear readers! We are continuing our 'SHKH' series of articles, and today our main course is Telegram. In earlier articles, we looked at ways to find a target user's accounts by their nickname, after which we conducted reconnaissance on their account on the VKontakte social network. At this stage, our important goal is to find out the user's phone number, as the number can be a good starting point for reconnaissance and can reveal even more details about its owner. In the last article we tried to find out the number using a VKontakte page, and in this one, as you might have guessed from the title, we will try to find out as much information as possible about a Telegram account. This material has been edited and republished due to the blocking of the previous material by the RKN (Roskomnadzor) in the Russian Federation.
Disclaimer: All data provided in this article is taken from open sources. It does not call for action and is published solely for familiarization and study of the mechanisms of the technologies used.
The most interesting finance and tech news from Russia and the world for the week: RKN blocked FaceTime, Snapchat, and Roblox, visa-free travel with China and Saudi Arabia, Russia was added to the EU's money laundering blacklist, home surveillance cameras were hacked in South Korea, Musk's Twitter was fined in Europe, and rumors of a 'garlic' model from OpenAI.