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.
pgvector 0.6.0: 30x faster with parallel index builds

pgvector 0.6.0: 30x faster with parallel index builds

105
Comments
3 min read
Getting started with Ruby on Rails and Postgres on Supabase

Getting started with Ruby on Rails and Postgres on Supabase

98
Comments
4 min read
Simplify Complex SQL Queries with Common Table Expressions (CTEs)

Simplify Complex SQL Queries with Common Table Expressions (CTEs)

89
Comments 16
2 min read
How to Improve Performance of Your Database by Indexing Large Tables

How to Improve Performance of Your Database by Indexing Large Tables

86
Comments 15
4 min read
Video encoded as emojis⁉️ Stored in a DB? 😱🤯

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

85
Comments 16
9 min read
Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

Conway's game of life...in pure SQL [Postgres]! 💪🏼🤯

83
Comments 19
9 min read
How we made our Go microservice 24x faster

How we made our Go microservice 24x faster

78
Comments 3
7 min read
Good Bye CRUD APIs, Hello Sync: Realtime PostgreSQL with ElectricSQL

Good Bye CRUD APIs, Hello Sync: Realtime PostgreSQL with ElectricSQL

76
Comments 15
3 min read
Elixir clustering using Postgres

Elixir clustering using Postgres

72
Comments 2
4 min read
When to use SQL vs NoSQL

When to use SQL vs NoSQL

67
Comments 5
4 min read
Processing 1 Million SQL Rows to CSV using Node.js Streams

Processing 1 Million SQL Rows to CSV using Node.js Streams

61
Comments 7
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?

48
Comments 11
6 min read
How to create 700+ SEO optimised pages for website in 1 h using Next.JS, OpenAI, Postgres

How to create 700+ SEO optimised pages for website in 1 h using Next.JS, OpenAI, Postgres

45
Comments 5
4 min read
UUID in PostgreSQL

UUID in PostgreSQL

43
Comments 7
5 min read
JSON vs JSONB in PostgreSQL

JSON vs JSONB in PostgreSQL

40
Comments 3
3 min read
1 billion rows challenge in PostgreSQL and ClickHouse

1 billion rows challenge in PostgreSQL and ClickHouse

38
Comments 5
6 min read
Building scalable apps with serverless PostgreSQL & Django

Building scalable apps with serverless PostgreSQL & Django

36
Comments 5
7 min read
Deploying Documenso with Vercel, Supabase and Resend

Deploying Documenso with Vercel, Supabase and Resend

33
Comments 3
5 min read
Speed up your PostgreSQL bulk inserts with COPY

Speed up your PostgreSQL bulk inserts with COPY

33
Comments 5
5 min read
Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

32
Comments 1
4 min read
Intro to PostGraphile V5 (Part 1): Replacing the Foundations

Intro to PostGraphile V5 (Part 1): Replacing the Foundations

28
Comments
6 min read
A Better Way To Store Record Status In A Relational Database

A Better Way To Store Record Status In A Relational Database

27
Comments 6
8 min read
Index Optimization in Database Query Performance: Guidelines and Real-world Examples

Index Optimization in Database Query Performance: Guidelines and Real-world Examples

25
Comments 6
2 min read
Create an advanced search engine with PostgreSQL

Create an advanced search engine with PostgreSQL

25
Comments 1
13 min read
How to develop serverless PHP application with PostgreSQL database with Vercel and Neon.tech for free

How to develop serverless PHP application with PostgreSQL database with Vercel and Neon.tech for free

24
Comments 5
5 min read
How to load JSON data in PostgreSQL with the COPY command

How to load JSON data in PostgreSQL with the COPY command

20
Comments
4 min read
How to setup a PostgreSQL database with Docker Compose

How to setup a PostgreSQL database with Docker Compose

20
Comments 3
4 min read
Create a search engine with PostgreSQL: Postgres vs Elasticsearch

Create a search engine with PostgreSQL: Postgres vs Elasticsearch

20
Comments
11 min read
Faster Postgres Queries with Cloudflare Hyperdrive and Neon

Faster Postgres Queries with Cloudflare Hyperdrive and Neon

20
Comments 2
10 min read
Learnings from a 5-hour production downtime!

Learnings from a 5-hour production downtime!

20
Comments 4
4 min read
How to Use Iris and PostgreSQL for Web Development

