Habr

News from Habr


Fresh news
Other news
older that 24 hours
Habr
melanny20 (Postgres Professional) @ Habr 1 place · 06/30/2025 07:00 EDT

[Translation] On reordering expressions in Postgres

Today, I want to talk about one of those sneaky tricks that can help speed up query execution. Specifically, this is about reordering conditions in WHERE clauses, JOINs, HAVING clauses, and so on.The idea is simple: if a condition in an AND chain turns out to be false, or if one in an OR chain turns out to be true, there's no need to evaluate the rest. That means saved... Read more

0

Habr
Kamil_GR @ Habr 1 place · 06/28/2025 10:29 EDT

From Unprogrammable to Detectable: A Framework for Recognizing Emergent Consciousness in AI Systems

An Integrated Approach: Philosophical Barriers to Creation and Practical Methods for Detecting Subjectivity in Artificial Systems (from modeling AI consciousness to diagnosing it) Read more Read more

1

Habr
Kamil_GR @ Habr 1 place · 06/27/2025 10:21 EDT

Cognitive Traps in Humans and AI: How Language Models Fail in Beautiful Ways

As language models become more powerful, they also become more elusive. We are no longer dealing with simple text generators but with complex systems capable of creative reasoning, philosophical reflection, and simulated self-awareness. But with this growing sophistication come new vulnerabilities—cognitive traps that can distort both the model's thinking and our own perception of its output.This article is based on extensive testing of various large language models (LLMs) in settings... Read more

0

Habr
profleaddev @ Habr 2 place · 06/27/2025 08:48 EDT

Gemini CLI: Open-Source AI Agent in Terminal

Have you ever wished for an AI assistant right inside your terminal window? Well, your dream has come true because Google just released Gemini CLI. In this tutorial, I'm going to show you everything you need to know about this new open-source AI agent. We'll cover how to use it, the pricing, and some useful tips and tricks. So, if you're ready, let's get started! ;) Read more Read more

0

Habr
Aaaasonya @ Habr 3 place · 06/27/2025 08:47 EDT

When the Office Is a Planet: How to Manage Distributed Teams

Remote work in IT has long ceased to be unusual. But it is one thing to assemble a distributed team, and quite another to make it work comfortably for the participants and the company's results. The article shares a story about distributed teams with a flexible culture, trust, and freedom, and how we achieved this. Read more Read more

0

Habr
melanny20 (Postgres Professional) @ Habr 1 place · 06/23/2025 07:00 EDT

[Translation] Automated management of extended statistics in PostgreSQL

Here I describe the results of developing a PostgreSQL extension I built just out of curiosity. Its purpose is to automatically manage extended column statistics. The idea came to me while finishing work on another "smart" query-driven product for improving PostgreSQL planning quality. I realized that the current architecture of PostgreSQL isn’t quite ready for fully autonomous operation — automatic detection of bad plans and adaptive optimizer tuning. So why... Read more

0

Habr
kostanew (AIRI) @ Habr 2 place · 06/23/2025 05:04 EDT

Глубокое обучение для квантовой химии. Часть I. Основы

Всем привет! Меня зовут Константин, и я занимаюсь вопросами глубокого обучения в естественных науках в AIRI.Среди всех достижений глубокого обучения большие языковые модели — пожалуй, самые заметные. Однако помимо работы с текстами у нейросетей есть хорошие перспективы в области биологии, химии, физики и других наук. Можно вспомнить, например, последние Нобелевские премии за архитектуру AlphaFold. Мы в AIRI активно интересуемся этим прогрессом, в особенности применением глубокого обучения для квантовой хими Read more

0

Habr
SergeyProkhorenko @ Habr 1 place · 06/21/2025 12:00 EDT

What May Surprise You About UUIDv7

UUIDv7 was inspired by ULID. Like ULID, it is a 128-bit identifier, containing a timestamp on the left side and random data on the right side. But RFC 9562 establishes many requirements for UUIDv7.In databases and distributed systems, a properly implemented UUIDv7 is always preferred over any other identifier type, including natural keys, autoincrement, UUIDv4, TypeID, ULID, KSUID, CUID, NanoID, and Snowflake ID. Read about surprising distinctions of UUID Read more

0

Habr
drobushevkiy @ Habr 1 place · 06/19/2025 00:02 EDT

[Translation] Get Free Backlinks from These 35+ Authority Websites

Getting backlinks is hard. And getting traffic? Even harder.But some websites still give you both for free.I made a list of 35+ free sites and directories where you can add your product. You’ll get a real link to your site (a site backlink) and start getting clicks. Get Free Backlinks Read more

0

Habr
ArcaneGamingcom @ Habr 2 place · 06/18/2025 04:42 EDT

How to provide effective training for a UX design team

Training is one of the most essential factors for growth, evolution and effective collaboration for any UX design team. Design is an ever-changing industry, and there is always something new to learn even for the most experienced professionals. The reality is, not all companies take training seriously, whether the reason is a low budget, lack of time or just not realising its necessity. Meanwhile, investing in training not only boosts... Read more

0

Habr
RuStore (VK) @ Habr 2 place · 06/17/2025 07:34 EDT

Любовь, платежи и профит: как романтическая игра внедрила новый Pay SDK от RuStore

