▶ Videos →

📰 Dev.to · Polliog

9 articles · Updated every 3 hours · View all reads

All Articles 173,167 Blog Posts 163,817 Tech Tutorials 46,199 Research Papers 33,874 News 21,839 ⚡ AI Lessons

TigerFS: A Filesystem Backed by PostgreSQL

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 4mo ago

TigerFS: A Filesystem Backed by PostgreSQL

TigerFS is a filesystem backed by PostgreSQL, built by the Timescale team. It mounts a database as a...

Your Node.js App Is Probably Killing Your PostgreSQL (Connection Pooling Explained)

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 5mo ago

Your Node.js App Is Probably Killing Your PostgreSQL (Connection Pooling Explained)

A few months ago I was looking at why a PostgreSQL instance was running at 94% memory on a server...

I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 5mo ago

I Ditched Prisma for Raw SQL (And My Queries Got 10x Faster)

Prisma is genuinely good software. The schema DSL is clean, the type generation works well, and for a...

Your API Responses Are 40x Larger Than They Need to Be

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 5mo ago

Your API Responses Are 40x Larger Than They Need to Be

I was profiling a production API last year when I noticed something that should have been obvious...

I Removed Redis From My Stack and Used PostgreSQL for Job Queues Instead

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 5mo ago

I Removed Redis From My Stack and Used PostgreSQL for Job Queues Instead

Every Node.js project eventually needs background jobs. Send this email. Process this file. Run this...

PostgreSQL JSONB GIN Indexes: Why Your Queries Are Slow (And How to Fix Them)

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 6mo ago

PostgreSQL JSONB GIN Indexes: Why Your Queries Are Slow (And How to Fix Them)

You added a JSONB column. You created a GIN index. Your queries are still doing sequential...

TimescaleDB Outperforms MongoDB for JSON Logs (100M Document Benchmark)

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 6mo ago

TimescaleDB Outperforms MongoDB for JSON Logs (100M Document Benchmark)

When building Logtide, we needed to store millions of JSON log documents. The "obvious" choice seemed...

Building Real-Time Log Streaming with PostgreSQL LISTEN/NOTIFY

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 7mo ago

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...

I Replaced Redis with PostgreSQL (And It's Faster)

Dev.to · Polliog 🔧 Backend Engineering ⚡ AI Lesson 7mo ago

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...