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.
SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

SQL's LIKE, ILIKE, and NOT LIKE: Beginner's Breakdown

8
Comments
2 min read
How does Wave Analytics handle data from external databases in PostgreSQL?

How does Wave Analytics handle data from external databases in PostgreSQL?

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

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

87
Comments 17
9 min read
Simplified SQL: Harnessing the Power of Aliases

Simplified SQL: Harnessing the Power of Aliases

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

Exploring Advanced SQL Techniques: Aggregation Methods for Structured Data Retrieval

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

How I migrated from Firebase to Supabase

24
Comments 3
5 min read
Postgres partitioning performance: Hash vs. List

Postgres partitioning performance: Hash vs. List

10
Comments
8 min read
How to ditch Neon

How to ditch Neon

6
Comments
3 min read
Easy Self-Hosted Git Installation on Ubuntu Server

Easy Self-Hosted Git Installation on Ubuntu Server

2
Comments
8 min read
SQL AGGREGATE FUNCTIONS

SQL AGGREGATE FUNCTIONS

Comments
2 min read
Date Formatting in PostgreSQL

Date Formatting in PostgreSQL

Comments
2 min read
INTRODUCTION TO SQL

INTRODUCTION TO SQL

1
Comments 2
4 min read
A Software Engineer's Tips and Tricks #2: Template Databases in PostgreSQL

A Software Engineer's Tips and Tricks #2: Template Databases in PostgreSQL

1
Comments
3 min read
How to use Retrieval Augmented Generation (RAG) for Go applications

How to use Retrieval Augmented Generation (RAG) for Go applications

10
Comments 1
12 min read
Using AI on top of your DB

Using AI on top of your DB

Comments 1
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.