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.
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 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
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
What PostgreSQL migration made you nervous, furious, or surprised you in production?
d_security profile

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

#opensource #postgres #rust #productivity
1
Comments
1 min read
How Stripe Avoids Double-Charging Anyone
devopsdaily profile

How Stripe Avoids Double-Charging Anyone

#reliability #systemdesign #postgres #api
5
Comments
18 min read
I turned 100k county property records into a free "instant comps" tool
justincrowcre profile

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

#showdev #webdev #postgres #serverless
Comments
2 min read
Databricks buys Electric to embed local Postgres in AI agents
vpodk profile

Databricks buys Electric to embed local Postgres in AI agents

#databricks #postgres #aiagents #databasearchitecture
4
Comments
5 min read
Faster Bulk Inserts in PostgreSQL
nicolas_vbgh profile

Faster Bulk Inserts in PostgreSQL

#postgres #database #performance #python
1
Comments 2
12 min read
Installing Apache Airflow on Ubuntu 24.04
sharmukh profile

Installing Apache Airflow on Ubuntu 24.04

#airflow #python #postgres #devops
13
Comments
6 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.