Philip McClarence - DEV Community

Philip McClarence

Apr 10

PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search

#database #performance #postgres #sql

4 min read

Philip McClarence

Apr 9

PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained

#database #dataengineering #postgres #sql

4 min read

Philip McClarence

Apr 8

PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting

#database #monitoring #postgres #tutorial

4 min read

Philip McClarence

Apr 7

MyDBA.dev vs Percona PMM: Deep PostgreSQL Intelligence vs Multi-Database Monitoring

#database #monitoring #postgres #tooling

4 min read

Philip McClarence

Apr 6

MyDBA.dev vs pgwatch: Metrics Collection vs Actionable Intelligence

#database #monitoring #opensource #postgres

4 min read

Philip McClarence

Apr 5

MyDBA.dev vs Datadog Database Monitoring: PostgreSQL-Native vs Full-Stack Observability

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Apr 4

MyDBA.dev vs pganalyze: Which PostgreSQL Monitor Should You Choose?

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Apr 3

XID Wraparound Recovery: The Runbook Your Database Needs Before It's Too Late

#database #devops #monitoring #postgres

4 min read

Philip McClarence

Apr 2

WAL and Vacuum Monitoring: The Two Metrics That Predict Every Outage

4 min read

Philip McClarence

Apr 1

Wait Event Heatmaps: See What PostgreSQL Is Actually Waiting On

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Mar 31

Isolating the Query Type That's Killing Your Database

4 min read

Philip McClarence

Mar 30

Schema Diff: Catch Drift Between Staging and Production

#cicd #database #devops #sql

4 min read

Philip McClarence

Mar 29

Interactive Replication Topology: See Your Cluster at a Glance

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Mar 28

From $1 Placeholders to Executable Queries: Debugging the Parameters That Matter

#database #monitoring #performance #postgres

4 min read

Philip McClarence

Mar 27

Catching Query Plan Regressions Before They Become Incidents

4 min read

Philip McClarence

Mar 26

Finding the Missing Indexes Your Queries Are Begging For

#backend #database #performance #sql

3 min read

Philip McClarence

Mar 25

Visualizing Lock Chains: Find the Root Blocker in Seconds

#database #performance #postgres #sql

1

4 min read

Philip McClarence

Mar 24

The Index Advisor That Checks Your Replicas Before Recommending a DROP

3 min read

Philip McClarence

Mar 23

Tracking Your Database Health Score Over Time

#database #monitoring #performance #postgres

3 min read

Philip McClarence

Mar 22

75 Automated Health Checks That Tell You Exactly What to Fix

3 min read

Philip McClarence

Mar 21

The Slow Query Hidden Inside Your PL/pgSQL Function

#database #performance #postgres #sql

5 min read

Philip McClarence

Mar 20

12 Free PostgreSQL Tools That Run Entirely in Your Browser

4 min read

Philip McClarence

Mar 19

One Dashboard for Your Entire PostgreSQL Fleet

#database #monitoring #postgres #tooling

2

4 min read

Philip McClarence

Mar 18

Automatic EXPLAIN Plan Collection: Stop Guessing Why Queries Are Slow

#automation #database #monitoring #performance

1

4 min read

Philip McClarence

Mar 17

How AI Turns a 27-Point EXPLAIN Plan Audit Into One-Click Query Fixes

#ai #database #performance #postgres

1

9 min read

Philip McClarence

Mar 17

PostgreSQL Alerting That Tells You Why, Not Just What

#database #monitoring #postgres #sre

1

4 min read

Philip McClarence

Mar 17

Best Database Monitoring Tools in 2026: A PostgreSQL DBA's Guide

#database #monitoring #postgres #tooling

1

11 min read

Philip McClarence

Mar 16

Real-Time Session Monitoring: See Every Active Query Right Now

3 min read

Philip McClarence

Mar 16

Best PostgreSQL Migration Tools: Schema Changes Without Downtime

13 min read

Philip McClarence

Mar 15

Preventing XID Wraparound on TimescaleDB Hypertables

#architecture #database #performance #postgres

4 min read

Philip McClarence

Mar 15

Best PostgreSQL IDE and GUI Tools in 2026

#database #postgres #productivity #tooling

2

14 min read

Philip McClarence

Mar 14

PostGIS After pg_upgrade: Fixing Version Mismatches and Broken Functions

#database #devops #postgres #tutorial

1

