Tech News
All News AI & ML Architecture DevOps Open Source Programming Team Management Testing & QA Web

Testing & QA

⚑ Report a Problem

Latest 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
All EN RU
EN

TimescaleDB 2.27 Added Bloom Filters to UPDATE and DELETE. Your EXPLAIN Won't Tell You If They Work Unless You Know These Counters.

TimescaleDB 2.27, released May 12 2026, extends bloom-filter batch pruning from reads to writes. UPDATE, DELETE, and UPSERT against compressed columns…

postgresdatabaseperformance
Dev.to Jul 31, 2026, 15:31 UTC
EN

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…

backenddatabasesearchsql
Dev.to Jul 31, 2026, 09:33 UTC
EN

Introducing SequelizeDotNet: Bringing Sequelize.js's Database-First Philosophy to .NET

A database-first, explicit-DDL ORM for .NET — runtime-emitted entity types, JOIN-free eager loading, CDC push notifications, and schema-driven GraphQL…

sequelizeormprismadatabase
Dev.to Jul 31, 2026, 06:13 UTC
EN

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…

databasepythonsqlopensource
Dev.to Jul 29, 2026, 21:11 UTC
EN

LioranDB V2 Pre-Alpha Benchmark Summary

Over the past few weeks I've been benchmarking LioranDB V2 , a document database engine written completely from scratch in Rust . Instead of publishin…

liorandbnosqldatabaseindian
Dev.to Jul 29, 2026, 13:26 UTC
EN

Fast at Lunch. Slow at Scale: Why Your App Gets Slow When Real Data Arrives

A page that feels instant with a few users can become painfully slow when your business grows. The code hasn’t changed. The server hasn’t changed. The…

dotnetperformancedatabaseprogramming
Dev.to Jul 29, 2026, 05:05 UTC
EN

A database failover can preserve uptime and break the answer

A PostgreSQL MCP server can remain available during failover and still return the wrong answer. The connection retries against a replica. The replica …

postgresmcpdatabasetesting
Dev.to Jul 28, 2026, 01:21 UTC
EN

How to Build Rock-Solid Real-Time Data Pipelines from the Factory Floor IoT

Lessons from hooking up stamping presses, welding cells, and MES without dropping a single byte of data. If you’ve ever been tasked with trying to fee…

aiiotdatabaseproductivity
Dev.to Jul 27, 2026, 08:45 UTC
EN

How to secure Manticore Search with built-in authentication and authorization

Search is often treated as infrastructure. In production, though, it behaves much more like an application API. It accepts user traffic, exposes busin…

backenddatabasesearchsecurity
Dev.to Jul 27, 2026, 05:54 UTC
EN

Building SaarDB, Part 4: Transactions

In Parts 1-3, we built a storage engine: WAL, memtable, SSTables, and compaction. Every operation is a single GET or PUT. But real applications rarely…

architecturebackenddatabase
Dev.to Jul 26, 2026, 22:21 UTC
EN

Optimizing Large-Scale MongoDB Aggregation Pipelines: A Deep Dive into Performance Strategies

Originally published on tamiz.pro . MongoDB's aggregation framework is a powerful tool for processing and transforming data. However, as datasets grow…

databaseoptimizinglargemongodb
Dev.to Jul 26, 2026, 18:00 UTC
EN

X-MaP (Cross-Mapped Programming): Treating the Header Row as a Schema, Rows as Instances, and Columns as Lazy Properties

A Japanese-language version of this article is available on Zenn . I've prepared a blank map. Fill in what you need, as your own — and draw the shippi…

architecturedesigndatabaseprogramming
Dev.to Jul 26, 2026, 05:26 UTC
EN

Postgres RLS multi-tenancy: two traps that silently disable your policies

Most multi-tenant applications keep tenants apart with one line of code, repeated forever: SELECT * FROM documents WHERE organization_id = $ 1 That li…

postgresdatabasesecuritywebdev
Dev.to Jul 25, 2026, 21:02 UTC
EN

Defeating the Multi-Tenant SaaS Concurrency Trap in PostgreSQL

Most backend engineers implement multi-tenant quota checks using a standard "read-then-write" pattern. In production, this pattern is highly unsafe: S…

postgressaasdatabasebackenddevelopment
Dev.to Jul 25, 2026, 06:34 UTC
EN

A Practical Guide to Azure PostgreSQL: Migration, Replicas, and Tuning ☁️🐘

