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.
PostgreSQL ve Redis Neden Birlikte Kullanılır?

PostgreSQL ve Redis Neden Birlikte Kullanılır?

Comments
2 min read
Simple PostgreSQL

Simple PostgreSQL

Comments
1 min read
Database Views in Your ERD: Read-Only Entities, Not Fake Tables

Database Views in Your ERD: Read-Only Entities, Not Fake Tables

Comments 1
5 min read
Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

Comments
6 min read
SQLAlchemy Composite Foreign Keys for Multi-Tenant Hierarchical Permissions: Enforcing (tenant_id, role_id) Constraints

SQLAlchemy Composite Foreign Keys for Multi-Tenant Hierarchical Permissions: Enforcing (tenant_id, role_id) Constraints

Comments 1
4 min read
The API Endpoint Explosion: What If AI Agents Could use SQL on User Data Directly?

The API Endpoint Explosion: What If AI Agents Could use SQL on User Data Directly?

Comments 2
8 min read
The `featured` Column That Cost Us Money (and the Schema That Fixed It)

The `featured` Column That Cost Us Money (and the Schema That Fixed It)

Comments 1
5 min read
PostgreSQL 16, 17, and 18 on a Serverless Engine

PostgreSQL 16, 17, and 18 on a Serverless Engine

Comments
5 min read
What PostgreSQL migration made you nervous, furious, or surprised you in production?

What PostgreSQL migration made you nervous, furious, or surprised you in production?

1
Comments
1 min read
I turned 100k county property records into a free "instant comps" tool

I turned 100k county property records into a free "instant comps" tool

Comments
2 min read
Databricks buys Electric to embed local Postgres in AI agents

Databricks buys Electric to embed local Postgres in AI agents

4
Comments
5 min read
Faster Bulk Inserts in PostgreSQL

Faster Bulk Inserts in PostgreSQL

1
Comments 2
12 min read
Database Optimization: From Slow to Fast

Database Optimization: From Slow to Fast

1
Comments
4 min read
Gated B2B Pricing in Next.js: Hiding Prices Behind Per-Customer Access

Gated B2B Pricing in Next.js: Hiding Prices Behind Per-Customer Access

Comments
10 min read
Postgres Array Column vs Junction Table: What Each One Does to Your ERD

Postgres Array Column vs Junction Table: What Each One Does to Your ERD

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