4 min read

Philip McClarence

Mar 14

Debugging Stale Continuous Aggregates in TimescaleDB

#database #monitoring #performance #postgres

1

4 min read

Philip McClarence

Mar 13

PostGIS SRIDs Explained: Why Your Spatial Queries Return Wrong Results

#database #postgres #sql #tutorial

3 min read

Philip McClarence

Mar 13

PostgreSQL vs MySQL vs SQLite: Choosing the Right Database for Your Project

#architecture #database #postgres #sql

11 min read

Philip McClarence

Mar 12

PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans

#database #performance #postgres #sql

2

3 min read

Philip McClarence

Mar 12

Query Planning Overhead with Many Chunks (And How to Fix It)

#database #performance #postgres #sql

4 min read

Philip McClarence

Mar 12

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

#architecture #database #postgres #sql

11 min read

Philip McClarence

Mar 11

Monitoring TimescaleDB in Production: A Complete Checklist

#database #monitoring #postgres #sql

1

4 min read

Philip McClarence

Mar 11

PostgreSQL vs MySQL vs MongoDB: The Definitive Database Comparison

#database #mongodb #postgres #sql

2

15 min read

Philip McClarence

Mar 10

TimescaleDB Memory Tuning: shared_buffers, work_mem, and Chunk Sizing

#architecture #database #performance #postgres

1

4 min read

Philip McClarence

Mar 10

Best PostgreSQL Hosting in 2026: RDS vs Supabase vs Neon vs Self-Hosted

#backend #cloud #database #postgres

1

14 min read

Philip McClarence

Mar 9

PostGIS Geometry Quality: Invalid Geometries, Mixed SRIDs, and Complexity

#database #postgres #sql #tutorial

1

3 min read

Philip McClarence

Mar 9

INSERT Performance Tuning for TimescaleDB

#database #performance #postgres #sql

2

4 min read

Philip McClarence

Mar 8

TimescaleDB Continuous Aggregates: Real-Time vs Materialized-Only

#database #performance #postgres #sql

1

4 min read

Philip McClarence

Mar 8

PostgreSQL Query Optimization: 10 Techniques That Actually Work

#database #performance #postgres #sql

1

12 min read

Philip McClarence

Mar 7

Running PostgreSQL on Kubernetes: Operators, Storage and Production Guide

#database #devops #kubernetes #postgres

11 min read

Philip McClarence

Mar 7

Scaling pgvector: Memory, Quantization, and Index Build Strategies

#ai #database #performance #postgres

1

4 min read

Philip McClarence

Mar 6

PostgreSQL High Availability: Patroni, Replication and Failover Patterns

#architecture #database #postgres #sre

1

12 min read

Philip McClarence

Mar 6

TimescaleDB Compression: A Complete Guide to 95%+ Storage Reduction

#database #performance #postgres #tutorial

1

4 min read

Philip McClarence

Mar 5

Neon Postgres Review: Is Serverless PostgreSQL Ready for Production?

#architecture #database #postgres #serverless

1

13 min read

Philip McClarence

Mar 5

How TimescaleDB Chunks Actually Work (And Why Size Matters)

#architecture #database #performance #postgres

2

4 min read

Philip McClarence

Mar 5

Your pgvector Queries Are Doing Sequential Scans — Here's Why

#database #machinelearning #performance #postgres

1

4 min read

Philip McClarence

Mar 4

IVFFlat vs HNSW in pgvector: Which Index Should You Use?

#ai #database #performance #postgres

1

4 min read

Philip McClarence

Mar 4

Choosing the Right chunk_time_interval for Your Workload

#architecture #database #performance #postgres

1

4 min read

Philip McClarence

Mar 3

Supabase vs Firebase in 2026: Which Backend Should You Choose?

#backend #database #firebase #postgres

3

12 min read

Philip McClarence

Mar 3

Optimizing Continuous Aggregate Performance for Large Datasets

#database #dataengineering #performance #postgres

4 min read

Philip McClarence

Mar 2

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql

1

12 min read

Philip McClarence

Mar 2

Why Your TimescaleDB Compression Ratio Is Bad (And How to Fix It)

#database #performance #postgres #tutorial

4 min read

Philip McClarence

Mar 1

PostgreSQL vs MySQL in 2026: Performance, Features and When to Use Each

#database #performance #postgres #sql

1

10 min read

Writing Debut

One Year Club