In this post, I summarize my hands-on experience completing the Microsoft Applied Skills: Configure and migrate to Azure Database for PostgreSQL asses…

azurepostgresdatabasecloud
Dev.to Jul 25, 2026, 02:12 UTC
EN

I Didn't Plan to Build an Offline-First Attendance System. Firestore Forced Me To.

How accidentally exhausting Firestore's free-tier limit transformed a rushed MVP into a more resilient anti-proxy attendance system. Introduction When…

databasefirebaseprogrammingsoftware
Dev.to Jul 24, 2026, 19:39 UTC
EN

Inside LioranDB's Full-Text Search Segments

A normal secondary index can answer: status = "active" It cannot efficiently answer: documents containing "distributed database" LioranDB therefore ha…

liorandbnosqldatabaseindian
Dev.to Jul 24, 2026, 18:54 UTC
EN

Why LioranDB Uses LSM-Based Secondary Indexes

A document database usually stores a primary record by document ID. But applications also ask questions such as: Find users where status = "active" Fi…

liorandbnosqldatabaseindian
Dev.to Jul 24, 2026, 18:53 UTC
EN

Redis Data Structures: An Overview

The reason Redis solves so many problems is that it isn't one thing, it's a collection of data structures, each with commands tuned for a specific acc…

redisdatabasebackendperformance
Dev.to Jul 24, 2026, 00:50 UTC
EN

Syncle: keep any two databases in sync, live and across engines

You have a row in Postgres. You want that same row in MongoDB — not tonight in a batch job, but the instant it changes. And next month you'll want it …

databasetypescriptopensourcewebdev
Dev.to Jul 23, 2026, 18:07 UTC
EN

Database Migrations: Managing Schema Changes as Version-Controlled Code

Database Migrations: Managing Schema Changes as Version-Controlled Code A practical guide to database migrations — the discipline of evolving a databa…

databaseprogramminglearning
Dev.to Jul 23, 2026, 15:03 UTC
EN

Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

Introduction One of the key goals of recent ClickHouse® releases has been improving compatibility with the ANSI SQL standard. While ClickHouse has alw…

clickhousedevopsdatabaseanalytics
Dev.to Jul 23, 2026, 14:01 UTC
EN

Turning an existing database into a documented Laravel API

The projects I dread are the ones where the database is the only documentation. Twenty tables, foreign keys, years of production data, and either no A…

laravelphpdatabaseapi
Dev.to Jul 22, 2026, 11:04 UTC
EN

Why KoutenDB Exists: You Know the Center, Not the Boundary

Most database queries begin by describing the answer. You provide a primary key, write a SQL predicate, select a collection, enter search terms, or se…

databasewebdevaiopensource
Dev.to Jul 22, 2026, 08:04 UTC
EN

Teaching an AI to read a relational database — including Oracle APEX

A few months back I started building a tool to solve a problem that kept annoying me: when you want an AI assistant to help with an old database, you …

oracleapexaidatabase
Dev.to Jul 22, 2026, 07:49 UTC
EN

My OpenCode Database Was Mostly Empty Space

OpenCode keeps a lot of useful history. That is one of the reasons I like it. A coding-agent session is not just a chat transcript. It is a record of …

agentsdatabaseprogrammingsoftware
Dev.to Jul 22, 2026, 07:47 UTC
EN

Implementing Row-Level Access Control

Part 3 of the Omnismith "Core Platform Capabilities" series Securing data inside shared multi-tenant environments requires robust authorization bounda…

programmingsecuritydatabasestartup
Dev.to Jul 21, 2026, 20:07 UTC
EN

Your GraphRAG stack is two databases. It should be one.

Most GraphRAG systems today are built with at least two storage layers. One system stores vectors. Another system stores relationships. The vector dat…

rustdatabaseaiopensource
Dev.to Jul 21, 2026, 11:00 UTC
EN

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 …

performancedatabasebackendsql
Dev.to Jul 20, 2026, 19:06 UTC
EN

Day 88 - Upgrading to ClickHouse® 26.3 LTS: A Step-by-Step Safe Guide

Introduction Upgrading a database is much more than installing a newer version. It requires careful planning to preserve data integrity, maintain appl…

clickhousedevopsanalyticsdatabase
Dev.to Jul 20, 2026, 17:54 UTC

© Tech News — Headline Aggregator

Sitemap Legal Notice Privacy Terms Copyright / Removal DSA Contact

Leaving the site

You are about to open an external website:

Continue →