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.
Understanding EF.Functions.Like and ILike in Entity Framework Core

Understanding EF.Functions.Like and ILike in Entity Framework Core

Comments
4 min read
15-Minute Node.js Setup: From Zero to Production (GraphQL, PostgreSQL, Docker & CI/CD)

15-Minute Node.js Setup: From Zero to Production (GraphQL, PostgreSQL, Docker & CI/CD)

2
Comments
7 min read
OpenAI Is Running PostgreSQL at Millions of QPS (Here’s How It Didn’t Explode)

OpenAI Is Running PostgreSQL at Millions of QPS (Here’s How It Didn’t Explode)

5
Comments
3 min read
Horizontal Scaling PostgreSQL with Citus: A Practical Deep Dive

Horizontal Scaling PostgreSQL with Citus: A Practical Deep Dive

Comments
10 min read
PostgreSQL – Storing Time Without Lying to Yourself

PostgreSQL – Storing Time Without Lying to Yourself

Comments
6 min read
Queue vs Direct Insert: What Happens When 10,000 Users Hit Your Database at Once

Queue vs Direct Insert: What Happens When 10,000 Users Hit Your Database at Once

8
Comments
6 min read
MongoDB vs PostgreSQL: When to Choose Which One? (With Real-World Examples)

MongoDB vs PostgreSQL: When to Choose Which One? (With Real-World Examples)

Comments
4 min read
PostgreSQL Autovacuum Tuning: A Practical Guide

PostgreSQL Autovacuum Tuning: A Practical Guide

1
Comments
5 min read
Database Indexes Explained Like You're 5

Database Indexes Explained Like You're 5

Comments 1
7 min read
PostGres Database Replication Using Pglogical

PostGres Database Replication Using Pglogical

1
Comments
3 min read
Mastering PostgreSQL Query Optimization: Techniques for Efficient Queries

Mastering PostgreSQL Query Optimization: Techniques for Efficient Queries

Comments
3 min read
Portabase: A self-hosted tool for database backup & restore

Portabase: A self-hosted tool for database backup & restore

8
Comments 1
3 min read
PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

PostgreSQL backup encryption — How to encrypt your PostgreSQL database backups

Comments
8 min read
Jestr (2014): The Architecture of a Social App and the Power of PostgreSQL Views

Jestr (2014): The Architecture of a Social App and the Power of PostgreSQL Views

1
Comments 1
6 min read
A safe way to let coding agents interact with your database (without prod write access)

A safe way to let coding agents interact with your database (without prod write access)

1
Comments
12 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.