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.
Considerations for Unicode and Searching

Considerations for Unicode and Searching

1
Comments
8 min read
Read Committed transaction isolation in PostgreSQL

Read Committed transaction isolation in PostgreSQL

1
Comments
6 min read
Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

Optimizing Fuzzy Search Across Multiple Tables: pg_trgm, GIN, and Triggers

5
Comments
4 min read
Setting Up a Backend with Prisma, Express, and PostgreSQL

Setting Up a Backend with Prisma, Express, and PostgreSQL

6
Comments 2
5 min read
Stored Procedures & Exception Handling when migrating from Oracle to PostgreSQL or YugabyteDB

Stored Procedures & Exception Handling when migrating from Oracle to PostgreSQL or YugabyteDB

10
Comments
4 min read
Starting a new Django project with PostgresSQL and Docker

Starting a new Django project with PostgresSQL and Docker

4
Comments
2 min read
How to deal with race conditions using Java and PostgreSQL

How to deal with race conditions using Java and PostgreSQL

1
Comments
3 min read
Trying out a new stack: my experience working with tRPC and Drizzle on my Next.JS project

Trying out a new stack: my experience working with tRPC and Drizzle on my Next.JS project

1
Comments
3 min read
Automatic PostgreSQL backups to AWS S3 (Kubernetes CronJob)

Automatic PostgreSQL backups to AWS S3 (Kubernetes CronJob)

5
Comments
3 min read
PostgreSQL Backups Simplified with pg_dump

PostgreSQL Backups Simplified with pg_dump

1
Comments
1 min read
Monitoring, troubleshooting, and query analytics for PostgreSQL on Kubernetes

Monitoring, troubleshooting, and query analytics for PostgreSQL on Kubernetes

11
Comments
5 min read
Making Common Table Expression SQL More Railsy

Making Common Table Expression SQL More Railsy

4
Comments
9 min read
Using JSONB in PostgreSQL

Using JSONB in PostgreSQL

10
Comments 2
3 min read
Join us for the Neon Open Source Starter Kit Challenge: $3,000 in Prizes!

Join us for the Neon Open Source Starter Kit Challenge: $3,000 in Prizes!

189
Comments 27
2 min read
Learnings in Raku and Pg Concurrency

Learnings in Raku and Pg Concurrency

8
Comments 1
5 min read
Running PostgreSQL and pgAdmin 4 in Docker: A Complete Guide

Running PostgreSQL and pgAdmin 4 in Docker: A Complete Guide

6
Comments
4 min read
Inserting and Selecting New Records - One Query

Inserting and Selecting New Records - One Query

1
Comments
4 min read
Integrating PostgreSQL with a .NET: A Step-by-Step Guide

Integrating PostgreSQL with a .NET: A Step-by-Step Guide

9
Comments 2
3 min read
Upgrading Postgres in Docker

Upgrading Postgres in Docker

1
Comments
2 min read
Mastering Cypher Queries in Apache AGE

Mastering Cypher Queries in Apache AGE

Comments
2 min read
Which Database is Perfect for You? A Comprehensive Guide to MySQL, PostgreSQL, NoSQL, and More

Which Database is Perfect for You? A Comprehensive Guide to MySQL, PostgreSQL, NoSQL, and More

8
Comments
9 min read
Running pgAdmin to Manage a PostgreSQL Cluster on Kubernetes

Running pgAdmin to Manage a PostgreSQL Cluster on Kubernetes

23
Comments
3 min read
Verifying Column Types in Your Database Schema

Verifying Column Types in Your Database Schema

2
Comments
2 min read
How to Identify Tables Containing a Specific Column in PostgreSQL

How to Identify Tables Containing a Specific Column in PostgreSQL

5
Comments
2 min read
Installing PostgreSQL with Docker

Installing PostgreSQL with Docker

7
Comments
3 min read
loading...