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.
Building a True Lakehouse via Snowflake Postgres and pg_lake

Building a True Lakehouse via Snowflake Postgres and pg_lake

1
Comments
15 min read
Databasus released full backups portability: backups recoverable without Databasus itself

Databasus released full backups portability: backups recoverable without Databasus itself

Comments
4 min read
How to Query PostgreSQL from VS Code (Without Installing Anything Else)

How to Query PostgreSQL from VS Code (Without Installing Anything Else)

1
Comments
2 min read
Principais Arquivos do Servidor PostgreSQL e Suas Funções

Principais Arquivos do Servidor PostgreSQL e Suas Funções

1
Comments
2 min read
Real world considerations: MS-SQL vs PostgreSQL vs MySQL

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

2
Comments
12 min read
Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

Updating "denormalized" aggregates with "duplicates": MongoDB vs. PostgreSQL

1
Comments
9 min read
Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

Slapping Secondary Indexes on Random Fields is Silently Killing Your Database.

2
Comments
2 min read
How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

How to Connect PostgreSQL to Google Apps Script (JDBC Guide)

Comments
15 min read
PostgreSQL global statistics on partitionned table require a manual ANALYZE

PostgreSQL global statistics on partitionned table require a manual ANALYZE

6
Comments
8 min read
Implementing pagination with PostgreSQL and the MantaHQ SDK

Implementing pagination with PostgreSQL and the MantaHQ SDK

4
Comments
5 min read
Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

3
Comments
5 min read
One Database Per Branch — Stop Breaking Your Local DB

One Database Per Branch — Stop Breaking Your Local DB

Comments
1 min read
PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

1
Comments
12 min read
pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

pg-safe-migrate — Stop Shipping Unsafe Postgres Migrations

5
Comments
3 min read
SQL Joins and Window Functions

SQL Joins and Window Functions

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