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.
Video encoded as emojis⁉️ Stored in a DB? 😱🤯

Video encoded as emojis⁉️ Stored in a DB? 😱🤯

74
Comments 14
9 min read
When to use SQL vs NoSQL

When to use SQL vs NoSQL

62
Comments 4
4 min read
PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

PostgreSQL or MySQL: What Should I Choose for My Full-Stack Project?

47
Comments 11
6 min read
How to Deploy Directus to Render.com

How to Deploy Directus to Render.com

15
Comments
3 min read
How to run PostgreSQL and pgAdmin on Docker?

How to run PostgreSQL and pgAdmin on Docker?

10
Comments
5 min read
Como configurar um banco de dados Postgres no Django

Como configurar um banco de dados Postgres no Django

7
Comments 2
4 min read
Scalable Notification System Design for 50 Million Users (Database Design)

Scalable Notification System Design for 50 Million Users (Database Design)

7
Comments
3 min read
Build A Public API with Supabase in 10 Minutes

Build A Public API with Supabase in 10 Minutes

6
Comments 3
8 min read
Debounce messages in queueing systems: How to do it with Postgres

Debounce messages in queueing systems: How to do it with Postgres

6
Comments 2
6 min read
How to set up Amazon RDS Proxy for Amazon Aurora (Serverless) database cluster and connect AWS Lambda function to it

How to set up Amazon RDS Proxy for Amazon Aurora (Serverless) database cluster and connect AWS Lambda function to it

6
Comments 1
5 min read
A Step-by-Step Guide to Connecting Excel to a PostgreSQL Database

A Step-by-Step Guide to Connecting Excel to a PostgreSQL Database

5
Comments
3 min read
PostgreSQL with modern storage: what about a lower random_page_cost?

PostgreSQL with modern storage: what about a lower random_page_cost?

5
Comments
11 min read
Integration test with Go and PostgreSQL

Integration test with Go and PostgreSQL

5
Comments
5 min read
11 Planetscale alternatives with free tiers

11 Planetscale alternatives with free tiers

4
Comments
15 min read
Creating my own homelab

Creating my own homelab

4
Comments
2 min read
Automate daily MySQL and PostgreSQL database backups

Automate daily MySQL and PostgreSQL database backups

3
Comments 2
2 min read
Get started with Prisma ORM and Xata's Postgres service

Get started with Prisma ORM and Xata's Postgres service

3
Comments
5 min read
The Great Migration from MongoDB to PostgreSQL

The Great Migration from MongoDB to PostgreSQL

3
Comments
9 min read
Retrieving the latest row per group from PostgreSQL

Retrieving the latest row per group from PostgreSQL

2
Comments
11 min read
How to Set Up Multiple PostgreSQL Instances on a Single Server

How to Set Up Multiple PostgreSQL Instances on a Single Server

2
Comments
2 min read
WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

WebAuthn Guide for MySQL, PostgreSQL, SQLite & MongoDB

2
Comments
2 min read
🤔 Looking for advice on integrating SportDevs API for futsal data?

🤔 Looking for advice on integrating SportDevs API for futsal data?

2
Comments
1 min read
A new serverless Postgres platform

A new serverless Postgres platform

1
Comments
10 min read
Move Fast and “Branch” Things

Move Fast and “Branch” Things

1
Comments
8 min read
Dynamic Data Management with jsonb in Rails

Dynamic Data Management with jsonb in Rails

1
Comments
2 min read
Time Series Analysis on FDIC Bank Failures

Time Series Analysis on FDIC Bank Failures

1
Comments
8 min read
Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16

Optimizing PostgreSQL Performance: Navigating the Use of Bind Variables in Version 16

1
Comments
3 min read
Prisma vs. Drizzle: A Comprehensive Guide for Your NextJS Project

Prisma vs. Drizzle: A Comprehensive Guide for Your NextJS Project

1
Comments
4 min read
How to use Cloudflare Workers AI for building an AI-powered search bar

How to use Cloudflare Workers AI for building an AI-powered search bar

1
Comments
4 min read
Current trends in PostgreSQL - insights from PGConf.DE 2024

