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.
40001 is not a query error
mohamedaboelmagd profile

40001 is not a query error

#postgres #node #typescript #database
1
Comments
8 min read
We Replaced 3 Microservices With One Postgres Table
infoinlet1 profile

We Replaced 3 Microservices With One Postgres Table

#postgres #architecture #backend #sql
11
Comments 1
7 min read
Simple PostgreSQL
chad_3a62e9557f66829b45bb profile
Chad

Simple PostgreSQL

#database #postgres #software #tools
Comments
1 min read
Database Views in Your ERD: Read-Only Entities, Not Fake Tables
tbson87 profile

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

#database #sql #postgres #architecture
Comments 1
5 min read
Why PGlite Is Quietly Fixing the Open-Source Contributor Onboarding Problem
lucas_martin_8cb158b9a81b profile

Why PGlite Is Quietly Fixing the Open-Source Contributor Onboarding Problem

#postgres #opensource #webdev #devtools
2
Comments 1
3 min read
Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View
tbson87 profile

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

#database #postgres #supabase #sql
Comments
6 min read
SQLAlchemy Composite Foreign Keys for Multi-Tenant Hierarchical Permissions: Enforcing (tenant_id, role_id) Constraints
uaslimcreate profile

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

#sqlalchemy #postgres #multitenancy #security
Comments 1
4 min read
The API Endpoint Explosion: What If AI Agents Could use SQL on User Data Directly?
slipxnot profile

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

#ai #mcp #database #postgres
Comments 2
8 min read
Installing FreeRADIUS with PostgreSQL
sharmukh profile

Installing FreeRADIUS with PostgreSQL

#postgres #linux #networking #security
12
Comments
7 min read
Why Your OAuth Integration Randomly Returns invalid_grant (and How to Stop Two Workers From Racing)
libme profile

Why Your OAuth Integration Randomly Returns invalid_grant (and How to Stop Two Workers From Racing)

#api #backend #security #postgres
Comments
7 min read
Postgres earthdistance
dshumw profile

Postgres earthdistance

#database #postgres #sql
Comments
1 min read
The `featured` Column That Cost Us Money (and the Schema That Fixed It)
member_5432fd74 profile

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

#postgres #database #architecture #webdev
Comments 1
5 min read
PostgreSQL 16, 17, and 18 on a Serverless Engine
scalixworld profile

PostgreSQL 16, 17, and 18 on a Serverless Engine

#database #postgres #serverless
Comments
5 min read
The AI demo failed, but the database remembered half of it

Summer Bug Smash: Smash Stories 🐛🛹
jtorchia profile

The AI demo failed, but the database remembered half of it

#opensource #devchallenge #bugsmash #postgres
5
Comments 3
9 min read
The frontend bug that hid 170 custom SEO titles for 3 months (and 3 weeks of shipping after finding it)
serhii_kalyna_730b636889c profile

The frontend bug that hid 170 custom SEO titles for 3 months (and 3 weeks of shipping after finding it)

#webdev #seo #postgres #nextjs
8
Comments 7
8 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.