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.
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

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

Safe update operation in PostgreSQL using SQLAlchemy

17
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

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

Ordering fuzzy search results by relevancy using trigrams

6
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

16
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

92
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
Minimal User Management using Express and PostgreSQL

Minimal User Management using Express and PostgreSQL

14
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

332
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
loading...