Browsing Tag
postgres
55 posts
How to Design a PostgreSQL Schema Visually (Step-by-Step)
1. What is a Schema? In PostgreSQL, a schema is just a folder inside your database where you…
Postgres is Too Good (And Why That’s Actually a Problem)
We need to talk about something that’s been bothering me for months. I’ve been watching indie hackers and…
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)
This guide covers a range of commonly used commands for interacting with and managing your PostgreSQL databases, from…
Stream PostgreSQL WALs with Zero Data Loss in Mind
pgrwl stream write-ahead logs from a PostgreSQL server 🚀 About The project serves as a research platform to…
How to deploy a Postgres continuous backup solution in under 5 minutes using Docker
[Song of the day: HELL ON ME — Johnny Huynh] Hey there! I was recently looking to help…
Getting Started with SQL DISTINCT
SQL DISTINCT is an essential feature for eliminating duplicate rows in query results. This article offers a quick…
Redoed #2: Containerizing the Go Server and PostgreSQL with Docker
Building Redoed : Containerizing the Go Server and PostgreSQL with Docker Now that we’ve got a basic HTTP…
Vector Databases vs. PostgreSQL with pg_vector for RAG Setups
Vector embeddings have become central to modern AI workflows, especially in RAG setups where retrieving semantically relevant information…
Storing and Querying OpenAI Embeddings in PostgreSQL with pg_vector
In this guide, we’ll explore how to effectively store, index, and query embeddings generated from OpenAI’s text-embedding-3-small model…
Is PostgreSQL Better Than MySQL?
One day, a group of developers engaged in a heated debate—nearly coming to blows—over whether PostgreSQL is superior…