Pull to refresh

All streams

Show first
Rating limit
Level of difficulty

Трюки, которым я научился при создании маленьких GLSL-демо

Level of difficultyMedium
Reading time9 min
Reach and readers1.1K

За последние два месяца я написал несколько маленьких GLSL-демо. О первом из них, Red Alp, я написал статью. В ней я подробно расписал весь процесс, поэтому рекомендую прочитать её, если вам незнакома эта сфера.

Мы рассмотрим четыре демо: MoonlightEntrance 3Archipelago и Cutie. Но на этот раз я расскажу лишь о паре уроков, которые извлёк из каждого. Мы не будем углубляться во все аспекты, потому что это было бы излишне.

Read more

Friday tickets and 6 TB of WAL: a day in the life of a Postgres Professional support engineer

Level of difficultyEasy
Reading time4 min
Reach and readers2K

Technical support comes in many shapes. Sometimes it’s "try rebooting" or "check the cable." And sometimes it’s deep engineering work you wouldn’t mind dedicating your whole life to. Which version lives inside Postgres Professional, and what’s more important in this field — people or tech? We dig into this with Kamil Karimov, Senior technical support engineer at Postgres Professional.

Read more

Build your own AI agent from scratch for free in 5 minutes

Level of difficultyEasy
Reading time4 min
Reach and readers6.4K

In this article, I will show you how to build your first AI agent from scratch using Google’s ADK (Agent Development Kit). This is an open-source framework that makes it easier to create agents, test them, add tools, and even build multi-agent systems.

Read more

Optimizing Postgres Pro for 1C: what's new

Level of difficultyEasy
Reading time3 min
Reach and readers6K

For businesses running 1C:Enterprise, database stability and speed aren't nice-to-haves—they're make-or-break. At Postgres Professional, we're constantly working on the DBMS core, eliminating architectural bottlenecks that show up under the heavy loads typical of 1C deployments.

We've just released Postgres Pro Enterprise 17.6 with a fresh batch of improvements specifically for 1C users.

Read more

How we made python pytest suites 8.5× faster

Level of difficultyEasy
Reading time6 min
Reach and readers6.4K

My name is Anatoly Bobunov, and I work as a Software Development Engineer in Test - or SDET for short - at EXANTE. When I joined one of our projects, I discovered that several of our test suites took more than an hour to run - painfully slow, to the point where running them for every merge request was simply unrealistic. We wanted fast feedback on each commit, but at that speed, it just wasn’t going to happen.

Eventually, through a series of small but precise improvements, I managed to speed things up to 8.5× faster, without rewriting the tests from scratch. In this article, I’ll walk through the bottlenecks we found and how we fixed them.

Read more

How to retain control over a UX project more effectively

Reading time5 min
Reach and readers6.4K

The UX design process, though very creative and interesting, is often also very unpredictable in nature and might be very hard to manage. Every designer or project manager has come across issues like misunderstanding with clients, freezed or unfinished projects, rejected ideas, deadlines violation or even conflict with stakeholders. Obviously, each of these problems might have its own reasons and require separate solutions, but overall, having not enough control over a UX project is a common problem of its own. Let's discuss a few tips that can help organize UX projects more smoothly and retain control over them more effectively. 

Read more

The Romantics at Anthropic: Why Researchers Talk About LLMs as if They Were Human

Level of difficultyEasy
Reading time7 min
Reach and readers7K

In my previous article, I showed how researchers confused being 'aware' (signal registration) with being 'conscious' (subjective awareness). But this is no accident — it is part of a narrative being constructed by AI labs. Anthropic is leading this trend. Let’s break down their latest paper, where a "learned pattern" has suddenly turned into "malicious intent."

Read more

Write. Review. Commit. Repeat. Behind the scenes of Postgres Professional docs

Level of difficultyEasy
Reading time3 min
Reach and readers5.2K

Everyone knows great documentation makes or breaks a tech product — but few realize how much work goes into it. At Postgres Professional, the docs are written with the same discipline as the code. What’s even more impressive, all of it is done by a team of just ten people. We talked to senior technical writer Ekaterina Gololobova to see how it really works — from the first task to the final commit.

Read more

Confusing 'Aware' with 'Conscious': Did Researchers Uncover Subjective Experience in LLMs?

Level of difficultyEasy
Reading time12 min
Reach and readers4.7K

Imagine this scenario: You ask an AI system, "Are you conscious?" and it answers, "No." You then disable its "capacity to lie" — and it suddenly starts answering, "Yes." The conclusion seems tempting: the model was lying the whole time, hiding its true internal state.

