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.
Create a Restful API with Golang from scratch

Create a Restful API with Golang from scratch

559
Comments 17
13 min read
Connecting to PostgreSQL using GORM

Connecting to PostgreSQL using GORM

72
Comments 12
7 min read
Geolocation with Postgresql+Nestjs+Typeorm

Geolocation with Postgresql+Nestjs+Typeorm

9
Comments
1 min read
How to secure data using stored procedures in SQL

How to secure data using stored procedures in SQL

4
Comments
4 min read
Using Constants in PostgreSQL queries

Using Constants in PostgreSQL queries

2
Comments
2 min read
What’s new with JSON in PostgreSQL v14

What’s new with JSON in PostgreSQL v14

23
Comments 2
6 min read
Text Search example with the OMDB sample database

Text Search example with the OMDB sample database

1
Comments
7 min read
Connecting Django to PostgreSQL on Heroku and Perform SQL Command

Connecting Django to PostgreSQL on Heroku and Perform SQL Command

9
Comments
15 min read
Aggregate Functions in SQL

Aggregate Functions in SQL

22
Comments
6 min read
PostgreSQL terminal: a CRUD beginner guide (Windows 10).

PostgreSQL terminal: a CRUD beginner guide (Windows 10).

7
Comments 1
6 min read
How to persist and backup PostgreSQL Docker container.

How to persist and backup PostgreSQL Docker container.

22
Comments 2
4 min read
Auth with Express with JWT, MongoDB, and Postgres

Auth with Express with JWT, MongoDB, and Postgres

7
Comments
13 min read
Function pipelines: Building functional programming into PostgreSQL using custom operators

Function pipelines: Building functional programming into PostgreSQL using custom operators

2
Comments
20 min read
How percentile approximation works (and why it's more useful than averages)

How percentile approximation works (and why it's more useful than averages)

2
Comments
33 min read
Handling temporal data in SQL

Handling temporal data in SQL

2
Comments
6 min read
Script to import IMDB database into PostgreSQL

Script to import IMDB database into PostgreSQL

4
Comments
1 min read
Instant Realtime APIs using PostgreSQL, MySQL, SQLite, SQLServer and Planetscale.

Instant Realtime APIs using PostgreSQL, MySQL, SQLite, SQLServer and Planetscale.

3
Comments
6 min read
What is the difference between UNION and UNION ALL in SQL?

What is the difference between UNION and UNION ALL in SQL?

16
Comments 2
2 min read
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

80
Comments 29
14 min read
Dockerize & Backup A Postgres Database

Dockerize & Backup A Postgres Database

27
Comments 4
8 min read
Top PostgreSQL monitoring metrics for Prometheus – Includes cheat sheet

Top PostgreSQL monitoring metrics for Prometheus – Includes cheat sheet

26
Comments 3
6 min read
ORDER BY is mandatory in SQL to get a sorted result

ORDER BY is mandatory in SQL to get a sorted result

33
Comments
10 min read
What is free memory in Linux?

What is free memory in Linux?

19
Comments
5 min read
Window Functions in SQL: Part 1

Window Functions in SQL: Part 1

7
Comments
4 min read
Seeding Postgres with Docker

Seeding Postgres with Docker

28
Comments 2
1 min read
loading...