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.
Create a Restful API with Golang from scratch

Create a Restful API with Golang from scratch

536
Comments 17
13 min read
How to set up a free PostgreSQL database on Heroku

How to set up a free PostgreSQL database on Heroku

366
Comments 13
3 min read
Write a Simple REST API in Golang

Write a Simple REST API in Golang

330
Comments 15
10 min read
Improving PostgreSQL queries

Improving PostgreSQL queries

232
Comments 6
23 min read
SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

SQL tips for beginners; what I learned after 10+ years of occasionally writing queries and schemas as a web dev

209
Comments 31
2 min read
More than "Hello World" in Docker: Build Rails + Sidekiq web apps in Docker

More than "Hello World" in Docker: Build Rails + Sidekiq web apps in Docker

198
Comments 22
14 min read
Getting Started with Sequelize and Postgres

Getting Started with Sequelize and Postgres

196
Comments 27
6 min read
How To Install and Run PostgreSQL using Docker ?

How To Install and Run PostgreSQL using Docker ?

188
Comments 17
3 min read
📖 Build a RESTful API on Go: Fiber, PostgreSQL, JWT and Swagger docs in isolated Docker containers

📖 Build a RESTful API on Go: Fiber, PostgreSQL, JWT and Swagger docs in isolated Docker containers

183
Comments 20
27 min read
Set up a free PostgreSQL database on Supabase to use with Prisma

Set up a free PostgreSQL database on Supabase to use with Prisma

183
Comments 19
6 min read
Supabase - An OpenSource Firebase Alternative

Supabase - An OpenSource Firebase Alternative

172
Comments 7
5 min read
Using Domain-Driven Design(DDD)in Golang

Using Domain-Driven Design(DDD)in Golang

170
Comments 26
7 min read
A poor man's API

A poor man's API

163
Comments 8
7 min read
PostgreSQL vs MongoDB

PostgreSQL vs MongoDB

163
Comments 76
1 min read
8 New SQL Tools That Will Change How You Work in 2020

8 New SQL Tools That Will Change How You Work in 2020

163
Comments 7
6 min read
User Authorization in NodeJS using PostgreSQL

User Authorization in NodeJS using PostgreSQL

152
Comments 14
10 min read
The magic of react-query and supabase

The magic of react-query and supabase

148
Comments 14
17 min read
Desenvolvendo uma Aplicação CRUD Node.js com PostgreSQL

Desenvolvendo uma Aplicação CRUD Node.js com PostgreSQL

147
Comments 6
15 min read
Backend Master Class [Go + Postgres + Kubernetes + AWS]

Backend Master Class [Go + Postgres + Kubernetes + AWS]

145
Comments 38
3 min read
PostgreSQL cheat sheet for beginners

PostgreSQL cheat sheet for beginners

134
Comments 4
2 min read
Django Project Tutorial for beginners: Settings, Docker-Compose, Postgres and Redis

Django Project Tutorial for beginners: Settings, Docker-Compose, Postgres and Redis

127
Comments 10
30 min read
Self-hosting with Supabase

Self-hosting with Supabase

125
Comments 16
9 min read
Creating a dashboard for Postgres db with React and Recharts

Creating a dashboard for Postgres db with React and Recharts

124
Comments
8 min read
Build a event-driven app with Micronaut, Kafka and Debezium

Build a event-driven app with Micronaut, Kafka and Debezium

122
Comments 2
27 min read
Fullstack Engineering Mistakes to Avoid

Fullstack Engineering Mistakes to Avoid

120
Comments
16 min read
Let's learn Node.js by building a backend with Nest.js and Sequelize

Let's learn Node.js by building a backend with Nest.js and Sequelize

116
Comments
6 min read
Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

Cascade of doom: JIT, and how a Postgres update led to 70% failure on a critical national service

108
Comments 29
14 min read
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
Demystifying Docker Compose

Demystifying Docker Compose

105
Comments 9
4 min read
Dynamically generating SQL queries using Node.js

Dynamically generating SQL queries using Node.js

104
Comments 26
6 min read
How To Build a CRUD RESTful API with Node.js, Prisma, and PostgreSQL in 5 Steps

How To Build a CRUD RESTful API with Node.js, Prisma, and PostgreSQL in 5 Steps

101
Comments 19
12 min read
Creating a Simple Contacts List with Go and PostgreSQL

Creating a Simple Contacts List with Go and PostgreSQL

100
Comments
10 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
Create a Slack clone with Next.js and Supabase 03:38

Create a Slack clone with Next.js and Supabase

95
Comments 1
2 min read
showDEV - A place to share personal and open-source coding projects!

showDEV - A place to share personal and open-source coding projects!

95
Comments 27
1 min read
PostgreSQL Tutorial for beginners to Advance level.

PostgreSQL Tutorial for beginners to Advance level.

95
Comments 2
18 min read
Development environment for Elixir + Phoenix with Docker and Docker-compose

Development environment for Elixir + Phoenix with Docker and Docker-compose

92
Comments 20
4 min read
Supabase: seven months of building. 02:55

Supabase: seven months of building.

92
Comments 16
3 min read
Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

Beware The Missing Foreign Key Index: A Postgres Performance Gotcha

92
Comments 6
12 min read
A powerful full-text search in PostgreSQL in less than 20 lines

A powerful full-text search in PostgreSQL in less than 20 lines

92
Comments 6
9 min read
4 SQL Tips For Data Scientists And Data Analysts

4 SQL Tips For Data Scientists And Data Analysts

91
Comments 4
7 min read
Developing a CRUD Node.js Application with PostgreSQL

Developing a CRUD Node.js Application with PostgreSQL

91
Comments 15
14 min read
Is the database working as expected?

Is the database working as expected?

90
Comments 22
1 min read
NestJS CRUD with Postgres and TypeORM

NestJS CRUD with Postgres and TypeORM

89
Comments 1
6 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
Supabase: ten months of building. 03:50

Supabase: ten months of building.

88
Comments 13
3 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
PostgreSQL For Those Who Can’t Even, Part 1

PostgreSQL For Those Who Can’t Even, Part 1

84
Comments 3
8 min read
Quick Demo! Build a slack clone 01:50

Quick Demo! Build a slack clone

84
Comments 13
1 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
Fuzzy Searching with PostgreSQL

Fuzzy Searching with PostgreSQL

80
Comments 4
6 min read
Keep it simple stupid: Building full text search across all your tools with Postgres

Keep it simple stupid: Building full text search across all your tools with Postgres

80
Comments 6
8 min read
Multiple Foreign Keys for the Same Relationship in Rails 6

Multiple Foreign Keys for the Same Relationship in Rails 6

80
Comments 11
4 min read
Django Rest Framework with PostgreSQL: A CRUD Tutorial

Django Rest Framework with PostgreSQL: A CRUD Tutorial

79
Comments 3
9 min read
Building a Prisma Schema

Building a Prisma Schema

79
Comments 3
13 min read
Building a simple Grocery App in Flutter with Supabase

Building a simple Grocery App in Flutter with Supabase

79
Comments 11
13 min read
How we made our Go microservice 24x faster

How we made our Go microservice 24x faster

78
Comments 3
7 min read
How to create a React Native app with PostgreSQL and GraphQL: Part 1

How to create a React Native app with PostgreSQL and GraphQL: Part 1

78
Comments
11 min read
Rails + PostgreSQL JSONB (Part 1)

Rails + PostgreSQL JSONB (Part 1)

77
Comments 5
6 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
loading...