Intuit OA 2026 Guide: Code, SQL & Bash Questions Explained
The Intuit Online Assessment (OA) has started rolling out again, and the format remains very similar to previous years. Most candidates receive three …
Testing & QA
⚑ Report a ProblemLatest Testing & QA news from Tech News
All topics
agents
ai
api
architecture
automation
aws
backend
beginners
career
claude
cybersecurity
database
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
testing
tutorial
typescript
webdev
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes
Manticore Search 28.6.6 has been released. The headline additions are UUID document IDs for real-time tables and ordered, limited GROUP_CONCAT() for g…
AWS retired its free database migration assessment tool. The reason should change how you build developer tools.
On May 20, 2026, AWS ended support for DMS Fleet Advisor. Fleet Advisor answered a question every migration team asks first: what is actually in my da…
Postgresso #6 (91)
pgrust это СУБД или злая шутка? Майкл Мэйлис (Michael Malis), житель Сан Франциско, основатель freshpaint‑io , работал в компании Heap  …
Как LLM могут помочь определить Data Lineage
Сегодня данные стали основой для принятия решений, а их качество и прозрачность — критичными факторами успеха любого бизнеса. Однако с ростом объёма и…
SQL Design & Query Reference
I have professionally worked with four different SQL database types PostgreSQL , MySQL & MariaDB (InnoDB), MSSQL SQL Server 2008+ and Oracle 19c +…
REST-style GraphQL — one line of Java handles filtering + sorting + pagination + stats + CSV export.
(Demo's in Chinese but you'll get the idea in 30 seconds) 👇 https://demo-bs.zhxu.cn/ A backend engineer's confession: you just wrote 100 lines of Java…
Azure SQL Managed Instance vs Azure SQL Database: How I Actually Made the Call
A field decision from a real production migration — not a feature-matrix blog. When we migrated two internal enterprise applications (plus an integrat…
# AI-Generated SQL Has a Silent Failure Problem. Here's a Way to Catch It.
If you've spent any time close to a data warehouse, you already know the scariest bug isn't the one that throws an error. It's the one that returns a …
10+ млрд строк, 30 000+ таблиц, 5500 полей с персональными данными. Как мы автоматизировали обезличивание на большой БД
Привет! Меня зовут Дима Левин, сейчас я работаю системным аналитиком в Петрович-Техе. Так уж сложилось, что в своей работе в нескольких проектах я пло…
One Histogram, Four Engines: Fixing the Statistics Silo Problem
TL;DR — DuckDB, DataFusion, Polars, and Postgres each compute and store table statistics their own way, so a histogram built in your ELT pipeline is i…
Killing N+1 Queries: From Per-Row Lookups to Flat, Batched Reads
You ship a read endpoint. It lists some things, say devices or orders or invoices, and for each row it pulls in a bit of related data. With five rows …
I Reduced a 12-Second SQL Query to 300ms Without Changing the Server
Performance optimization isn't always about buying better hardware. Sometimes, it's about asking the database the right question. Introduction A slow …
AI Data Analysis: Why Governed Metrics Beat Raw SQL Generation
AI data analysis tools are everywhere. Upload a spreadsheet to Julius AI and get a chart. Ask ChatGPT's Data Analyst to find trends. Connect Databrick…
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist
DuckDB Iceberg MERGE, PostgreSQL GUCs, SQLite Optimization Checklist Today's Highlights This week's highlights include powerful new Iceberg data manip…
2am.tech Releases SQL Migration Tool to Streamline Database Changes
Database migrations have a reputation for going wrong at the worst possible moment. Omitted rollback scripts, schema changes applied to production but…
Your Postgres already knows why it's slow — you just have to ask it
Keeping our database fast at Atlas was part of my job — alongside writing code and shipping features. And a big chunk of that job was unglamorous: cha…
Open Source Project of the Day (#116): SAG — Multi-Hop RAG Retrieval via SQL JOINs Instead of PageRank
Introduction "Graph RAG typically pre-builds a global graph offline, then uses PageRank for query-time scoring and expansion — but PageRank has decay:…
The Database Architect Teaches His Nephew: Where the Real Interview Happens
Same uncle, this time in "Database Architect" mode. Same nephew, this time asking the question every backend developer eventually asks out loud. Part …
When to denormalize, when to join: A ClickHouse guide (2026)
Denormalization has been the standard approach to analytical data modeling for good reason. Moving joins, lookups, and business rules out of query tim…
One query language for SQL, Mongo, and the browser: the case for Forge
There's a moment in most TypeScript backend projects when the data layer stops being one thing. Maybe you started on Postgres, then a feature shipped …
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive Today's Highlights This week brings a stable new patch release for…
Implementing Feature Flags Across Stack
Shipping an application that I didn't have access to was giving me heartburn. So I decided to create a lightweight feature flag tool. The Problem The …
Устанавливаем Digital Q.DataBase 18.2 на Astra Linux: PostgreSQL, MS SQL и Oracle в одной СУБД
Привет, Хабр! Меня зовут Жуйков Андрей, в Диасофт я занимаюсь развитием и продвижением СУБД Digital Q.DataBase. Импортозамещение СУБД перешло из разря…
Data Modeling, Joins, Relationships, and Different Schemas
Data Modeling, Joins, Relationships, and Different Schemas Introduction In today's data-driven world, organizations generate massive amounts of data f…
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective
SQLite WAL Debug, pgstream v1.1.0, & Postgres Scaling Retrospective Today's Highlights This week's database highlights include a deep dive into SQ…
Discovering PII Inside InterSystems IRIS
Data privacy regulations such as GDPR, LGPD, and HIPAA demand that organizations know exactly where Personally Identifiable Information (PII) lives in…
PostgreSQL HA Risks, Replication Internals, & Rapid Branching
PostgreSQL HA Risks, Replication Internals, & Rapid Branching Today's Highlights Today's highlights include critical insights into Patroni's repli…
Top 12 SQL Interview Problems for Data Engineers, With Answers
I've been on both sides of the SQL interview table somewhere around 20 times in a single job search. The pattern is always the same: candidates know S…
SELECT FINAL and OPTIMIZE FINAL Are Not the Same Thing
One thing that confused me when I first started learning ClickHouse was the word FINAL . Because eventually you'll come across both: SELECT * FROM eve…