This is the core logic presented in a recent arXiv paper. But what if the researchers didn't disable "deception," but something else entirely? Let’s break down where the interpretation might have diverged from the technical reality — and why this specific oversight is typical in discussions regarding LLM "consciousness."

Read more

PostgreSQL multi-master: a pipe dream or a practical solution?

Level of difficultyMedium
Reading time7 min
Reach and readers5.4K

One of the open challenges in the database world is keeping a database consistent across multiple DBMS instances (nodes) that independently handle client connections. The crux of the issue is ensuring that if one node fails, the others keep running smoothly — accepting connections, committing transactions, and maintaining consistency without a hitch. Think of it like a single DBMS instance staying operational despite a faulty RAM stick or intermittent access to multiple CPU cores.

My name is Andrey Lepikhov, and I’d like to kick off a discussion about the multi-master concept in PostgreSQL: its practical value, feasibility, and the tech stack needed to make it happen. By framing the problem more narrowly, we might find a solution that’s genuinely useful for the industry.

Read more

Forget the hype: why I chose a career in C

Level of difficultyEasy
Reading time4 min
Reach and readers8.9K

In an era dominated by high-level abstractions and a focus on rapid development, the C programming language seems like a relic to many — an "outdated" tool with manual memory management and "dangerous" pointers. But what if these are its greatest strengths?

Maxim Orlov, a programmer at Postgres Professional with 22 years of experience, argues that C is not about quick wins and fast prototypes, but about fundamental control and a deep, philosophical understanding of how computers work. Join us for a journey from an initial frustration with Pascal to a profound appreciation for C, and learn why this "bastion of calm" is more relevant than ever.

Read more

10 free ways to promote your Telegram channel

Reading time4 min
Reach and readers7.8K

If you’re wondering how to promote your Telegram channel and actually get more subscribers — this guide is for you.

I’ve run several Telegram channels and tested dozens of free and paid Telegram promotion methods — from SEO optimization to Telegram Ads.

In this article, I’ll share 10 free ways to promote your Telegram channel that truly work.

These methods are simple, proven, and can help you grow your audience organically — without spending a single dollar.

Read more

Gemini CLI Best Practices – Practical Examples

Level of difficultyEasy
Reading time4 min
Reach and readers13K

I’ve been using the Gemini CLI a lot lately for my coding projects. I really like how it helps me work faster right inside my terminal. But when I first started, I didn’t always get the best results. Over time, I’ve learned some simple tricks that make a huge difference. If you use the Gemini CLI, I want to share my top 10 pro tips. If you are ready, then let’s get started.

Read more

AWS SageMaker: Choosing the Right Inference Type for ML Models

Level of difficultyEasy
Reading time5 min
Reach and readers8.8K

When I started working with AWS SageMaker, one of the most common questions was: “Which inference type should I choose for my model?” SageMaker offers four different options, and at first glance, the differences between them aren’t always obvious. Let’s break down when and which approach to use.

Read more

StarRocks vs. ClickHouse, Apache Druid, and Trino

Level of difficultyEasy
Reading time8 min
Reach and readers7.9K

In the big data era, data is one of the most valuable assets for enterprises. The ultimate goal of data analytics is to power swift, agile business decision making. As database technologies advance at a breathtaking pace in recent years, a large number of excellent database systems have emerged. Some of them are impressive in wide-table queries but do not work well in complex queries. Some support flexible multi-table queries but are held back by slow query speed.

Each type of data has a data model that best represents them. However, in real business scenarios, there is no such thing as ultra-fast data analytics under the perfect data model. Big data engineers sometimes have to make compromises on data models. Such compromises may cause long latency in complex queries or damage the real-time query performance because engineers must take the trouble to convert complex data models into flat tables.

New business requirements put forward new challenges for database systems. A good OLAP database system must be able to deliver excellent performance in both wide-table and multi-table scenarios. This system must also reduce the workload of big data engineers and enable customers to query data of any dimension in real time without worrying about data construction.

Read more

A Small Practical Guide to Calculating the Economic Value of AppSec and DevSecOps

Level of difficultyMedium
Reading time5 min
Reach and readers8K

Investing in Application Security (AppSec) and DevSecOps is no longer optional; it's a strategic imperative. However, securing budget and justifying these initiatives requires moving beyond fear and speaking the language of business: Return on Investment (ROI).

This guide provides a structured framework for calculating the costs and benefits of embedding security into your software development lifecycle (SDLC). By understanding and applying concepts like Total Cost of Ownership (TCO), Lifecycle Cost Analysis (LCCA), and Return on Security Investment (ROSI), you can build a compelling financial case, guide your security strategy, and prove tangible value to stakeholders.

Read more
1
23 ...