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 + Ollama Setup

pgvector + Ollama Setup

Comments
4 min read
Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE

Beyond Basics: Mastering SQL's LEAD, LAG, RANK, DENSE_RANK, and NTILE

Comments
6 min read
Why our Free was so far behind Pro — and what we just shipped in RedBase 3.0.0 (with the actual SQL)

Why our Free was so far behind Pro — and what we just shipped in RedBase 3.0.0 (with the actual SQL)

Comments
24 min read
PostgreSQL Plan Signatures: Quick Reference

PostgreSQL Plan Signatures: Quick Reference

Comments
7 min read
Indexing every WHERE column is not PostgreSQL optimization

Indexing every WHERE column is not PostgreSQL optimization

1
Comments
1 min read
Provisioning PostgresSQL RDBMS on AWS with Terraform

Provisioning PostgresSQL RDBMS on AWS with Terraform

Comments
5 min read
Why Supavisor 1.0 Is Written in Elixir (And Why That's Actually a Brilliant Move)

Why Supavisor 1.0 Is Written in Elixir (And Why That's Actually a Brilliant Move)

Comments
9 min read
pgvector with Node.js: Build Semantic Search on PostgreSQL

pgvector with Node.js: Build Semantic Search on PostgreSQL

Comments
4 min read
Tracing a 2s Latency Spike to a Single SQL Query

Tracing a 2s Latency Spike to a Single SQL Query

Comments
2 min read
Building a Multi-Tenant Clinic SaaS with NestJS + Prisma: What 12 Months in Production Taught Me

Building a Multi-Tenant Clinic SaaS with NestJS + Prisma: What 12 Months in Production Taught Me

Comments 1
6 min read
1.2 Parser and Analyzer: How SQL Gets Its Meaning

1.2 Parser and Analyzer: How SQL Gets Its Meaning

Comments
2 min read
Why I Made the Ledger Refuse Single Rows

Why I Made the Ledger Refuse Single Rows

Comments
6 min read
SQLite vs PostgreSQL for Small Projects: When to Use Which

SQLite vs PostgreSQL for Small Projects: When to Use Which

Comments
6 min read
SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

SQL String Functions: Clean, Transform, and Tame Messy Data Like a Pro

Comments
6 min read
Why your Supabase query stops at exactly 1000 rows (and never tells you)

Why your Supabase query stops at exactly 1000 rows (and never tells you)

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.