Current trends in PostgreSQL - insights from PGConf.DE 2024

1
Comments
2 min read
PostGIS and Heroku Postgres… Location, Location, Location!

PostGIS and Heroku Postgres… Location, Location, Location!

1
Comments
7 min read
Django With Postgres On Ubuntu.

Django With Postgres On Ubuntu.

1
Comments
3 min read
Express

Express

1
Comments
2 min read
How to get free Postgres

How to get free Postgres

Comments
2 min read
Week 1: New NOTR Server - Containerization and Data Storage

Week 1: New NOTR Server - Containerization and Data Storage

Comments
3 min read
Date Formatting in PostgreSQL

Date Formatting in PostgreSQL

Comments
2 min read
Custom SQL Scripts in PostgreSQL PgBench

Custom SQL Scripts in PostgreSQL PgBench

Comments
6 min read
Learn SQL with PostgreSQL: Building a Budget Tracking Application

Learn SQL with PostgreSQL: Building a Budget Tracking Application

Comments
5 min read
Supercharge Your Ecto Queries over Postgres JSONB with Flop: Filtering, Sorting, and Pagination

Supercharge Your Ecto Queries over Postgres JSONB with Flop: Filtering, Sorting, and Pagination

Comments
3 min read
[HELP] PG Trigger on before update

[HELP] PG Trigger on before update

Comments
1 min read
Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

Optimizing PostgreSQL Trigger Execution: Balancing Precision with Control

Comments
3 min read
Import Excel into PostgreSQL automatically-ExcelToPostgreSQL

Import Excel into PostgreSQL automatically-ExcelToPostgreSQL

Comments
2 min read
Simplify Your Development Workflow: How to Deploy PostgreSQL Using Docker

Simplify Your Development Workflow: How to Deploy PostgreSQL Using Docker

Comments
1 min read
Powering up schema migrations with pgroll

Powering up schema migrations with pgroll

Comments
6 min read
ubuntu server create database and create new user with password for there database in postgresql.

ubuntu server create database and create new user with password for there database in postgresql.

Comments
9 min read
Using the Django ORM - Building a Multiplayer Tic Tac Toe with Python, Docker, and AI, chapter 6

Using the Django ORM - Building a Multiplayer Tic Tac Toe with Python, Docker, and AI, chapter 6

Comments
4 min read
Introducing pgzx: create PostgreSQL extensions using Zig

Introducing pgzx: create PostgreSQL extensions using Zig

Comments
10 min read
Xata Dedicated Clusters for PostgreSQL

Xata Dedicated Clusters for PostgreSQL

Comments
8 min read
Get started with Drizzle ORM and Xata's Postgres service

Get started with Drizzle ORM and Xata's Postgres service

Comments
3 min read
Introducing usage monitoring in Xata

Introducing usage monitoring in Xata

Comments
5 min read
Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases

Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases

Comments
7 min read
PostgreSQL. How do you find potentially ineffective indexes?

PostgreSQL. How do you find potentially ineffective indexes?

Comments
2 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

Comments
2 min read
How to check the distribution of timestamps in a PostgreSQL table?

How to check the distribution of timestamps in a PostgreSQL table?

Comments
3 min read
"ERROR: Perform RPC timed out after 602.000s" in YSQL

"ERROR: Perform RPC timed out after 602.000s" in YSQL

Comments
2 min read
Strategic Indexing: Making Informed Column Indexing Decisions in PostgreSQL

Strategic Indexing: Making Informed Column Indexing Decisions in PostgreSQL

Comments
3 min read
Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

Boosting PostgreSQL Performance: Configuring Efficient Caching for Optimal Query Response

Comments
2 min read
Build a Live Search Feature with Django using HTMX and PostgreSQL FTS (in 10 minutes)

Build a Live Search Feature with Django using HTMX and PostgreSQL FTS (in 10 minutes)

Comments
6 min read
Dealing with duplicates

Dealing with duplicates

Comments
3 min read
A Clever Way To Implement Pessimistic Locking in EF Core

A Clever Way To Implement Pessimistic Locking in EF Core

Comments
5 min read
loading...