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.
PostgreSQL® JSONB Cheatsheet: Complete and Fast Lookup Guide

PostgreSQL® JSONB Cheatsheet: Complete and Fast Lookup Guide

1
Comments
4 min read
A Comprehensive Guide to Concurrency Control in PostgreSQL

A Comprehensive Guide to Concurrency Control in PostgreSQL

3
Comments
3 min read
Exploring Shortest Path Algorithms with Apache AGE

Exploring Shortest Path Algorithms with Apache AGE

4
Comments
6 min read
Integrate with HubSpot using Prisma

Integrate with HubSpot using Prisma

1
Comments
12 min read
Onboarding Month as a Software Engineering Intern: Lessons Learned and Goals Ahead

Onboarding Month as a Software Engineering Intern: Lessons Learned and Goals Ahead

2
Comments
2 min read
Supercharge Your Database: A Deep Dive into Optimizing Queries with ApacheAGE

Supercharge Your Database: A Deep Dive into Optimizing Queries with ApacheAGE

1
Comments
3 min read
PostgreSQL + JSONB + Ruby

PostgreSQL + JSONB + Ruby

21
Comments
4 min read
Exploring the Advanced Features of Apache AGE: How This Graph Extension Can Take Your Data Management to the Next Level

Exploring the Advanced Features of Apache AGE: How This Graph Extension Can Take Your Data Management to the Next Level

2
Comments
3 min read
Getting Started with Apache AGE: A Comprehensive Guide (Part 1)

Getting Started with Apache AGE: A Comprehensive Guide (Part 1)

5
Comments
2 min read
Understanding Indexes in PostgreSQL: Part 2

Understanding Indexes in PostgreSQL: Part 2

1
Comments
3 min read
Understanding Indexes in PostgreSQL: An Introduction

Understanding Indexes in PostgreSQL: An Introduction

1
Comments
3 min read
How the VLE Works - The Internals of Apache AGE

How the VLE Works - The Internals of Apache AGE

2
Comments
2 min read
Updating timestamps automatically in Supabase

Updating timestamps automatically in Supabase

14
Comments
1 min read
UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE)

UPSERT some columns in YugabyteDB (ON CONFLICT DO UPDATE)

6
Comments
6 min read
Everything you wanted to know about Auto Increment but were afraid to ask

Everything you wanted to know about Auto Increment but were afraid to ask

2
Comments
6 min read
Distributed Managed PostgreSQL Database Alternatives in the Cloud

Distributed Managed PostgreSQL Database Alternatives in the Cloud

2
Comments
3 min read
SQL Indexes Basics in Rails

SQL Indexes Basics in Rails

3
Comments
4 min read
Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

Filtering on DENSE_RANK() optimized as pushed-down DISTINCT in YugabyteDB

1
Comments
4 min read
🏺Database Architecture - History Over State

🏺Database Architecture - History Over State

8
Comments 1
8 min read
How an RDBMS works #3: Database Life Cycle Overview

How an RDBMS works #3: Database Life Cycle Overview

9
Comments
5 min read
How To Design And Build A Database In Postgres

How To Design And Build A Database In Postgres

4
Comments
15 min read
Understanding SurrealQL and how it is different from PostgreSQL

Understanding SurrealQL and how it is different from PostgreSQL

36
Comments 6
9 min read
Cost Estimation In PostgreSQL

Cost Estimation In PostgreSQL

Comments
2 min read
Usage of pgpool-II and AGE at PostgeSQL

Usage of pgpool-II and AGE at PostgeSQL

1
Comments
3 min read
Search By Inequality and range in PostgreSQL B-Tree Indexes

Search By Inequality and range in PostgreSQL B-Tree Indexes

2
Comments
2 min read
Creating a visual novel using Graph Databases

Creating a visual novel using Graph Databases

1
Comments
3 min read
How I can speed up a lateral join (or avoid it at all)

How I can speed up a lateral join (or avoid it at all)

Comments
1 min read
Why use Apache AGE?

Why use Apache AGE?

2
Comments
1 min read
Collaborate to Innovate: How a Social Network Can Help You Find Your Dream Pair Programming Team

Collaborate to Innovate: How a Social Network Can Help You Find Your Dream Pair Programming Team

4
Comments 1
3 min read
Securely connect to an Amazon RDS via PrivateLink using SQL

