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.
TypeORM Eager - Don't fall for it

TypeORM Eager - Don't fall for it

Comments
2 min read
MySQL vs. PostgreSQL: A Deep Dive to Find Out Which is Best

MySQL vs. PostgreSQL: A Deep Dive to Find Out Which is Best

1
Comments
1 min read
Solving Permission Issues with PostgreSQL and Docker Compose on macOS Using Colima

Solving Permission Issues with PostgreSQL and Docker Compose on macOS Using Colima

Comments
3 min read
sqlc: Type-Safe Querying in Go

sqlc: Type-Safe Querying in Go

10
Comments
9 min read
Oracle to PostgreSQL Migration: A Comprehensive Guide

Oracle to PostgreSQL Migration: A Comprehensive Guide

1
Comments 1
3 min read
Create a fullstack Next.js 15 app with Drizzle ORM, Postgresql, Docker

Create a fullstack Next.js 15 app with Drizzle ORM, Postgresql, Docker

Comments
6 min read
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 4

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 4

1
Comments
7 min read
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 1

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 1

3
Comments
8 min read
Navigating PostgreSQL - Query Optimizations

Navigating PostgreSQL - Query Optimizations

1
Comments
9 min read
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 2

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 2

3
Comments
9 min read
Creating a todo app with JDBC

Creating a todo app with JDBC

Comments
7 min read
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
Data Redaction and View Enhancements – Oracle AI Database 26ai(23.6)

Data Redaction and View Enhancements – Oracle AI Database 26ai(23.6)

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

2
Comments
3 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
loading...