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.
Exploring Apache AGE: A Graph Database Built on PostgreSQL

Exploring Apache AGE: A Graph Database Built on PostgreSQL

Comments
3 min read
Leveraging Google Colab to run Postgres: A Comprehensive Guide

Leveraging Google Colab to run Postgres: A Comprehensive Guide

Comments
6 min read
Supabase Beta August 2023

Supabase Beta August 2023

6
Comments
6 min read
PostgreSQL Table Partitioning

PostgreSQL Table Partitioning

1
Comments
4 min read
5 Highly UsДful PostgrДSQL ExtДnsions

5 Highly UsДful PostgrДSQL ExtДnsions

5
Comments
3 min read
From Rust to Python through screwed up SQL queries

From Rust to Python through screwed up SQL queries

2
Comments
1 min read
Integration Test Postgres Store (Go)

Integration Test Postgres Store (Go)

1
Comments
10 min read
Agile Board: A Trello-like API in NestJS with Unit and e2e Testing

Agile Board: A Trello-like API in NestJS with Unit and e2e Testing

4
Comments
1 min read
Guide: Creating Temporary Tables in PostgreSQL

Guide: Creating Temporary Tables in PostgreSQL

3
Comments
3 min read
Mastering PostgreSQL Extension Development: A Comprehensive Guide to the Usage of C API Functions

Mastering PostgreSQL Extension Development: A Comprehensive Guide to the Usage of C API Functions

1
Comments
3 min read
PostgreSQL COALESCE Function: Handling NULL Values Effectively

PostgreSQL COALESCE Function: Handling NULL Values Effectively

Comments
6 min read
Brazilian "Rinha de Backend" challenge #2 - The Improvement

Brazilian "Rinha de Backend" challenge #2 - The Improvement

3
Comments 2
4 min read
Graph representation in relational tables

Graph representation in relational tables

2
Comments
2 min read
Integration of Apache AGE and Citus to Build a Scalable Graph Database on PostgreSQL

Integration of Apache AGE and Citus to Build a Scalable Graph Database on PostgreSQL

1
Comments
3 min read
How Apache AGE Works on Top of PostgreSQL

How Apache AGE Works on Top of PostgreSQL

Comments
3 min read
Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector

Machine Learning challenge: Chihuahua vs Muffin with PostgreSQL and pgvector

1
Comments
1 min read
Database Design in Postgresql

Database Design in Postgresql

7
Comments
2 min read
JSON as TEXT, JSON, or JSONB datatypes in YugabyteDB

JSON as TEXT, JSON, or JSONB datatypes in YugabyteDB

2
Comments
11 min read
Popular Graph extensions to PostgreSQL

Popular Graph extensions to PostgreSQL

1
Comments
2 min read
Guide: Creating Views in PostgreSQL

Guide: Creating Views in PostgreSQL

1
Comments
3 min read
Creating User-Defined Functions in PostgreSQL: A Journey into Customization

Creating User-Defined Functions in PostgreSQL: A Journey into Customization

1
Comments
3 min read
How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade

How We Achieved Minimal Downtime During Our PostgreSQL Database Upgrade

1
Comments
1 min read
Exploring PostgreSQL Extensions: Enhance Your Database Capabilities

Exploring PostgreSQL Extensions: Enhance Your Database Capabilities

2
Comments
2 min read
Enhancing Database Performance: In-Depth Query Optimization with ApacheAGE

Enhancing Database Performance: In-Depth Query Optimization with ApacheAGE

1
Comments
3 min read
Deploying Documenso with Vercel, Supabase and Resend

Deploying Documenso with Vercel, Supabase and Resend

31
Comments
5 min read
Let the Journey Begin !

Let the Journey Begin !

7
Comments 2
1 min read
PostgreSQL Background Processes: A Simple Guide

PostgreSQL Background Processes: A Simple Guide

2
Comments
3 min read
Establishing PostgreSQL Connection with TypeORM in NestJS

Establishing PostgreSQL Connection with TypeORM in NestJS

1
Comments 1
4 min read
What Are Window Functions in SQL & How To Use Them

What Are Window Functions in SQL & How To Use Them

1
Comments
6 min read
Revolutionizing Database Interaction: The Power of Object-Relational Mapping (ORM)

Revolutionizing Database Interaction: The Power of Object-Relational Mapping (ORM)

2
Comments
1 min read
Exploring Graph Analytics with Apache AGE: A Comprehensive Overview

