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.
Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases

Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases

13
Comments 3
16 min read
Setting Up a PostgreSQL Environment in Docker: A Step-By-Step Guide

Setting Up a PostgreSQL Environment in Docker: A Step-By-Step Guide

9
Comments 1
4 min read
Rails backup schemes to backup Postgres databases

Rails backup schemes to backup Postgres databases

1
Comments
6 min read
FOREACH and FOR statements with arrays in PostgreSQL

FOREACH and FOR statements with arrays in PostgreSQL

8
Comments
4 min read
UUID in PostgreSQL

UUID in PostgreSQL

70
Comments 7
5 min read
pgvector: 30x Faster Index Build for your Vector Embeddings

pgvector: 30x Faster Index Build for your Vector Embeddings

3
Comments 1
6 min read
How to load JSON data in PostgreSQL with the COPY command

How to load JSON data in PostgreSQL with the COPY command

25
Comments
4 min read
pgvector 0.6.0: 30x faster with parallel index builds

pgvector 0.6.0: 30x faster with parallel index builds

105
Comments
3 min read
Exploring The Set Clause : Updating Labels and Properties in Apache Age

Exploring The Set Clause : Updating Labels and Properties in Apache Age

Comments
4 min read
To UUID, or not to UUID, that is the primary key question

To UUID, or not to UUID, that is the primary key question

20
Comments
8 min read
A multi-dimensional array in PostgreSQL

A multi-dimensional array in PostgreSQL

Comments
4 min read
Understanding and Optimizing Parallel Queries in PostgreSQL

Understanding and Optimizing Parallel Queries in PostgreSQL

Comments
2 min read
Postgres Data Backup with Continuous Archiving and Point-in-time-recovery

Postgres Data Backup with Continuous Archiving and Point-in-time-recovery

2
Comments
2 min read
Best Practice: use the same datatypes for comparisons, like joins and foreign keys

Best Practice: use the same datatypes for comparisons, like joins and foreign keys

Comments
7 min read
Getting started with Ruby on Rails and Postgres on Supabase

Getting started with Ruby on Rails and Postgres on Supabase

99
Comments
4 min read
Shift Left For DevOps: Enhancing Service Ownership in Databases

Shift Left For DevOps: Enhancing Service Ownership in Databases

Comments
8 min read
How to restart PostgreSQL with PgBouncer assist

How to restart PostgreSQL with PgBouncer assist

Comments
1 min read
Passwordless login to Postgres from VSCode SQLTools extension using IDENT/PEER method

Passwordless login to Postgres from VSCode SQLTools extension using IDENT/PEER method

3
Comments
4 min read
Load StackOverflow's StackExchange data in PostgreSQL®

Load StackOverflow's StackExchange data in PostgreSQL®

Comments 2
7 min read
Out of Range statistics with PostgreSQL & YugabyteDB

Out of Range statistics with PostgreSQL & YugabyteDB

1
Comments 1
7 min read
YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL

YugabyteDB bulk inserts with function: faster with SQL compared to PL/pgSQL

Comments
4 min read
Relational Database Management Systems (RDBMS): Benefits and Limitations

Relational Database Management Systems (RDBMS): Benefits and Limitations

1
Comments
3 min read
How to use pg_stat_monitor on PostgreSQL

How to use pg_stat_monitor on PostgreSQL

Comments
1 min read
The performance cost of pl/pgsql exception block in Postgres

The performance cost of pl/pgsql exception block in Postgres

1
Comments 1
3 min read
Store embeddings in Azure Cosmos DB for PostgreSQL with pgvector

Store embeddings in Azure Cosmos DB for PostgreSQL with pgvector

7
Comments
8 min read
loading...