Why Soft Deletes Are Breaking Your SaaS Database (And How to Fix It) 🛑
The Soft Delete Trap In Laravel, enabling SoftDeletes is as easy as adding a trait to your Eloquent model and a deleted_at timestamp to your migration…
Programming
⚑ Report a ProblemLatest Programming news from Tech News
All topics
AI
Gear
Tech
agents
ai
api
architecture
automation
aws
beginners
career
claude
database
devchallenge
devops
javascript
llm
machinelearning
mcp
opensource
performance
productivity
programming
python
rust
security
showdev
tutorial
typescript
webdev
SQL Basics: Talking to a Database for the First Time
Every company you will ever work for stores its data in a database. Not CSV files. Not Excel sheets. A database. Tables of users. Tables of transactio…
Turning Manual Ops Into a 10-Minute Task
I once turned a 2-week manual data update process into a 10-minute automated pipeline by writing a PHP script that ingested a vendor spreadsheet, norm…
Adding Semantic Search to Your Postgres App with pgvector
pgvector is a Postgres extension that adds vector storage and similarity search to an existing database, so you can run semantic queries directly agai…
Arrowjet is now a Cross-Database Sync Tool in Python (PG, MySQL, Redshift)
I've been building Arrowjet, an open-source Python library for fast bulk data movement. It started as a Redshift speed tool, but it now supports Postg…
Vector Databases for RAG: Pinecone vs. Weaviate vs. Milvus vs. PGVector 0.8 (PostgreSQL 18)
In 2024, 72% of RAG pipelines fail production due to vector database misconfiguration, costing teams an average of $42k in wasted compute and rework. …
I indexed 17,341 polynomial fan curves in Postgres and matched a duty point in <100ms
Most B2B HVAC catalogs publish fan performance curves as scanned PDFs. Engineers do the interpolation by eye when they need to know "will this fan del…
Ruby on Rails Has Scalability Issues. Here's How We Solved Them
Every few months someone declares Rails dead. Then Shopify reports another record Black Friday. In 2025, Shopify's Rails monolith handled 489 million …
The Database Bottleneck You Never Saw Coming: Why 50ms Will Make or Break Your AI Agent in 2026
The uncomfortable truth about AI infrastructure that nobody is talking about — and why your stack might be optimizing for the wrong metric In February…
Migrating From a JSON Column to a Proper Schema in Postgres
Book: Database Playbook: Choosing the Right Store for Every System You Build My project: Hermes IDE | GitHub — an IDE for developers who ship with Cla…
Build an AI teammate to help with your Postgres
Think about those times on team calls when a simple question like “Can someone check the latest sales numbers?” puts the meeting to a pause while some…
Deadlock-Free by Construction: How Typhon Eliminates Deadlocks Instead of Detecting Them
💡Typhon is an embedded, persistent, ACID database engine written in .NET that speaks the native language of game servers and real-time simulations: en…
Unified Memory Core for AI Agents
A practical guide to building episodic, lexical, vector, and graph memory workflows in Oracle AI Database Companion notebook: Unified Agent Memory wit…
PostgreSQL Index Usage and Optimization
PostgreSQL Index Usage and Optimization Indexing is the single biggest lever in SQL performance, and it is also the category where most of the bad adv…
Notion Database Limits & Workarounds — 7 Walls Every Power User Hits
Notion Database Limits & Workarounds — 7 Walls Every Power User Hits Why Notion Databases Break Down for Personal Use Notion is famous as "the too…
MongoDB Associate Developer Certification: A Complete Preparation Guide
This article was written in collaboration with @v_laxmi_sahithi , @asksamyukthaa , @likitha_konyala and @chanda_rajkumar . In today’s data driven worl…
MongoDB Overview and Preparation Guide
In today’s data driven world, data is at the core of almost every application. But managing large volumes of data efficiently is a crucial skill for d…
Time-Series, Document, or Relational? The 5-Question Test Every New Project Needs
Book: Database Playbook My project: Hermes IDE | GitHub — an IDE for developers who ship with Claude Code and other AI coding tools Me: xgabriel.com |…
pg_ilib: Compact Typed Binary Serialization for PostgreSQL
The problem PostgreSQL's bytea type is powerful for storing raw binary data, but it carries no type information. Once you store a value as bytes, you …
Choosing Postgres, MongoDB, or DynamoDB: The 4 Questions That Actually Decide It
Book: Database Playbook My project: Hermes IDE | GitHub — an IDE for developers who ship with Claude Code and other AI coding tools Me: xgabriel.com |…
Postgres With pgvector vs Pinecone: 1 Million Embeddings, One Honest Comparison
Book: Database Playbook: Choosing the Right Store for Every System You Build Also by me: RAG Pocket Guide: Retrieval, Chunking, and Reranking Patterns…
5 RAG Failure Modes Nobody Warns You About in the Tutorials
Book: RAG Pocket Guide: Retrieval, Chunking, and Reranking Patterns for Production Also by me: Database Playbook: Choosing the Right Store for Every S…
Why PostgreSQL EXPLAIN ANALYZE Can Mislead You — and What to Use Instead
EXPLAIN ANALYZE is the standard tool for understanding how PostgreSQL runs a query. It shows the chosen plan, estimated and actual row counts, and exe…
🍕 Database Sharding Explained Like You're 5
Splitting data across servers Day 121 of 149 👉 Full deep-dive with code examples The Library Card Catalog Analogy One huge card catalog is hard to use…
Anti-Join in MongoDB
SQL databases implement anti-joins—finding rows with no match—through NOT EXISTS. Although anti-join is not a distinct relational algebra operator, it…
Day 66: Why Point-in-Time Recovery is the first button you should click in DynamoDB
Today on Day 66 of my Serverless Financial Agent build, things went south. While connecting a real banking API (Wise) to replace my sandbox data, my D…
N+1 Query Detection and Prevention in Laravel Production Apps
The N+1 query problem is the most common performance issue in Laravel applications, and it's the easiest to introduce accidentally. A developer adds $…
6 Essential SQL Concepts Every Beginner Should Master
Introduction. Starting your journey with SQL can feel like staring at a massive wall of syntax. But here’s a secret: you don’t need to know everything…
From RocksDB Pain to GraniteDB Gain: Building a Blockchain-First Storage Engine in Rust
Building Ferrous Network exposed the limits of general-purpose databases. Here's why I'm writing GraniteDB from scratch. Hey folks, Altug here — found…
The Five Most Important Columns to Add to Every Database Table
Let me tell you about one of the worst days of my career. A client called me, furious. Corrupted records, no idea who changed what, no idea when anyth…