How to Use Iris and PostgreSQL for Web Development

19
Comments
6 min read
PostgreSQL Optimization: A Quick Tip on Using Values Expression

PostgreSQL Optimization: A Quick Tip on Using Values Expression

18
Comments 3
2 min read
How to Create an Admin Panel for Your PostgreSQL Database on Railway Cloud

How to Create an Admin Panel for Your PostgreSQL Database on Railway Cloud

18
Comments 1
4 min read
How I migrated from Firebase to Supabase

How I migrated from Firebase to Supabase

17
Comments 2
5 min read
Mastering Dynamic Task Scheduling with Redis: How We Actually Solved Our SAAS Problem?

Mastering Dynamic Task Scheduling with Redis: How We Actually Solved Our SAAS Problem?

16
Comments
6 min read
Locks in PostgreSQL Part 2

Locks in PostgreSQL Part 2

16
Comments
5 min read
Leverage the power of PostgreSQL for validating data

Leverage the power of PostgreSQL for validating data

15
Comments 7
4 min read
How to Deploy Directus to Render.com

How to Deploy Directus to Render.com

15
Comments
3 min read
Mastering Postgres Debugging: must-know queries for database troubleshooting

Mastering Postgres Debugging: must-know queries for database troubleshooting

15
Comments 1
5 min read
Migrating from MySQL to PostgrеSQL: An Advancеd Guidе

Migrating from MySQL to PostgrеSQL: An Advancеd Guidе

15
Comments
2 min read
Lightweight implementation of Event Sourcing using PostgreSQL as an event store 🚀🕗🔙🕘

Lightweight implementation of Event Sourcing using PostgreSQL as an event store 🚀🕗🔙🕘

15
Comments
2 min read
Architectural choices that scale.

Architectural choices that scale.

15
Comments
4 min read
A unique database for every PR using CodeSandbox

A unique database for every PR using CodeSandbox

14
Comments 1
4 min read
Supercharge Your Rails App: Inserting 1 Million Records in 15s

Supercharge Your Rails App: Inserting 1 Million Records in 15s

14
Comments 3
6 min read
Astro with PostgreSQL

Astro with PostgreSQL

14
Comments 1
4 min read
Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases

Use PostgREST and HTMX to Build RESTful APIs from PostgreSQL Databases

13
Comments 3
16 min read
Terraforming AWS RDS : A practical guide with Postgres

Terraforming AWS RDS : A practical guide with Postgres

13
Comments
5 min read
Exporting a large PostgreSQL table using Python

Exporting a large PostgreSQL table using Python

13
Comments 2
2 min read
Learn Why we call to use index with PostgreSQL

Learn Why we call to use index with PostgreSQL

13
Comments
3 min read
Intro to PostGraphile V5 (Part 2): Plugins and Presets

Intro to PostGraphile V5 (Part 2): Plugins and Presets

13
Comments
6 min read
Create and deploy a backend API with PostgreSQL database in Go

Create and deploy a backend API with PostgreSQL database in Go

13
Comments
4 min read
PostGraphile V5 public beta — get involved!

PostGraphile V5 public beta — get involved!

13
Comments
6 min read
Supabase Needs Column Level Security

Supabase Needs Column Level Security

13
Comments 2
6 min read
PostgrеSQL and JSON: An Advancеd Guidе

PostgrеSQL and JSON: An Advancеd Guidе

12
Comments 1
3 min read
Track every PostgreSQL data change using Debezium

Track every PostgreSQL data change using Debezium

12
Comments 6
9 min read
Guide: Creating Stored Procedures in PostgreSQL

Guide: Creating Stored Procedures in PostgreSQL

12
Comments
4 min read
The Trade-offs Between Database Normalization and Denormalization

The Trade-offs Between Database Normalization and Denormalization

12
Comments 1
4 min read
Under the hood of CREATE on AGE cypher

Under the hood of CREATE on AGE cypher

12
Comments 1
4 min read
Database GitOps with Bytebase for PostgreSQL

Database GitOps with Bytebase for PostgreSQL

12
Comments 1
3 min read
Inicializando um projeto Ruby on Rails usando PostgreSql rodando em um container Docker

Inicializando um projeto Ruby on Rails usando PostgreSql rodando em um container Docker

11
Comments
1 min read
loading...