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 backend beginners career claude cybersecurity devchallenge devops discuss javascript llm machinelearning mcp node opensource performance productivity programming python security showdev softwareengineering testing tutorial typescript webdev
All EN RU
EN

PostgreSQL Constraint Naming Convention: Which Pattern to Use, and How to Find the Names That Drifted

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Use the pattern PostgreSQL alrea…

postgresdatabasesqlwebdev
Dev.to Oct 19, 2026, 04:24 UTC
EN

🔎 Building IncidentCopilot: Designing a Deterministic Log Correlation Engine

Milestone 4 of IncidentCopilot — an open-source, local-first AI DevOps Incident Copilot 📌 Introduction Logs are plentiful during outages — the chall…

devopsfastapipostgresai
Dev.to Oct 18, 2026, 20:31 UTC
EN

Postgres Logical Replication: Slots, DDL, and Failover

At 2 a.m. on a Tuesday, a client's reporting replica silently stopped applying changes. The publisher kept accepting writes. The replica kept answer…

postgresdatabasedevopscloud
Dev.to Oct 17, 2026, 17:30 UTC
EN

AI code review just delayed PostgreSQL 19. Finding bugs is now cheap and fixing them isn’t.

PostgreSQL 19 was supposed to ship in October. The release team now says general availability is November 19, with RC 2 on November 12 (postgresql.o…

postgresaiopensourcecodereview
Dev.to Oct 17, 2026, 16:30 UTC
EN

I'm building an open-source platform for your database, API, auth and apps

I'm Duc. Since May 2025 I've been building Excalibase on nights and weekends, next to my day job. It started as a GraphQL engine for Postgres, becau…

postgresopensourcewebdevshowdev
Dev.to Oct 17, 2026, 16:30 UTC
EN

Wait, How Did Hackers Steal the Encryption Key Too?" 5 Supabase Security Traps I Fixed in Production

Introduction: The Headline That Made My Stomach Drop Almost every week, we see another headline about a major tech company or hot startup suffering…

supabasepostgressecuritywebdev
Dev.to Oct 17, 2026, 01:18 UTC
EN

One optional phone number, eleven files, five kinds of empty, and no migration

Yesterday I added an optional phone number to Nakodo. When a creator or a business says yes to a brand, the app introduces them by email, and the br…

typescriptpostgresuxwebdev
Dev.to Oct 16, 2026, 10:31 UTC
EN

Setting an env var above your imports does not run before them, and our integration test works anyway

The largest test file in PubTrivia is 543 lines, and it has no mocks in it. It calls the actual server actions a player's phone calls, and the actua…

testingnodetypescriptpostgres
Dev.to Oct 16, 2026, 10:30 UTC
EN

Why Your Coding Agent Forgets Your Refactors (And How I Fixed It in PostgreSQL)

This is a submission for the MLH x DEV Writing Challenge What I Built Here is a bug that drove me crazy for three days straight. You ask an autonomo…

mlhacksdevchallengepostgresai
Dev.to Oct 15, 2026, 08:22 UTC
EN

I built a Supabase-style query client that talks directly to Postgres

I like the Supabase JS client. .from('todos').select('id, task').eq('done', false) reads like what I mean, and { data, error } means I'm not wrappin…

postgresnodetypescriptopensource
Dev.to Oct 14, 2026, 20:25 UTC
EN

Idempotency keys done right: exactly-once effects over at-least-once networks

Why "just retry" creates duplicate payments, and a PostgreSQL-backed design for idempotency keys that survives double clicks, timeouts, crashes and…

apibackenddistributedsystemspostgres
Dev.to Oct 14, 2026, 04:19 UTC
EN

Verifying PostgreSQL Backups Using pg_verifybackup

Pg_verifybackup was introduced in PostgreSQL 13 and is used to check the integrity of a base backup taken using Pg_basebackup against the backup_man…

postgresbackupdatabaseai
Dev.to Oct 10, 2026, 10:27 UTC
EN

Node.js Email Verification Needs Atomic Tokens

Email verification looks like a small feature: create a token, send a message, and accept the token when the user clicks it. In a real Node.js servi…

backendrestapipostgresauthentication
Dev.to Oct 10, 2026, 02:22 UTC
EN

One memory across AI agents: what it actually takes

The memory built into a coding agent lives inside that vendor's tools. What I tell one agent stays with that agent, and the next one I open in the s…

aimcppostgresclaude
Dev.to Oct 9, 2026, 07:21 UTC
EN

REST API Verification Needs an Email Lease

Email verification looks like a simple two-request flow: create an account, send a message, then accept a token. In a production REST API, it is clo…

backendrestapipostgresauthentication
Dev.to Oct 9, 2026, 02:24 UTC
EN

Your multi-tenant SaaS needs a test that tries to leak data

Most multi-tenant SaaS products keep customers apart with one line of code repeated a few hundred times: const invoice = await db . invoice . findFi…

saassecuritypostgrestesting
Dev.to Oct 8, 2026, 11:28 UTC
EN

Zero-Downtime PostgreSQL Upgrade: RDS Blue/Green from version 13 to version 18

PostgreSQL has been the most popular open source database since 2020 and matured over decades. Many organization have already started migrating thei…

postgresawsdatabase
Dev.to Oct 7, 2026, 11:25 UTC
EN

Reading a lending protocol's whole loan book straight from Cardano's ledger

We wanted one number: how far does ADA have to fall before a real share of Indigo's loans gets liquidated? Indigo is a Cardano protocol where you lo…

cardanoblockchainpostgrespython
Dev.to Oct 6, 2026, 21:19 UTC
EN

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

If a unique index suddenly tolerates duplicates, or WHERE email = ... misses a row that a sequential scan finds, the index is sorted by collation ru…

postgresdatabasedevopssql
Dev.to Oct 5, 2026, 22:11 UTC
EN

Why PostgreSQL MVCC Scales Better Than Lock-Based Reads for Read-Heavy Workloads

A dashboard query runs while a background job updates ten thousand rows. In a lock-based engine, that SELECT waits—sometimes for seconds—until every…

postgresmvccvacuumperformance
Dev.to Oct 5, 2026, 11:16 UTC
EN

PostgreSQL Point-in-Time Recovery in Kubernetes: WAL-G + Stolon Pattern

PostgreSQL Point-in-Time Recovery in Kubernetes: WAL-G + Stolon Pattern We recovered a 2TB PostgreSQL database to 14:32:18 yesterday after a botched…

postgreskubernetesbackupdevops
Dev.to Oct 4, 2026, 15:25 UTC
EN

Self-Hosting Supabase for Health Data under GDPR: Lessons From Running a Telemedicine Platform

We run Docto24 , a German telemedicine platform: patients book online consultations, licensed physicians review medical questionnaires and issue e-p…

backenddatabasepostgresprivacy
Dev.to Oct 4, 2026, 11:17 UTC
EN

PostgreSQL Idempotency Keys for Email APIs

Email verification looks like a simple endpoint: accept an address, create a token, send a message, and return 202. In a real REST API, the difficul…

backendrestapipostgresauthentication
Dev.to Oct 3, 2026, 17:23 UTC
EN

REST API Fixtures Need a Cleanup Contract

Integration tests for authentication often fail after the assertion has already passed. The user was created, the verification message arrived, and…

backendrestapipostgrestesting
Dev.to Oct 3, 2026, 02:23 UTC
EN

Database MCP Server: Should an AI Agent Run SQL or Only Read the Schema?

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: For schema work an AI agent need…

aipostgresdatabasesecurity
Dev.to Oct 1, 2026, 01:25 UTC
EN

ON DELETE SET NULL vs CASCADE vs RESTRICT in PostgreSQL: Which to Use

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Pick the action by what the chil…

postgresdatabasesqlwebdev
Dev.to Oct 1, 2026, 01:24 UTC
EN

A PostgreSQL Role That Reads the Schema but Not the Data: What to Grant

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: Grant CONNECT on the database an…

postgresdatabasesecuritysql
Dev.to Oct 1, 2026, 01:23 UTC
EN

Adding a NOT NULL Column to a Large PostgreSQL Table: Constant Default, Backfill or NOT VALID

Disclosure: I build Schemity , a desktop ERD tool - this post is from our blog and uses it for the examples. TL;DR: On PostgreSQL 11 and later, ADD…

postgresdatabasesqlwebdev
Dev.to Oct 1, 2026, 01:22 UTC
EN

Implementing Node.js Postgres Cron Error Capture — Attributing Media Retry Costs

A Node.js notification service should capture each Postgres cron worker background job error as attempt evidence, then create one durable failure re…

observabilitynodepostgres
Dev.to Sep 30, 2026, 18:23 UTC
EN

Split-Brain Needs a Cluster. Mine Happened on One Server.

Today I want to talk about split-brain. The name sounds dramatic, and the problem is dramatic too. One system splits into two halves, and each half…

distributedsystemssystemdesignpostgresinterview
Dev.to Sep 30, 2026, 12:30 UTC

© Tech News — Headline Aggregator

English Русский
Sitemap Legal Notice Privacy Terms Copyright / Removal DSA Contact

Leaving the site

You are about to open an external website:

Continue →