Articles by Tag #postgres
Browse our collection of articles on various topics related to IT technologies. Dive in and explore something new!
I Replaced Redis with PostgreSQL (And It's Faster)
I had a typical web app stack: PostgreSQL for persistent data Redis for caching, pub/sub, and...
Postgres is Too Good (And Why That's Actually a Problem)
We need to talk about something that's been bothering me for months. I've been watching indie hackers...
Join the Agentic Postgres Challenge with Tiger Data: $3,000 in Prizes!
UPDATE (11/21): Winner announcement delayed to week of November 24 We're excited to announce our...
I Replaced MongoDB with a Single Postgres Table
Look, I need to show you something that might hurt your feelings: CREATE TABLE MongoDB ( _id ...
Evolving Our Infrastructure: Why We Moved from Heroku Postgres to Neon
We recently completed a major backend migration: moving our primary production database from Heroku...
🚀 Introducing Agentic Postgres: The First & Free Database Built for Agents
Agents are the New Developer 80% of Claude Code was written by AI. More than a quarter of...
🐯 🚀 Timescale is now TigerData: Building the Modern PostgreSQL for the Analytical and Agentic Era
TL;DR: Eight years ago, we launched Timescale to bring time-series to PostgreSQL. Our mission was...
Benchmarking Databases for Real-Time Analytics Applications
Choosing the right database for analytics is hard. With many options available, each is optimized for...
Congrats to the Winners of the Agentic Postgres Challenge with Tiger Data!
The wait is over, thank you all for your patience! We are excited to (finally) announce the winners...
Postgres Is All You Need
When I started working on my second SaaS product, UserJot, I decided to simplify everything about the...
I Taught Postgres to Fight Hackers - And It Worked (Agent Auth)
This is a submission for the Agentic Postgres Challenge with Tiger Data What I...
STOP GUESSING: The Observability Stack I Built to Debug My Failing AI Agents
The RAG pipeline is a black box. I got tired of guessing why my bot retrieved the wrong context, so I...
💻Your GitHub Speaks Louder Than Your Resume: A Tiger Cloud Story🐅
This is a submission for the Agentic Postgres Challenge with Tiger Data What I Built ...
Building Real-Time Log Streaming with PostgreSQL LISTEN/NOTIFY
I needed tail -f for a distributed system. The logs were in PostgreSQL. Users wanted to see them...
Making Redis Optional: Why I’m pivoting to a 'Postgres-First' Architecture and why chose Valkey as alternative
I've spent the last few weeks rethinking the dependency graph of Logtide. Currently, if you want to...
BetterStructureSql - Clean Database Schema Dumps for Rails (Beta)
A pure Ruby gem that generates clean structure.sql files without pg_dump noise. Currently running in 4 production apps. Looking for feedback!
Scaling PostgreSQL Performance with Table Partitioning
Table of contents: The background The investigation The execution The result What we would do...
SQL Dates Finally Made Sense: NOW, AGE, EXTRACT, and Why Time Is Weird
Up until now, SQL felt very… solid. Numbers are numbers. Strings are strings. GROUP BY either works...
VariantLab
Variantlab - Generate Infinite App Variations in Seconds What I...
🐯 FraudSwarn - Multi-Agent Fraud Detection
🐯 FraudSwarn - Multi-Agent Fraud Detection This is a submission for the Agentic Postgres...
Embedding AI Inside PostgreSQL : Building a Native C++ Extension.
The Search for a Native Engine As a developer who values performance and systems...
Cells, Queries, and Chaos: The Game of Life in SQL!
Github Repo: https://github.com/Hetarth02/game-of-life-sql 👾History I have always been...
That Dreaded Alembic NotNullViolation Error (and How to Survive It)
What Happened? Imagine you have a table called organizations full of precious data. You...
Aurora Serverless v2: When "I/O Optimized" Actually Costs You More
A real-world FinOps story about validating Aurora I/O Optimized costs, avoiding CloudWatch billing traps, and why "Free IOPS" isn't always free.
How We Added Folders and Tags to Organize Video Libraries
Your video library starts small. Three recordings, maybe five. You scroll, you find what you need....
How We Achieved Up to 71% Faster Email Search with PostgreSQL Full-Text Search
Overview By migrating our email system's search functionality from traditional LIKE...
SmartPair - An Agent first freelancing platform.
This is a submission for the Agentic Postgres Challenge with Tiger Data Problem that I...
NeuroBase: AI-Powered Conversational Database with Multi-Agent Intelligence
NeuroBase is an intelligent, self-learning conversational database system that transforms PostgreSQL...
Agentic Fork Squad: Multi-Agent Database Query Optimizer with Tiger Cloud Zero-Copy Forks
What I Built AgenticForkSquad (AFS) is an AI-powered database query optimizer that uses multi-agent...
Beyond Routing: Architecting Next-Gen Conversational AI with Dynamic Guidelines and Tiger Cloud Vector Search
This is a submission for the Agentic Postgres Challenge with Tiger Data What I Built I...