DEV Community

# postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Cutting My Self-Hosted Analytics Stack Memory by 45%

Cutting My Self-Hosted Analytics Stack Memory by 45%

5
Comments
2 min read
Transaction Race Conditions: Why BEGIN on Pool Breaks Everything

Transaction Race Conditions: Why BEGIN on Pool Breaks Everything

Comments
2 min read
The Connection Leak That Took Down Our Production Database

The Connection Leak That Took Down Our Production Database

Comments
2 min read
Getting Started with eslint-plugin-pg

Getting Started with eslint-plugin-pg

Comments
2 min read
UNION in SQL Postgre

UNION in SQL Postgre

Comments
1 min read
Databasus showed an example how to use AI in large open source projects

Databasus showed an example how to use AI in large open source projects

Comments
5 min read
Neon Postgres 2025: Why the New Serverless Features Change Everything

Neon Postgres 2025: Why the New Serverless Features Change Everything

Comments
13 min read
Databasus — open source backup tool for PostgreSQL, MySQL and MongoDB

Databasus — open source backup tool for PostgreSQL, MySQL and MongoDB

Comments
3 min read
Supabase vs Firebase: What I Chose and Why

Supabase vs Firebase: What I Chose and Why

1
Comments
3 min read
PostgreSQL MCP Server with Built-in SSH Tunneling

PostgreSQL MCP Server with Built-in SSH Tunneling

Comments
7 min read
Neon Postgres Deep Dive: Why the 2025 Updates Change Serverless SQL

Neon Postgres Deep Dive: Why the 2025 Updates Change Serverless SQL

Comments
8 min read
Consultas geoespaciais com PostGIS

Consultas geoespaciais com PostGIS

Comments
8 min read
SQL Injection in node-postgres: The Pattern Everyone Gets Wrong

SQL Injection in node-postgres: The Pattern Everyone Gets Wrong

Comments
2 min read
The Silent Truncator: Debugging Django's Vague `DataError`

The Silent Truncator: Debugging Django's Vague `DataError`

Comments
2 min read
How to Change a Column Datatype Without Affecting Existing Users Postgresql

How to Change a Column Datatype Without Affecting Existing Users Postgresql

Comments
3 min read
Building Git-like Version Control for a Headless CMS (Next.js + Supabase)

Building Git-like Version Control for a Headless CMS (Next.js + Supabase)

Comments
1 min read
Serverless PostgreSQL 2025: The Truth About Supabase, Neon, and PlanetScale

Serverless PostgreSQL 2025: The Truth About Supabase, Neon, and PlanetScale

Comments
12 min read
Solving Latency and Pagination in Image and Keyword Based Property Search

Solving Latency and Pagination in Image and Keyword Based Property Search

2
Comments
3 min read
File handling in PostgreSQL: barriers and ways around them

File handling in PostgreSQL: barriers and ways around them

Comments
8 min read
AlloyDB for PostgreSQL: The Ultimate Guide to Google’s Hyper-Scale Database

AlloyDB for PostgreSQL: The Ultimate Guide to Google’s Hyper-Scale Database

6
Comments 1
4 min read
PostgreSQL Primary Keys-Why Your UUID Choice Matters

PostgreSQL Primary Keys-Why Your UUID Choice Matters

1
Comments
3 min read
ScholarBridge

ScholarBridge

1
Comments
2 min read
2025: Building Real Backend Systems, Not Just Writing Code

2025: Building Real Backend Systems, Not Just Writing Code

1
Comments
3 min read
That Dreaded Alembic NotNullViolation Error (and How to Survive It)

That Dreaded Alembic NotNullViolation Error (and How to Survive It)

2
Comments
2 min read
DEV Track Spotlight: Build modern applications with Amazon Aurora DSQL (DEV308)

DEV Track Spotlight: Build modern applications with Amazon Aurora DSQL (DEV308)

1
Comments
10 min read
loading...