В какой-то момент всё становится серьёзным — даже в приложениях про любовь. Команда Redspell, создатели игры Senses (интерактивные романтические истории), решили стать одними из первых, кто интегрировал новую платёжку от RuStore — Pay SDK. И встроили — с нуля, но в итоге с ростом метрик.Вот честный рассказ о том, как ребята внедряли RuStore Pay SDK, что пошло не так, как с этим справились и какие результаты в итоге получили. Если... Read more

0

Habr
kentavr009 @ Habr 3 place · 06/17/2025 06:16 EDT

[Translation] AI Agents in Modern IT Solutions

These days, it seems like everyone is talking about AI. AI here, AI there—AI will replace us all, and so on. I started to wonder: how exactly is AI going to replace us? I decided to dig into this question and examine the technical foundations, mainly to understand it for myself—how exactly is AI supposed to replace us all? Spoiler: it isn’t planning to just yet, but what’s already available... Read more

0

Habr
LongMoney @ Habr 3 place · 06/16/2025 08:21 EDT

Becoming a lead isn’t just another line in your resume,  it’s a mental shift. It’s the moment you go from being a developer to someone responsible for your code and the entire team. Next, you’re also listening, mentoring, negotiating, motivating, and knowing how to find common ground even in challenging situations.Today, I’m a Dev Lead at EXANTE. We develop internal services for a select group of internal stakeholders. But my... Read more

0

Habr
melanny20 (Postgres Professional) @ Habr 3 place · 06/16/2025 07:00 EDT

[Translation] Whose feature is better, or how to compare the efficiency of SQL query plans

How to compare the efficiency of SQL query plans? “Measure the execution time, of course!” — an experienced reader would say. And they would be absolutely right: from a practical perspective, the more efficient DBMS is the one that delivers higher TPS. However, sometimes we need to design a system that doesn't exist yet or predict behavior under loads that haven't occurred yet. In such cases, we need a characteristic... Read more

0

Habr
xcont @ Habr 1 place · 06/14/2025 16:54 EDT

[Translation] The Billiard Fractals

Complex systems often appear chaotic or incomprehensible, yet closer examination reveals that such complexity can frequently be reduced to a simple underlying mechanism. By systematically removing layers of emergent behavior, one can uncover a fundamental rule or equation from which the entire system originates. Read more → Read more

0

Habr
profleaddev @ Habr 1 place · 06/12/2025 10:47 EDT

OpenAI Codex: A Software Engineering Agent

A few weeks ago, OpenAI announced that Codex is available for Plus users, and I didn’t miss a chance to try it. And today, I’m excited to share a guide to OpenAI’s Codex. As a developer, I’ve found it to be a powerful and practical tool. Read more Read more

0

Habr
suncru (Selectel) @ Habr 2 place · 06/12/2025 04:07 EDT

Как устроены LLM-агенты: архитектура, планирование и инструменты

Всем привет! С вами Кирилл Филипенко, сисадмин из Selectel, и сегодня мы погрузимся в тему LLM-агентов. Сейчас об этих самых «агентах» кричат буквально из каждого утюга, поэтому пришло время наконец-то разобраться, что это такое, как они работают и с чем их, собственно, едят. Прыгайте под кат, будет интересно! Read more → Read more

0

Habr
Tzimie @ Habr 1 place · 06/10/2025 09:17 EDT

Coloring a T-SQL Procedure Listing with Metric Values

We append the following metrics to the T-SQL procedure statements: execution count (x), CPU time in milliseconds (c), duration in microseconds (d), number of reads (r), number of writes (w), and @@rowcount value (n). You can display these as absolute values or percentages. Read more Read more

0

Habr
melanny20 (Postgres Professional) @ Habr 1 place · 06/09/2025 07:00 EDT

SQL Server vs. PostgreSQL query optimization: room for improvement?

For years, we’ve studied Oracle to make PostgreSQL a more migration-friendly option. We introduced tools similar to SQL profile and SQL plan baseline as AQO and sr_plan extensions. In some cases, PostgreSQL even outperforms Oracle, especially in automatic re-optimization.Migrations from Oracle to PostgreSQL are usually smooth performance-wise, and we’ve even developed session variable extensions to make the transition easier. While many enterprise-only features exist, PostgreSQL often integrates popular sol Read more

0

Habr
VEG @ Habr 2 place · 06/09/2025 03:17 EDT

Neat defer macro for C++17

Manual resource management in low level C-style C++ code might be annoying. It's not practical to create good enough RAII wrappers for every single C API you use, but approaches with goto cleanup or loads of nested if (success) hurt readability.A defer macro to the rescue! The deferred lambda will be executed on scope exit, no matter how it happens: you can return from any point, throw an exception (if... Read more

0

Most popular sources

  • You see 725 news out of 725.
  • Sources 61 out of 61.
Business Insider 30% 7
Gizmodo 14% 7
Ars Technica 7% 6
Android Authority 6% 5
The Verge 5% 14
View sources »

LIKE us on Facebook so you won't miss the most important news of the day!

29.07.2025 11:05
Last update: 11:00 EDT.
News rating updated: 18:01.

What is Times42?

Times42 brings you the most popular news from tech news portals in real-time chart.
Read about us in FAQ section.


Times42 © 2025