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.
How to report Postgres custom errors in Ecto Changeset

How to report Postgres custom errors in Ecto Changeset

9
Comments
3 min read
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

8
Comments 3
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
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!

190
Comments 27
2 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.