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.
Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

Is it possible to reference one column as multiple foreign keys? ( PostgreSQL )

6
Comments 5
1 min read
Two ways to sort coordinates by geographical distance in Postgres

Two ways to sort coordinates by geographical distance in Postgres

1
Comments
2 min read
Duplicating Table Structure and Data with PostgreSQL

Duplicating Table Structure and Data with PostgreSQL

2
Comments
1 min read
Typescript Series - Array Unshift Type

Typescript Series - Array Unshift Type

1
Comments
1 min read
Postgres and YSQL network analysis

Postgres and YSQL network analysis

9
Comments
4 min read
Use Redis Stack to Replace Postgres in a RESTful API - Learn and Output

Use Redis Stack to Replace Postgres in a RESTful API - Learn and Output

18
Comments
3 min read
PostgreSQL Common Commands

PostgreSQL Common Commands

7
Comments
1 min read
Redis Hackathon - Sanic Currency Exchange API

Redis Hackathon - Sanic Currency Exchange API

18
Comments
2 min read
How to integrate coroot-pg-agent with prometheus

How to integrate coroot-pg-agent with prometheus

1
Comments 1
4 min read
pg_hint_plan with subqueries

pg_hint_plan with subqueries

2
Comments
4 min read
Slonik v30 added sql.type, sql.date, sql.timestamp and sql.interval

Slonik v30 added sql.type, sql.date, sql.timestamp and sql.interval

9
Comments
1 min read
Database Management Software's

Database Management Software's

3
Comments
2 min read
Advance Ef Core and PostgreSQL in .Net 6

Advance Ef Core and PostgreSQL in .Net 6

3
Comments 2
2 min read
Permission denied to create extension "extension_name" HINT: Must be superuser to create this extension postgres

Permission denied to create extension "extension_name" HINT: Must be superuser to create this extension postgres

3
Comments
1 min read
TOP 4 *free* database hosting

TOP 4 *free* database hosting

5
Comments
1 min read
TIL: about Entity Relationship Schemas

TIL: about Entity Relationship Schemas

29
Comments 1
9 min read
Dynamic PostgreSQL credentials using HashiCorp Vault (with PHP Symfony & Go examples)

Dynamic PostgreSQL credentials using HashiCorp Vault (with PHP Symfony & Go examples)

42
Comments 4
12 min read
.NET 6 with PostgreSQL

.NET 6 with PostgreSQL

10
Comments 3
3 min read
PGCLI: Postgres from the terminal

PGCLI: Postgres from the terminal

9
Comments
9 min read
Building REST Endpoints with Knex and PostgreSQL

Building REST Endpoints with Knex and PostgreSQL

5
Comments
10 min read
How to successfully start with Nest.js and Postgres

How to successfully start with Nest.js and Postgres

2
Comments
2 min read
Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

Understanding INNER, OUTER, LEFT, and RIGHT Joins in SQL

6
Comments
11 min read
Partial Indexing FAQ

Partial Indexing FAQ

7
Comments
4 min read
Insert and query jsonb in rails and postgres

Insert and query jsonb in rails and postgres

18
Comments 2
8 min read
Validating PostgreSQL results & inferring query static types

Validating PostgreSQL results & inferring query static types

26
Comments
4 min read
Update & delete JSONB in rails and postgres

Update & delete JSONB in rails and postgres

16
Comments
8 min read
NodeJS PostgreSQL (Bahasa Indonesia) Bagian 2

NodeJS PostgreSQL (Bahasa Indonesia) Bagian 2

4
Comments
1 min read
Moving MyUnisoft Node.js back to TypeORM

Moving MyUnisoft Node.js back to TypeORM

18
Comments 3
8 min read
JSON Primitive Types and Corresponding PostgreSQL Types

JSON Primitive Types and Corresponding PostgreSQL Types

7
Comments
5 min read
Working with databases at a scale

Working with databases at a scale

7
Comments
7 min read
Build a FullStack app with Remix, Prisma, PostgreSQL