Securely connect to an Amazon RDS via PrivateLink using SQL

Comments
3 min read
Postgres: The Graph Database You Didn't Know You Had

Postgres: The Graph Database You Didn't Know You Had

7
Comments
6 min read
Database Cluster Layout

Database Cluster Layout

3
Comments
2 min read
Simple query for remove duplicates from table

Simple query for remove duplicates from table

2
Comments
2 min read
pgDay Paris: no notes!

pgDay Paris: no notes!

3
Comments
4 min read
Advisory locks (рекомендательные блокировки)

Advisory locks (рекомендательные блокировки)

3
Comments 2
1 min read
Cypher on PostgreSQL: A Reason to Use Apache AGE

Cypher on PostgreSQL: A Reason to Use Apache AGE

3
Comments
2 min read
SQL Concepts

SQL Concepts

1
Comments
11 min read
SQL Concepts

SQL Concepts

1
Comments
6 min read
[GDB] Debugging session PostgreSQL & AGE

[GDB] Debugging session PostgreSQL & AGE

7
Comments
1 min read
B-Tree indexes in PostgreSQL and Search by Equality in It.

B-Tree indexes in PostgreSQL and Search by Equality in It.

3
Comments
2 min read
Mastering Large-Scale Data Processing: Building a Data Pipeline with ApacheAGE for Efficient Ingestion, Processing, and Analysis

Mastering Large-Scale Data Processing: Building a Data Pipeline with ApacheAGE for Efficient Ingestion, Processing, and Analysis

2
Comments
2 min read
Supply Chain Optimization using postgreSQL and Apache-Age - Part 2

Supply Chain Optimization using postgreSQL and Apache-Age - Part 2

2
Comments
3 min read
Millions record query - with and without index

Millions record query - with and without index

Comments
2 min read
Swapping Databases: SQLite to PostgreSQL for Deployment

Swapping Databases: SQLite to PostgreSQL for Deployment

Comments
2 min read
API with Typescript + Nest + TypeORM + Postgres + Docker

API with Typescript + Nest + TypeORM + Postgres + Docker

18
Comments 4
4 min read
Create a Word Guessing Game With Apache AGE

Create a Word Guessing Game With Apache AGE

5
Comments 1
3 min read
The Power of Graph Databases: Unlocking the Potential of Connected Data

The Power of Graph Databases: Unlocking the Potential of Connected Data

3
Comments
2 min read
SQL JOIN explained

SQL JOIN explained

74
Comments 4
13 min read
Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

Uncovering Hidden Gems: PostgreSQL Window Functions You May Not Know About

3
Comments
2 min read
Deploy Rails app and Postgres with Kamal(previously MRSK) on single DigitalOcean server

Deploy Rails app and Postgres with Kamal(previously MRSK) on single DigitalOcean server

21
Comments 3
3 min read
Multiples Postgres databases in one service with Docker Compose

Multiples Postgres databases in one service with Docker Compose

18
Comments 1
1 min read
Why use graph database?

Why use graph database?

10
Comments 3
1 min read
Understanding The Process and Memory Architecture of PostgreSQL

Understanding The Process and Memory Architecture of PostgreSQL

6
Comments
2 min read
CONNECTING TO A POSTGRESQL DATABASE WITH NODE.JS: A STEP-BY-STEP GUIDE

CONNECTING TO A POSTGRESQL DATABASE WITH NODE.JS: A STEP-BY-STEP GUIDE

24
Comments 1
5 min read
Hero Builds and Counter Picks in Dota 2 With Apache AGE

Hero Builds and Counter Picks in Dota 2 With Apache AGE

8
Comments 3
7 min read
How to install postgresql-server-dev-11 on ubuntu

How to install postgresql-server-dev-11 on ubuntu

2
Comments
1 min read
Analyzing Wikipedia's Articles Classification Chain With Apache AGE

Analyzing Wikipedia's Articles Classification Chain With Apache AGE

8
Comments
3 min read
Exploring the Postgres Internals: A Guide for Database Admins and System Developers (Part 2)

Exploring the Postgres Internals: A Guide for Database Admins and System Developers (Part 2)

1
Comments
3 min read
Using uuid in Knex.js and PostgreSQL

Using uuid in Knex.js and PostgreSQL

5
Comments 1
2 min read
CITEXT vs LOWER

CITEXT vs LOWER

1
Comments
4 min read
loading...