Database Migrations & Seeders: Stop Writing Manual SQL Scripts
If you've ever said "I forgot to run the ALTER TABLE on production" — this post is for you. Manual database changes are one of the most common causes …
Latest DevOps news from Tech News
If you've ever said "I forgot to run the ALTER TABLE on production" — this post is for you. Manual database changes are one of the most common causes …
Когда сервис поднимается по 8-15 минут, команда почти всегда начинает крутить одни и те же ручки: увеличивает initialDelaySeconds, добавляет startupPr…
TL;DR: Agent memory is stored state an AI agent can retrieve across sessions to maintain continuity. A bigger context window does not fix the problem.…
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…
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…
pgvector is a Postgres extension that adds vector storage and similarity search to an existing database, so you can run semantic queries directly agai…
In 2024, 72% of RAG pipelines fail production due to vector database misconfiguration, costing teams an average of $42k in wasted compute and rework. …
Every few months someone declares Rails dead. Then Shopify reports another record Black Friday. In 2025, Shopify's Rails monolith handled 489 million …
The uncomfortable truth about AI infrastructure that nobody is talking about — and why your stack might be optimizing for the wrong metric In February…
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…
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…
💡Typhon is an embedded, persistent, ACID database engine written in .NET that speaks the native language of game servers and real-time simulations: en…
A practical guide to building episodic, lexical, vector, and graph memory workflows in Oracle AI Database Companion notebook: Unified Agent Memory wit…
Notion Database Limits & Workarounds — 7 Walls Every Power User Hits Why Notion Databases Break Down for Personal Use Notion is famous as "the too…
This article was written in collaboration with @v_laxmi_sahithi , @asksamyukthaa , @likitha_konyala and @chanda_rajkumar . In today’s data driven worl…
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…
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 |…
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 |…
Book: Database Playbook: Choosing the Right Store for Every System You Build Also by me: RAG Pocket Guide: Retrieval, Chunking, and Reranking Patterns…
Book: RAG Pocket Guide: Retrieval, Chunking, and Reranking Patterns for Production Also by me: Database Playbook: Choosing the Right Store for Every S…
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…
SQL databases implement anti-joins—finding rows with no match—through NOT EXISTS. Although anti-join is not a distinct relational algebra operator, it…
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…
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 $…
Building Ferrous Network exposed the limits of general-purpose databases. Here's why I'm writing GraniteDB from scratch. Hey folks, Altug here — found…
Every growing business hits this wall at some point. The application that worked perfectly six months ago now takes forever to load. Users start compl…
Author: Matthew Penaroza I have spent a lot of time working on large-scale agent architectures with some of the largest organizations in the world, an…
A local-first platform where users own their data cryptographically — built on encrypted SQLite, CRDTs, and libp2p. Here is the simplest thing you can…
Cursor Rules for MongoDB: The Complete Guide to AI-Assisted MongoDB Development MongoDB is the database where "schemaless" gets sold as a feature for …
I built youjustneedpostgres.com to argue that most teams could use Postgres for almost everything. For queues, for search, for documents. The recommen…