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 Discount Management Dashboard With Postgres

Building a Discount Management Dashboard With Postgres

3
Comments
8 min read
Scaling PostgreSQL + Top 12 Blog Posts

Scaling PostgreSQL + Top 12 Blog Posts

3
Comments
3 min read
String similarity search and fast LIKE operator using pg_trgm

String similarity search and fast LIKE operator using pg_trgm

5
Comments
5 min read
DB max connection limits for Rails app and Postgres, Redis, Puma settings

DB max connection limits for Rails app and Postgres, Redis, Puma settings

14
Comments
8 min read
PostgreSQL: How to update large tables

PostgreSQL: How to update large tables

5
Comments
4 min read
Safe update operation in PostgreSQL using SQLAlchemy

Safe update operation in PostgreSQL using SQLAlchemy

15
Comments 1
3 min read
PostgreSQL on OpenBSD: Upgrade 12 to 13 with pg_dumpall

PostgreSQL on OpenBSD: Upgrade 12 to 13 with pg_dumpall

7
Comments 2
2 min read
Ordering fuzzy search results by relevancy using trigrams

Ordering fuzzy search results by relevancy using trigrams

5
Comments
5 min read
How to make the most out of #100DaysOfCode

How to make the most out of #100DaysOfCode

7
Comments
3 min read
Things I learnt doing a small fuzzy search UI element

Things I learnt doing a small fuzzy search UI element

3
Comments
1 min read
How we moved from MongoDB to Postgres without downtime and cut our costs by 30%

How we moved from MongoDB to Postgres without downtime and cut our costs by 30%

3
Comments 2
3 min read
4 Free AWS courses on PostgreSQL

4 Free AWS courses on PostgreSQL

4
Comments 1
1 min read
Working with PostgreSQL and flask_sqlalchemy

Working with PostgreSQL and flask_sqlalchemy

13
Comments 1
5 min read
Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

Daily Share Price Notifications using Python, SQL and Africas Talking - Part One

24
Comments 6
12 min read
Building a simple Grocery App in Flutter with Supabase

Building a simple Grocery App in Flutter with Supabase

86
Comments 11
13 min read
Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

Creating PostgreSQL Test Data with SQL, PL/pgSQL, and Python

11
Comments 1
15 min read
Airtable DB: How to literally use Airtable as a Database with Node.js

Airtable DB: How to literally use Airtable as a Database with Node.js

12
Comments
12 min read
Create a Relational Database using ASP.NET Core (MVC) | Dear Coder

Create a Relational Database using ASP.NET Core (MVC) | Dear Coder

8
Comments 2
3 min read
Loading Test Data into PostgreSQL

Loading Test Data into PostgreSQL

6
Comments 1
9 min read
[VPS] How to backup mongodb and postgresql dbs to S3 Object Storage

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

6
Comments
3 min read
Minimal User Management using Express and PostgreSQL

Minimal User Management using Express and PostgreSQL

13
Comments
9 min read
Getting started with PostgreSQL Set Operators

Getting started with PostgreSQL Set Operators

7
Comments
4 min read
What is ACID? Baby don't hurt me. No more.

What is ACID? Baby don't hurt me. No more.

10
Comments 1
4 min read
How to backup Postgresql

How to backup Postgresql

3
Comments
1 min read
Powering Real-Time Analytics at Scale on MySQL and PostgreSQL

Powering Real-Time Analytics at Scale on MySQL and PostgreSQL

3
Comments
5 min read
Write a Simple REST API in Golang

Write a Simple REST API in Golang

331
Comments 15
10 min read
pgAdmin4-5.1 for Arch distros (decompiled from deb)

pgAdmin4-5.1 for Arch distros (decompiled from deb)

5
Comments 1
1 min read
Postgres Full Text Search

Postgres Full Text Search

4
Comments
5 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

35
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

6
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
One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

One WEIRD Trick for Speeding Up ORDER BY That You Probably Shouldn't Use

45
Comments 5
3 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

16
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

12
Comments
3 min read
Add Authentication to Your AdonisJS Project

Add Authentication to Your AdonisJS Project

7
Comments
11 min read
Distributed State Management - Without the "E"

Distributed State Management - Without the "E"

4
Comments 2
10 min read
📖 Build a RESTful API on Go: Fiber, PostgreSQL, JWT and Swagger docs in isolated Docker containers

📖 Build a RESTful API on Go: Fiber, PostgreSQL, JWT and Swagger docs in isolated Docker containers

223
Comments 20
27 min read
rails new API with PostgreSQL w/rails g resource

rails new API with PostgreSQL w/rails g resource

10
Comments 1
3 min read
TIL PostgreSQL-style $facet

TIL PostgreSQL-style $facet

6
Comments
1 min read
Understanding Database Connection Pool

Understanding Database Connection Pool

73
Comments
3 min read
Deploy and Manage PostgreSQL on Kubernetes

Deploy and Manage PostgreSQL on Kubernetes

21
Comments
7 min read
loading...