By next year, we'll be talking to databases in natural language
According to Gartner, natural language queries will replace SQL as early as 2026.
While Gartner's prediction may be optimistic, the shift toward natural language interfaces for databases is inevitable. The timeline may vary, but the transition itself is a certainty: https://u.habr.com/vOeSI
According to Gartner, natural language queries will replace SQL as early as 2026.
While Gartner's prediction may be optimistic, the shift toward natural language interfaces for databases is inevitable. The timeline may vary, but the transition itself is a certainty: https://u.habr.com/vOeSI
April 29
What is DPI Engine?
For people familiar with the term DPI (Deep Packet Inspection), it often carries an unpleasant association: blocking, regulators, censorship, tightening controls. In reality, DPI is simply the name of a technology whose essence lies in the deep analysis of network traffic. Deep traffic analysis involves identifying protocols, extracting the most significant fields and metadata, classifying internet services, and analyzing the nature of network flows. Let's find out how such solutions work: https://u.habr.com/iFaGK
For people familiar with the term DPI (Deep Packet Inspection), it often carries an unpleasant association: blocking, regulators, censorship, tightening controls. In reality, DPI is simply the name of a technology whose essence lies in the deep analysis of network traffic. Deep traffic analysis involves identifying protocols, extracting the most significant fields and metadata, classifying internet services, and analyzing the nature of network flows. Let's find out how such solutions work: https://u.habr.com/iFaGK
April 30
"How I Created Perfect Wiki and Reached $250K in Annual Revenue Without Investors"
From a simple idea to fix Microsoft Teams' clunky built-in Wiki, a SaaS founder built Perfect Wiki — a seamless knowledge base tool. Bootstrapped, no investors, just a 20-person team. Now at $250K/year in 5 years: https://u.habr.com/QKXlV
From a simple idea to fix Microsoft Teams' clunky built-in Wiki, a SaaS founder built Perfect Wiki — a seamless knowledge base tool. Bootstrapped, no investors, just a 20-person team. Now at $250K/year in 5 years: https://u.habr.com/QKXlV
April 30
PostgreSQL 18: Part 4, or CommitFest 2025-01
We continue to follow the news about PostgreSQL 18. The January CommitFest brings in some notable improvements to monitoring, as well as other new features: https://u.habr.com/qNW3V
We continue to follow the news about PostgreSQL 18. The January CommitFest brings in some notable improvements to monitoring, as well as other new features: https://u.habr.com/qNW3V
May 5
About the C++ static analyzer as a Clang plugin
This article is based on the experience of developing the memsafe library, which, using the Clang plugin, adds safe memory management and invalidation control of reference data types to C++ during source code compilation: https://u.habr.com/Ph8FV
This article is based on the experience of developing the memsafe library, which, using the Clang plugin, adds safe memory management and invalidation control of reference data types to C++ during source code compilation: https://u.habr.com/Ph8FV
May 13
Tips and methods for conducting user research with children
Conducting a UX research session with children might be a very interesting, but at the same time very challenging experience. Working with kids requires a totally different approach than with adults, and it’s important to keep that in mind throughout the whole session: https://u.habr.com/HCvym
Conducting a UX research session with children might be a very interesting, but at the same time very challenging experience. Working with kids requires a totally different approach than with adults, and it’s important to keep that in mind throughout the whole session: https://u.habr.com/HCvym
May 13
VS Code Agent Mode: How It Helped Me Build a Django App in Minutes
If you’re using VS Code and want to give your development a turbo boost, you’ll want to hear about this: https://u.habr.com/A4SLH
If you’re using VS Code and want to give your development a turbo boost, you’ll want to hear about this: https://u.habr.com/A4SLH
May 15
How to catch and optimize problematic queries in PostgreSQL
If you work with PostgreSQL, you've likely run into performance issues at some point — especially as your database grows. Things may have been running smoothly at first, but as your client database expanded, queries started slowing down. Sound familiar? Here's a guide to help you identify and fix problematic queries, so you can get your PostgreSQL database running at peak performance again: https://u.habr.com/bwHMT
If you work with PostgreSQL, you've likely run into performance issues at some point — especially as your database grows. Things may have been running smoothly at first, but as your client database expanded, queries started slowing down. Sound familiar? Here's a guide to help you identify and fix problematic queries, so you can get your PostgreSQL database running at peak performance again: https://u.habr.com/bwHMT
May 19
MSSQL: Index Heatmaps in TreeView Format
Would you like to know which indexes are used frequently or rarely? Which ones aren't used at all? Which tables and indexes are the largest? It's very easy to create visualizations for this. They're both visually appealing and practically useful: https://u.habr.com/HWNFA
Would you like to know which indexes are used frequently or rarely? Which ones aren't used at all? Which tables and indexes are the largest? It's very easy to create visualizations for this. They're both visually appealing and practically useful: https://u.habr.com/HWNFA
May 21
What's New in the Angie 1.9 Web Server (an nginx fork) and What to Expect from 1.10?
You may have already read in the news that on the eve of Cosmonautics Day, a new stable release of Angie 1.9.0 was released, an nginx fork that continues to be developed by the team of former nginx developers. Approximately every quarter, we try to release new stable versions and delight users with numerous improvements. This release is no exception, but it's one thing to read a dry changelog and quite another to get to know the functionality in more detail, to learn how and in which cases it can be applied: https://u.habr.com/RJiZ5
You may have already read in the news that on the eve of Cosmonautics Day, a new stable release of Angie 1.9.0 was released, an nginx fork that continues to be developed by the team of former nginx developers. Approximately every quarter, we try to release new stable versions and delight users with numerous improvements. This release is no exception, but it's one thing to read a dry changelog and quite another to get to know the functionality in more detail, to learn how and in which cases it can be applied: https://u.habr.com/RJiZ5
May 21
Why you love bad products?
Users don’t fear changes. They fear wasting time. Why users reject “best” products — and how to win them over.
Users don’t fear changes. They fear wasting time. Why users reject “best” products — and how to win them over.
May 27
"In this post, I’ll show you EXACTLY how to run Telegram ads in 2025.
In fact, this is the exact process I use to grow my Telegram channels and get quality subscribers for just 0.01 TON ($0.03 as of May 15, 2025)"
How to Run Telegram Ads in 2025: Secrets to High-Converting Telegram Ads
In fact, this is the exact process I use to grow my Telegram channels and get quality subscribers for just 0.01 TON ($0.03 as of May 15, 2025)"
How to Run Telegram Ads in 2025: Secrets to High-Converting Telegram Ads
May 27
Captcha Solver Extension – Which to Choose: AI-Powered or Human-Powered? Difference Free and Paid CAPTCHA Extension
Imagine a developer automating routine tasks — for example, testing a web application or writing a data scraping script. Everything runs smoothly until a CAPTCHA appears on the path. In the browser, a familiar window pops up: "I am not a robot," or a grid of images where you need to find traffic lights or pedestrian crossings. The automatic script halts, tests fail, and an inexperienced developer might not even realize the problem for a long time — after all, they set everything up and started it, but didn’t account for the presence of CAPTCHAs (Completely Automated Public Turing test to tell Computers and Humans Apart), designed precisely to stop bots.
Imagine a developer automating routine tasks — for example, testing a web application or writing a data scraping script. Everything runs smoothly until a CAPTCHA appears on the path. In the browser, a familiar window pops up: "I am not a robot," or a grid of images where you need to find traffic lights or pedestrian crossings. The automatic script halts, tests fail, and an inexperienced developer might not even realize the problem for a long time — after all, they set everything up and started it, but didn’t account for the presence of CAPTCHAs (Completely Automated Public Turing test to tell Computers and Humans Apart), designed precisely to stop bots.
May 27
"My own path began in full-stack engineering, but almost a decade of shipping production code drew me ever deeper into application security. In this article I’m explaining key approaches on what SAML actually is and how we detect it in Bright using DAST"
DASTing SAML: Breaking Trust, One Assertion at a Time
DASTing SAML: Breaking Trust, One Assertion at a Time
May 28
cgroups: how to eliminate the “noisy neighbor” effect in PostgreSQL
If you've ever run multiple instances of PostgreSQL or other software on a single machine (whether virtual or physical), you've probably encountered the "noisy neighbor" effect — when instances disrupted each other. So, how do you make them get along? We’ve got the answer!
If you've ever run multiple instances of PostgreSQL or other software on a single machine (whether virtual or physical), you've probably encountered the "noisy neighbor" effect — when instances disrupted each other. So, how do you make them get along? We’ve got the answer!
May 28
Want to rank higher on Google? Use these 6 backlink techniques
Want Higher Google Rankings? Try These 6 Backlink Strategies That Actually Work. In the end, you’ll get tips to help you build a strong backlink strategy.
Want Higher Google Rankings? Try These 6 Backlink Strategies That Actually Work. In the end, you’ll get tips to help you build a strong backlink strategy.
May 28
Designing profitable software: architecture principles for business success
This article presents a business-driven approach to software architecture, focusing on maximizing profitability through technical decisions. It advocates for 1) distributed, stateless services with immutable models for scalability, 2) isolated third-party integrations without disrupting core logic, 3) simple, modular design.
This article presents a business-driven approach to software architecture, focusing on maximizing profitability through technical decisions. It advocates for 1) distributed, stateless services with immutable models for scalability, 2) isolated third-party integrations without disrupting core logic, 3) simple, modular design.
May 28
Postgres Pro OpenTelemetry сollector
pgpro-otel-collector is an OpenTelemetry collector (aka monitoring agent) tailored for gathering Postgres metrics and logs — brought to you by PostgresPro.
pgpro-otel-collector is an OpenTelemetry collector (aka monitoring agent) tailored for gathering Postgres metrics and logs — brought to you by PostgresPro.
June 4
How an AI CAPTCHA Solver Works: From OCR to Deep Learning
Can a program be taught to solve CAPTCHAs the way a human does—quickly and reliably? In this article, we will try to figure out how AI CAPTCHA solvers are built, from classical OCR methods to modern neural networks.
Can a program be taught to solve CAPTCHAs the way a human does—quickly and reliably? In this article, we will try to figure out how AI CAPTCHA solvers are built, from classical OCR methods to modern neural networks.
June 4
"In this tutorial, I’ll walk you through everything I’ve learned about using Google Jules — an asynchronous coding agent. I’ve kept the explanations clear and simple, so whether you're an experienced developer or a beginner, you’ll be able to follow along"
Google Jules: An Asynchronous Coding Agent Explained
Google Jules: An Asynchronous Coding Agent Explained
June 4