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…
Latest Web news from Tech News
All topics
AI
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
learning
linux
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
react
security
showdev
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…
Why AI Agents Make Me Reach for SQLite
Lately I keep reaching for SQLite where, before, I'd have reached for Postgres without thinking. It started with small services, then a bigger questio…
Your circuit breaker stops at the service layer. Slow SQL needs one too.
Your circuit breaker stops at the service layer. Slow SQL needs one too. A single slow query can take down an entire service in seconds. This post sta…
I'm building CortexDB — an agent-native context database for AI agents
I'm building CortexDB — an agent-native context database for AI agents Most modern RAG systems work like this: Split documents into chunks Generate em…
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…
Your AI Agent Can Run DROP TABLE on Production
Your AI agent just ran DELETE FROM users without a WHERE clause. It was trying to remove a single test account, hallucinated the query, and wiped your…
Don't parse SQL to make a query runner read-only
Say you're building a tool that lets people run ad-hoc SQL against a database, and you want a read-only by default mode — a safety net so a fat-finger…
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.…
Building a Natural Language Query Interface for Your Database: A Developer's Blueprint
Every product team eventually hits the same wall. Marketing wants to know which signups came from last week's campaign. Support wants a list of custom…
SQLite Backup Strategy for Production SaaS: WAL, Litestream, Recovery Tests
Running SQLite in production for a multi-tenant SaaS means giving up the operational comfort of a managed database. No automatic backups, no point-in-…
Scaling to a Billion Rows: PostgreSQL Partitioning in Laravel 🐘
The 100-Million Row Wall In enterprise B2B SaaS platforms at Smart Tech Devs, tracking historical data is a compliance requirement. Tables like audit_…
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…
Redis Isn't Just a Cache: 14 Use Cases (System Design)
You're probably using Redis for one job. There are 13 more, and a few of them work in ways that surprised me even after years of using it. I just publ…
Your Hand-Rolled Two-Phase Commit Between Two Databases Isn't Atomic
I had a write that spanned two physically separate databases. A rename that had to propagate across several tables in one database and a couple of tab…
Dynamic Column Updates in EF Core Without Hand-Rolling SQL Injection
Sometimes you genuinely need the set of columns to update to be data, not code. An operator maps configuration fields to database columns, and you wan…
Postgres or ClickHouse? Row vs Column Storage, and When Each Wins
PostgreSQL and ClickHouse both speak SQL, both call themselves databases, and both will happily store your data. That surface similarity gets teams in…
What Drags Down Throughput in GBase 8a Bulk Loading — and Where to Look First
When loading large volumes into a gbase database cluster, stability matters far more than a single peak throughput number. The same 500 GB data set ta…
Pagination records using JooqTemplate
Paginated queries with automatic total count calculation. Supports specifying result fields. public < E > LimitResult < List < E >, E &…
How we cut our Dagster Cloud bill by 60% by collapsing our dbt assets
If your team is using Dagster Cloud's Solo or Starter tiers, the May 2026 pricing update probably gave you a bit of a shock . By removing the monthly …
Surviving the region you run in: failover on Aurora DSQL, and what the demo proves
The thesis Quorum is built on is uncomfortable and true: the tools a team uses to coordinate an incident often live in the same region as the thing th…
Optimistic concurrency is the whole design: event sourcing on Aurora DSQL
Quorum is an incident command plane built on Amazon Aurora DSQL. The failover story lives in another post. This one is about a narrower question that …
The Deep Mechanics of Online Bulk Deletion in PostgreSQL
MVCC, WAL, vacuum, and replication slots under sustained delete load - and how to delete billions of rows without your database noticing Most "how to …
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…
GBase 8a Security Hardening: Permissions, Password Policies, SSL Encryption, and Audit Logs
This guide provides a complete security hardening checklist for a gbase database cluster, covering user privileges, password policies, SSL encryption,…