Exploring Graph Analytics with Apache AGE: A Comprehensive Overview

1
Comments
2 min read
[Summary] Chapter#11 "The Internals of PostgreSQL" Streaming Replication

[Summary] Chapter#11 "The Internals of PostgreSQL" Streaming Replication

2
Comments
3 min read
What are Postgres advisory locks and their use cases

What are Postgres advisory locks and their use cases

1
Comments
7 min read
Changes in procedures/functions while migrating from MySQL to PostgreSQL

Changes in procedures/functions while migrating from MySQL to PostgreSQL

3
Comments
3 min read
Conway's game of life...in pure SQL [Postgres]! đŸ’ȘđŸŒđŸ€Ż

Conway's game of life...in pure SQL [Postgres]! đŸ’ȘđŸŒđŸ€Ż

74
Comments 19
9 min read
A Comprehensive Overview of PostgreSQL and Apache AGE

A Comprehensive Overview of PostgreSQL and Apache AGE

2
Comments
3 min read
Cracking the Code: How PostgreSQL Parses SQL Queries

Cracking the Code: How PostgreSQL Parses SQL Queries

Comments
3 min read
Unleashing the Power of Graph Databases: Apache AGE in industries

Unleashing the Power of Graph Databases: Apache AGE in industries

2
Comments
3 min read
No-gap sequence in PostgreSQL and YugabyteDB

No-gap sequence in PostgreSQL and YugabyteDB

6
Comments
4 min read
How to install pgadmin from source code for development on Windows

How to install pgadmin from source code for development on Windows

1
Comments
2 min read
How to Control Autovacuum Frequency in PostgreSQL

How to Control Autovacuum Frequency in PostgreSQL

8
Comments
4 min read
Guide: Creating Triggers in PostgreSQL

Guide: Creating Triggers in PostgreSQL

10
Comments
4 min read
Case Study: How Company X Leveraged Apache AGE to Enhance Fraud Detection

Case Study: How Company X Leveraged Apache AGE to Enhance Fraud Detection

2
Comments
3 min read
Step-by-step guide on installing pgAmin from source code on windows and configuring it for development.

Step-by-step guide on installing pgAmin from source code on windows and configuring it for development.

2
Comments
2 min read
5 Reasons why you should choose PostgreSQL for your next Project!

5 Reasons why you should choose PostgreSQL for your next Project!

1
Comments
3 min read
PL/Python in YugabyteDB

PL/Python in YugabyteDB

1
Comments
3 min read
Unlocking the Power of Social Network Analysis with Apache AGE

Unlocking the Power of Social Network Analysis with Apache AGE

1
Comments
2 min read
How To Seamlessly Integrate Sequelize with Node.js and JavaScript for Database Monitoring

How To Seamlessly Integrate Sequelize with Node.js and JavaScript for Database Monitoring

13
Comments
16 min read
Introduction to Apache AGE

Introduction to Apache AGE

2
Comments
3 min read
A Guide to Setting Up Passport.js Google Strategy with PostgreSQL, Express, React, and Node.js

A Guide to Setting Up Passport.js Google Strategy with PostgreSQL, Express, React, and Node.js

10
Comments
6 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

87
Comments 16
2 min read
Why Is PostgreSQL Getting So Popular

Why Is PostgreSQL Getting So Popular

1
Comments
2 min read
Postgres UPSERT: Uplifting Database Updates and Inserts

Postgres UPSERT: Uplifting Database Updates and Inserts

10
Comments
5 min read
Track every PostgreSQL data change using Debezium

Track every PostgreSQL data change using Debezium

12
Comments
9 min read
Apache AGE and Machine Learning: Enhancing Analytics with Graph Databases

Apache AGE and Machine Learning: Enhancing Analytics with Graph Databases

2
Comments
3 min read
PostgreSQL Faceted navigation and search

PostgreSQL Faceted navigation and search

Comments
4 min read
The SQL Language (Part-1)

The SQL Language (Part-1)

9
Comments 1
3 min read
Generate Date Series in popular Databases

Generate Date Series in popular Databases

8
Comments
3 min read
Locks in PostgreSQL part 3

Locks in PostgreSQL part 3

3
Comments
6 min read
A Comprehensive Guide to Standard SQL Commands and Grammar

A Comprehensive Guide to Standard SQL Commands and Grammar

1
Comments
3 min read
loading...