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…
Testing & QA
⚑ Report a ProblemLatest Testing & QA news from Tech News
All topics
agents
ai
api
architecture
automation
aws
beginners
career
claude
cybersecurity
database
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
testing
tutorial
typescript
webdev
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…
When Kubernetes Isn't the Problem: Debugging External Dependencies in AKS
Introduction One of the most common mistakes during incident response is assuming Kubernetes is the problem simply because the application runs on Kub…
Stop Hiding SQL Behind Your ORM: jOOQ, JPA, and JDBC Under Production Load
Most persistence debates in Java are framed incorrectly. The question is not: Should we use JPA, jOOQ, or JDBC? The real question is: Is this part of …
SQL Оконные функции простым языком
Каждый SQL-разработчик помнит свое первое столкновение с конструкцией OVER(). Когда после понятных и уютных SELECT и GROUP BY ты видишь этот перегруже…
SQL Formatting Best Practices: A Practical Guide for Engineers
SQL is arguably the most widely used language in software engineering, yet it is often the least carefully written. Most teams enforce strict linting …
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning
DuckDB 1.5.3 & Quack Protocol Release; PostgreSQL File Descriptor Tuning Today's Highlights This week's database news highlights significant advan…
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s
DuckDB Integrates Lance Lakehouse; SQLite CVE Fix; Postgres 19 Beta on K8s Today's Highlights This week, DuckDB introduces integrated vector and hybri…
I got tired of writing the same history table boilerplate, so I built a Postgres extension
There's this problem I kept running into - first during my internship, then again on a freelance project I picked up afterward. Both of them used Post…
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture
SQLite Optimizer Deep Dive, Change-Set Internals & Azure PostgreSQL Architecture Today's Highlights This week, we explore SQLite's query planner o…
How I Cut 769 Database Queries With One Window Function
From Grafana to Real Performance Gains I noticed in the Grafana dashboard that GET /api/v1/dokter/public/jadwal-dokter was on average taking 1 second …
The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer
Most candidates treat the take-home assessment as a coding test. It is not. It is a professional communication test that happens to include coding. Th…
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns
PostgreSQL 19 Graph Queries & REPACK; SQLite Advanced SQL Patterns Today's Highlights PostgreSQL 19 introduces major features with SQL/PGQ for gra…
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip
Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip TL;DR: Composite primary keys, partial unique indexes, cr…
How I Exported 1 Million+ Oracle Records to CSV in Under 30 Seconds Using Node.js
The Problem During the modernization of a legacy enterprise application, one feature initially appeared deceptively simple: Export data to CSV. The le…
I built a release intelligence agent in 4 days with Coral, Groq, and Claude Code. Here's the exact route
5 days. Solo. First hackathon. One dashboard that tells you whether to ship. This is not a polished retrospective. This is the actual route I took — w…
SQL-like Queries in FSRS Plugin for Obsidian
SQL-like Queries in FSRS Plugin for Obsidian Spaced repetition in Obsidian usually works as "show all cards with due earlier than today." That's enoug…
Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js
If you've spent most of your career building beautiful UIs, managing state, and wrestling with CSS, the backend can feel like someone else's problem. …
MP3 - SQLi, XSS, and CSRF WriteUp
Introduction For Machine Problem 3, our group — Aki, Lark, and Carl — was tasked with finding and fixing security vulnerabilities in a sample web appl…
SQL Pattern Series #1: The Presence Pattern
Thinking in terms of existence instead of lists SQL Pattern Series #1 of 21 A collection of practical SQL patterns that help developers recognize comm…
SQL Injection Protection in Flask: A Practical Guide. Part 5 of e2ee chat series
The Problem Most developers think their database is safe. It's not. SQL injection attacks can destroy everything. What is SQL Injection? If you write …
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm
SQLite Bugfix, PostgreSQL Migrations & Filesystem API Paradigm Today's Highlights This week, we dive into a critical SQLite predicate evaluation b…
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?
Both SchemaSpy and SchemaCrawler are free, open-source tools for documenting and analysing relational databases over JDBC. Both have been around for o…
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns
SQLite Internals, PostgreSQL Performance & Multi-Tenancy Patterns Today's Highlights This week, we dive into SQLite's build process with SQLITE_DQ…
How I Built an End-to-End HR Attrition Dashboard Using MySQL & Power BI
Losing great employees is incredibly expensive for businesses. To show potential employers how I tackle real-world business problems using data engine…
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives
DuckDB Delta, PostgreSQL 17 Migration, & SQLite Optimization Deep Dives Today's Highlights This week features significant advancements for DuckDB'…
The N+1 Query That Killed Our Database, And How I Fixed It
Everything Worked…But Not Well APIs are affected by the way data is retrieved from the database, and that's something that affected a recent teammate …