#postgresql

PMPhilip McClarencepostgresdba.hashnode.dev

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

Supabase vs Firebase in 2026: The Honest Comparison The Backend-as-a-Service decision in 2026 comes down to two real contenders. One locks you into a proprietary ecosystem owned by the largest cloud company on earth. The other gives you a PostgreSQL ...

12h ago15 min read

PMPhilip McClarencepostgresdba.hashnode.dev

Optimizing Continuous Aggregate Performance for Large Datasets

A continuous aggregate that starts fast and gradually slows down is one of the most predictable scaling problems in TimescaleDB. The refresh that took 2 seconds when you had a week of data now takes 30 minutes with a month. The materialization table ...

12h ago5 min read

PMPhilip McClarencepostgresdba.hashnode.dev

pgvector Index Selection: IVFFlat vs HNSW for PostgreSQL Vector Search

pgvector Index Selection: IVFFlat vs HNSW for PostgreSQL Vector Search A team I worked with spent three weeks convinced their OpenAI embeddings were low quality. Their RAG pipeline returned vaguely related documents instead of the precise matches the...

12h ago4 min read

DGDevTools Guidedevtoolsguide.hashnode.dev

PostgreSQL Tools: Clients, Monitoring, Migration, and Performance

PostgreSQL Tools: Clients, Monitoring, Migration, and Performance PostgreSQL is the database most developers reach for, but the ecosystem of tools around it is sprawling. There are dozens of GUI clients, multiple migration frameworks, and various mon...

18h ago7 min read

DGDevTools Guidedevtoolsguide.hashnode.dev

Essential PostgreSQL Extensions Every Developer Should Know

Essential PostgreSQL Extensions Every Developer Should Know PostgreSQL's extension system is one of its greatest strengths. Extensions let you add capabilities that would require switching databases entirely in other ecosystems. This guide covers the...

18h ago7 min read

DGDevTools Guidedevtoolsguide.hashnode.dev

Local Development with Docker Compose: Databases, Queues, and Services

Local Development with Docker Compose: Databases, Queues, and Services Running PostgreSQL, Redis, and a message queue locally used to mean installing each service, managing versions, and dealing with conflicts. Docker Compose makes this trivial: defi...

18h ago4 min read

DGDevTools Guidedevtoolsguide.hashnode.dev

Database Tools for Developers: GUIs, CLIs, Migrations, and Local Setup

Database Tools for Developers: GUIs, CLIs, Migrations, and Local Setup Your database client matters more than most developers realize. A good tool makes exploration fast, catches mistakes before they hit production, and turns schema management from a...

18h ago7 min read

MSMickel Samuelmigrationpilot.hashnode.dev

Squawk vs MigrationPilot: PostgreSQL Migration Linters Compared

Squawk and MigrationPilot are both open-source PostgreSQL migration linters. Both analyze SQL files for dangerous operations and both integrate with CI. But they differ significantly in approach, rule depth, and what information they give you. This c...

1d ago7 min read

MSMickel Samuelmigrationpilot.hashnode.dev

Atlas Paywalled Their Migration Linter — Here Are Your Free Alternatives

In October 2025, Atlas moved atlas migrate lint out of their free Starter plan. If you relied on Atlas for catching dangerous PostgreSQL migrations in CI, you now need a paid plan or a new tool. This guide covers what changed, what's still available ...

1d ago8 min read

MSMickel Samuelmigrationpilot.hashnode.dev

Flyway vs Liquibase for PostgreSQL: An Honest Comparison

Flyway and Liquibase are the two most widely used database migration tools in the Java ecosystem. Both support PostgreSQL. Both are mature. And both have significant differences in philosophy, syntax, and capabilities. This guide compares them honest...

1d ago6 min read

Tag feed

Tag feed

#postgresql

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

Optimizing Continuous Aggregate Performance for Large Datasets

pgvector Index Selection: IVFFlat vs HNSW for PostgreSQL Vector Search

PostgreSQL Tools: Clients, Monitoring, Migration, and Performance

Essential PostgreSQL Extensions Every Developer Should Know

Local Development with Docker Compose: Databases, Queues, and Services

Database Tools for Developers: GUIs, CLIs, Migrations, and Local Setup

Squawk vs MigrationPilot: PostgreSQL Migration Linters Compared

Atlas Paywalled Their Migration Linter — Here Are Your Free Alternatives

Flyway vs Liquibase for PostgreSQL: An Honest Comparison

#postgresql

Search Hashnode

#postgresql

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

Optimizing Continuous Aggregate Performance for Large Datasets

pgvector Index Selection: IVFFlat vs HNSW for PostgreSQL Vector Search

PostgreSQL Tools: Clients, Monitoring, Migration, and Performance

Essential PostgreSQL Extensions Every Developer Should Know

Local Development with Docker Compose: Databases, Queues, and Services

Database Tools for Developers: GUIs, CLIs, Migrations, and Local Setup

Squawk vs MigrationPilot: PostgreSQL Migration Linters Compared

Atlas Paywalled Their Migration Linter — Here Are Your Free Alternatives

Flyway vs Liquibase for PostgreSQL: An Honest Comparison