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.
[VPS] How to backup mongodb and postgresql dbs to S3 Object Storage

[VPS] How to backup mongodb and postgresql dbs to S3 Object Storage

5
Comments 2
3 min read
Query hierarchical data structures on Hasura with Postgres ltree

Query hierarchical data structures on Hasura with Postgres ltree

6
Comments
4 min read
Announcing Hasura 2.0.0-alpha.8

Announcing Hasura 2.0.0-alpha.8

3
Comments
4 min read
Fastify and PostgreSQL REST API

Fastify and PostgreSQL REST API

36
Comments 2
9 min read
SQL Review - Useful queries for mySQL

SQL Review - Useful queries for mySQL

9
Comments
1 min read
Lessons from PostgreSQL

Lessons from PostgreSQL

10
Comments 1
4 min read
KnexJS: how to convert a SQL join with aliases and ordered by values from another table

KnexJS: how to convert a SQL join with aliases and ordered by values from another table

2
Comments
1 min read
FastAPI Startup and Shutdown Events

FastAPI Startup and Shutdown Events

16
Comments
2 min read
Automate Customer Rewards using Python, Postgresql and Africas Talking

Automate Customer Rewards using Python, Postgresql and Africas Talking

32
Comments 6
9 min read
Lessons Learned From 5 Years of Scaling PostgreSQL

Lessons Learned From 5 Years of Scaling PostgreSQL

27
Comments
18 min read
Using indexes to speed up queries in PostgreSQL

Using indexes to speed up queries in PostgreSQL

7
Comments
2 min read
Generate TypeScript definitions from PostgreSQL

Generate TypeScript definitions from PostgreSQL

6
Comments
2 min read
Quick Answers: What is the UUID column type good for and what exactly is a UUID?

Quick Answers: What is the UUID column type good for and what exactly is a UUID?

3
Comments
2 min read
PostgreSQL does have SSL (asymmetric key files), but I couldn't get it to work

PostgreSQL does have SSL (asymmetric key files), but I couldn't get it to work

7
Comments
2 min read
"use database_name" with PostgreSQL

"use database_name" with PostgreSQL

2
Comments
1 min read
How to use MySQL/Postgres with Docker

How to use MySQL/Postgres with Docker

8
Comments
2 min read
Django Project Tutorial for beginners: Settings, Docker-Compose, Postgres and Redis

Django Project Tutorial for beginners: Settings, Docker-Compose, Postgres and Redis

129
Comments 10
30 min read
Anatomy of a PostgreSQL Query Plan

Anatomy of a PostgreSQL Query Plan

9
Comments
10 min read
Postgres Triggers

Postgres Triggers

10
Comments
3 min read
Maintaining Multiple Postgres Version

Maintaining Multiple Postgres Version

17
Comments 1
1 min read
Easy functions and transactions using Postgres + PostgREST or Supabase

Easy functions and transactions using Postgres + PostgREST or Supabase

16
Comments 1
2 min read
PostgreSQL Interview Questions

PostgreSQL Interview Questions

17
Comments
4 min read
Practical example for Ranking with Window Functions

Practical example for Ranking with Window Functions

5
Comments
2 min read
Microservices in Go: Accessing PostgreSQL - Putting it all together

Microservices in Go: Accessing PostgreSQL - Putting it all together

5
Comments
3 min read
How to Query Multiple Schemas With Postgresql

How to Query Multiple Schemas With Postgresql

13
Comments
3 min read
loading...