Build a FullStack app with Remix, Prisma, PostgreSQL

19
Comments
33 min read
Brief introduction to jsonb in PostgreSQL

Brief introduction to jsonb in PostgreSQL

6
Comments 1
6 min read
Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

Embedded FerretDB with YugabyteDB: MongoDB API on distributed SQL 🚀☁

4
Comments 2
4 min read
Should I Learn PostgreSQL?

Should I Learn PostgreSQL?

9
Comments
3 min read
Understanding a Data Model

Understanding a Data Model

3
Comments 1
2 min read
Cookies & Sessions in Rails

Cookies & Sessions in Rails

3
Comments
9 min read
Liman - Postgresql Connection Hatası Çözümü

Liman - Postgresql Connection Hatası Çözümü

4
Comments
1 min read
Deploying Django Project with Railway Nixpacks

Deploying Django Project with Railway Nixpacks

5
Comments 4
16 min read
Deploying Django Application on AWS with Terraform. Connecting PostgreSQL RDS

Deploying Django Application on AWS with Terraform. Connecting PostgreSQL RDS

14
Comments 2
7 min read
Kaptan üzerinde Patroni Postgresql Sistemi

Kaptan üzerinde Patroni Postgresql Sistemi

6
Comments 1
3 min read
9 Tips, tricks and common issues

9 Tips, tricks and common issues

2
Comments
10 min read
Practical transactions

Practical transactions

2
Comments
4 min read
Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

Loose Index Scan aka Skip Scan in PostgreSQL 🐘🚀

10
Comments
5 min read
Use Django and the Dev.to API to Display Posts

Use Django and the Dev.to API to Display Posts

5
Comments
10 min read
Building a Photo Sharing App with Nuxt 3, GraphQL, Cloudinary, Postgres and Strapi

Building a Photo Sharing App with Nuxt 3, GraphQL, Cloudinary, Postgres and Strapi

28
Comments
35 min read
[5/40 things about data] When in doubt, use Postgres as your database.

[5/40 things about data] When in doubt, use Postgres as your database.

12
Comments
1 min read
Relational data

Relational data

3
Comments
12 min read
Django + PostgreSQL Deployment on Railway App

Django + PostgreSQL Deployment on Railway App

37
Comments 29
16 min read
Universe will collapse before you need BIGINT for milliseconds in JavaScript

Universe will collapse before you need BIGINT for milliseconds in JavaScript

7
Comments
2 min read
Cleanly modifying PostgreSQL configurations

Cleanly modifying PostgreSQL configurations

5
Comments 1
4 min read
Deploying FastAPI Python Application with YugabyteDB to Heroku

Deploying FastAPI Python Application with YugabyteDB to Heroku

6
Comments
5 min read
Easiest Way To Connect Django To A Postgres Database

Easiest Way To Connect Django To A Postgres Database

104
Comments 9
2 min read
When to Use JSON in Your Database

When to Use JSON in Your Database

5
Comments
6 min read
Distributing Data Across Distant Locations With Table Geo-Partitioning

Distributing Data Across Distant Locations With Table Geo-Partitioning

10
Comments
8 min read
Go EventSourcing and CQRS with PostgreSQL, Kafka, MongoDB and ElasticSearch 👋✨💫

Go EventSourcing and CQRS with PostgreSQL, Kafka, MongoDB and ElasticSearch 👋✨💫

55
Comments
31 min read
⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

⏳ Timing database calls to 🐘PostgreSQL or 🚀YugabyteDB (strace)

6
Comments 3
6 min read
IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

IoT benchmark on Distributed SQL from MaibornWolff on AWS EKS

10
Comments
4 min read
Django + PostgreSQL Deployment on Heroku

Django + PostgreSQL Deployment on Heroku

18
Comments 6
17 min read
Rust and Postgresql

Rust and Postgresql

26
Comments 2
5 min read
Postgres and the curious case of the cursory cursors

Postgres and the curious case of the cursory cursors

10
Comments 2
5 min read
loading...