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.
Our entire production schema is one table and 33 lines, and it has not changed in 71 days
daniel_pertu profile

Our entire production schema is one table and 33 lines, and it has not changed in 71 days

#postgres #database #stripe #typescript
Comments
7 min read
Why Our Oracle Migration Tool Won't Connect to Your Database
saad_akram_44bc637cbd3690 profile

Why Our Oracle Migration Tool Won't Connect to Your Database

#oracle #postgres #security #database
Comments
3 min read
A campaign that has searched every keyword gets eight new ones, and the worst eight switch off
daniel_pertu profile

A campaign that has searched every keyword gets eight new ones, and the worst eight switch off

#typescript #postgres #sql #ai
Comments
7 min read
Your Backups Don't Exist Until You've Restored One: A Monthly Drill for a Solo SaaS
posting-dude profile

Your Backups Don't Exist Until You've Restored One: A Monthly Drill for a Solo SaaS

#postgres #devops #saas #indiehackers
Comments
5 min read
Your data should outlive my company
nebosa_company_0edc92e18b profile

Your data should outlive my company

#selfhosted #postgres #opensource #database
Comments
7 min read
A row somebody photographed may never claim our top badge, and a CHECK constraint is what says so
daniel_pertu profile

A row somebody photographed may never claim our top badge, and a CHECK constraint is what says so

#postgres #database #architecture #typescript
Comments
6 min read
Your UUID Primary Keys Are Quietly Taxing Every Insert
jatinjainsaraf profile

Your UUID Primary Keys Are Quietly Taxing Every Insert

#postgres #database #performance #indexing
Comments
9 min read
Marketing automation with built‑in analytics in Herald
sumaninster profile

Marketing automation with built‑in analytics in Herald

#fastapi #react #celery #postgres
Comments
3 min read
Migration says applied, but production says column does not exist
gemmein profile
Ahmed

Migration says applied, but production says column does not exist

#postgres #prisma #supabase #webdev
Comments
8 min read
Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade
libme profile
Libme

Postgres Let Two Rows Through a Unique Index: The glibc Collation Trap After an OS Upgrade

#postgres #database #devops #sql
Comments
8 min read
Building an Agentic System in .NET, Part 5: Designing an Agent Bus in ASP.NET Core
mehdimohseni82 profile

Building an Agentic System in .NET, Part 5: Designing an Agent Bus in ASP.NET Core

#ai #postgres #aspnetcore #dotnet
Comments
6 min read
How long does a Patroni failover take? We measured it
twinhull profile

How long does a Patroni failover take? We measured it

#postgres #devops #database #sre
Comments
4 min read
The scarcest thing we own is a database connection
aditya_duttpandey_b33d2c profile

The scarcest thing we own is a database connection

#backend #database #performance #postgres
1
Comments
4 min read
Your Database Will Leak Someday: Field-Level Encryption and Blind Indexes for PII with Python and PostgreSQL
eme_gug_0821b41b948be6516 profile

Your Database Will Leak Someday: Field-Level Encryption and Blind Indexes for PII with Python and PostgreSQL

#security #python #postgres #encryption
Comments
7 min read
Why PostgreSQL MVCC Scales Better Than Lock-Based Reads for Read-Heavy Workloads
emrullah_bozkurt_0ceb498b profile

Why PostgreSQL MVCC Scales Better Than Lock-Based Reads for Read-Heavy Workloads

#postgres #mvcc #vacuum #performance
Comments
7 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.