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.
Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming 🎮

Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming 🎮

4
Comments
2 min read
Efficient Percentile Ranking in PostgreSQL

Efficient Percentile Ranking in PostgreSQL

6
Comments
2 min read
Navigating PostgreSQL - Join Strategies

Navigating PostgreSQL - Join Strategies

3
Comments
5 min read
We don't need DynamoDB when we have Aurora Postgres

We don't need DynamoDB when we have Aurora Postgres

1
Comments
2 min read
SQL Interview questions and answers

SQL Interview questions and answers

Comments 1
3 min read
Task : Database

Task : Database

1
Comments
2 min read
Open-Source Databases for Real-Time Analytics

Open-Source Databases for Real-Time Analytics

3
Comments
3 min read
Data Redaction and View Enhancements – Oracle 23ai(23.6)

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Comments
2 min read
Navigating PostgreSQL - Index, Index Only and Bitmap Index Scans Explained

Navigating PostgreSQL - Index, Index Only and Bitmap Index Scans Explained

1
Comments
8 min read
Building a Robust Node.js Application with TypeScript, PostgreSQL, and Joi

Building a Robust Node.js Application with TypeScript, PostgreSQL, and Joi

1
Comments
3 min read
Model Context Protocol (MCP)

Model Context Protocol (MCP)

1
Comments
2 min read
PostgreSQL Cheat Sheet: Essential Commands & Queries

PostgreSQL Cheat Sheet: Essential Commands & Queries

4
Comments
12 min read
How to return old data in same query as updating a table in postgres

How to return old data in same query as updating a table in postgres

Comments
1 min read
Use Prisma and PostgresDB in a prevent ticket oversold example

Use Prisma and PostgresDB in a prevent ticket oversold example

Comments
4 min read
Navigating PostgreSQL - The explain command and sequential scans

Navigating PostgreSQL - The explain command and sequential scans

1
Comments
4 min read
Redoed #3: Connecting Go Server to PostgreSQL with GORM

Redoed #3: Connecting Go Server to PostgreSQL with GORM

Comments
3 min read
Vector Databases vs. PostgreSQL with pg_vector for RAG Setups

Vector Databases vs. PostgreSQL with pg_vector for RAG Setups

6
Comments
4 min read
10 psql commands to boost productivity (with examples)

10 psql commands to boost productivity (with examples)

4
Comments
3 min read
🎥 Speed Up PostgreSQL Queries by 7x with Smarter Indexing

🎥 Speed Up PostgreSQL Queries by 7x with Smarter Indexing

15
Comments
1 min read
Navigating PostgreSQL - Pages and Blocks

Navigating PostgreSQL - Pages and Blocks

1
Comments
3 min read
Getting Started with PostgreSQL

Getting Started with PostgreSQL

5
Comments
3 min read
Study Notes 2.2.4: Managing Scheduling and Backfills with Postgres in Kestra

Study Notes 2.2.4: Managing Scheduling and Backfills with Postgres in Kestra

Comments
2 min read
Study Notes 1.2.5: Running PostgreSQL and pgAdmin with Docker-Compose

Study Notes 1.2.5: Running PostgreSQL and pgAdmin with Docker-Compose

Comments
3 min read
Study Notes 1.2.6: SQL Refresher

Study Notes 1.2.6: SQL Refresher

Comments
4 min read
Navigating PostgreSQL - Views

Navigating PostgreSQL - Views

Comments
2 min read
loading...