Part 8: Persistence and State - EF Core, Migrations, and Reliability
In the last part, we looked at how expressions make your workflows dynamic. Today, we are discussing the backbone of any production-ready system: Pers…
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
PostgreSQL vs MySQL for API Automation Workflows
What You'll Need n8n Cloud or self-hosted n8n instance Hetzner VPS or Contabo VPS for self-hosted database deployment DigitalOcean as an alternative h…
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…
Room-Inspired Local Persistence in Swift: A Production GRDB Architecture
Introduction If you've built Android apps with Room, you already think in a layered persistence model: entities define your schema, DAOs handle querie…
The Silent Performance Killer in Rails: Understanding and Fixing N+1 Queries
If you've ever investigated a slow Rails endpoint, chances are you've encountered one of the most common performance problems in the Rails ecosystem: …
Why Audit Trails Matter in ClickHouse®: Building Accountability, Compliance, and Security
When teams evaluate database platforms, the conversation usually revolves around performance, scalability, query optimization, and storage efficiency.…
CloudNativePG: Running PostgreSQL in Kubernetes Without the Pain
A CloudNativePG cluster that sits in Setting up primary forever, with zero error events on the Cluster resource and a perfectly healthy operator, is o…
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…
UUID vs ULID vs NanoID: Which Identifier Should You Use in 2026?
A few years ago, choosing an ID format was easy. Most of us generated a UUID, stored it in the database, and moved on. Today things are different. Mod…
Show HN: I replaced database deadlock victim selection with an LLM — here's the data
Every mainstream database uses fixed rules for deadlock victim selection. MySQL kills the one with the fewest locks. CockroachDB kills the youngest. P…
Smart Query-Aware Cache Invalidation: Solving Mongoose Performance at Scale
The Mongoose Caching Problem (And How We Solved It) From 300 RPS to 700+ RPS: A 2.2x Performance Breakthrough When you're building a Node.js applicati…
What is the best real-time analytics database in 2026? An engineering buyer's guide
Traditional databases just can't keep up with high concurrency and low latency at the same time. The term "real-time" has become kind of meaningless. …
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…
Building a SQL Database in Rust: Reducing Memory Usage with Spans and String Interning
I have been working on a PostgreSQL compatible database system in Rust and recently made a couple of changes that significantly reduced unnecessary me…
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…
Metadata Filtering Before Vector Search: The Recall Win Nobody Measures
Book: RAG Pocket Guide: Retrieval, Chunking, and Reranking Patterns for Production Also by me: Thinking in Go (2-book series) — Complete Guide to Go P…
GBase 8c Distributed Cluster Operations: Troubleshooting Common Failures with Hands‑On Fixes
Node crashes, connection storms, shard anomalies, and resource overloads are the most frequent disruptions in a gbase database cluster. This guide dis…
Parse, Don’t Guess
Three days before going open source, I deleted my parser's smartest feature. 333 lines. 6 functions. 12 passing tests. All green, all clever, all gone…
Apache Data Lakehouse Weekly: June 4 to June 11, 2026
The lakehouse community spent this week arguing about versions, and the arguments mattered. Parquet contributors produced the single largest thread ac…
Production-Grade RAG: Why Vector Search Isn't Enough (and How Hybrid Search Fills the Gaps)
Imagine your team just deployed a sleek RAG-based docs assistant for the SaaS platform you develop. In testing, it worked flawlessly. It knows your fu…
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 …
What Designing a Binary Protocol Actually Taught Me
Most developers never have to design a network protocol from scratch. You use HTTP, gRPC, WebSockets, or something else that already exists and has be…
How Databases Impact System Scalability and Speed in Software Engineering
Databases are core to most software systems, and their design directly influences both scalability and performance. Here’s what every engineer should …
Rails Performance Optimization: Fixing N+1 Queries with includes, preload, and eager_load
Originally published on Hashnode: https://railswithyashika.hashnode.dev/rails-performance-n-plus-one-queries When working with associations in Rails, …
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 …
Database Optimization Techniques for High-Traffic Laravel Applications
Your Laravel app works great in development. A few hundred users hit it in production and suddenly query times balloon, your server sweats, and you're…
100 Days of ClickHouse® – Day 6: Importing CSV Files into ClickHouse®
CSV files are one of the most common formats for storing and exchanging data. Whether you’re working with logs, analytics data, application exports, o…
From Raw SQL Strings to Type-Safe Queries: How I Learned Prisma ORM
I'm a web design agency CEO teaching myself full-stack development in public. This is week 7 of a 16-week roadmap I built to go from React-only to ful…
The Future of Query Optimization: AI-Driven Insights in Big Data
Query optimization has never been a solved problem. The moment you think your database is running efficiently, data volumes triple, access patterns sh…