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.
I couldn't touch the database, so I built search next to it
_er2es_ profile
Szj

I couldn't touch the database, so I built search next to it

#sql #symfony #fuzzy #postgres
1
Comments 2
9 min read
Multi-Tenancy in SaaS: Choosing Between Shared Tables, Schemas and Separate Databases
macrogenltd profile

Multi-Tenancy in SaaS: Choosing Between Shared Tables, Schemas and Separate Databases

#saas #postgres #architecture #database
3
Comments 3
2 min read
Your dashboard is green and the number is wrong: the SQL checks I schedule next to every metric
refaeldakar profile

Your dashboard is green and the number is wrong: the SQL checks I schedule next to every metric

#dataengineering #sql #analytics #postgres
1
Comments 3
4 min read
I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.
xneuronal profile

I put reminders, contacts and recipes in the same Postgres table. Here is the SQL, and what it cost.

#postgres #database #architecture #ai
Comments
5 min read
Using an AST to validate AI-generated PostgreSQL before it runs
nur-zaman profile

Using an AST to validate AI-generated PostgreSQL before it runs

#postgres #ai #security #typescript
Comments
3 min read
The RLS Policy Was Correct. The Write Was Still Wrong.
toddsullivan profile

The RLS Policy Was Correct. The Write Was Still Wrong.

#security #supabase #postgres #devops
Comments
3 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
vivekdraxlr profile

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

#sql #database #ai #postgres
Comments
7 min read
PostgreSQL 19's WAIT FOR LSN command replaces the read-your-writes polling loop
alexgeorgiev17 profile

PostgreSQL 19's WAIT FOR LSN command replaces the read-your-writes polling loop

#postgres #database #devops #performance
15
Comments 2
8 min read
Stop building your own vector index: Why managed services are eating the Postgres ecosystem
aniketsoni profile

Stop building your own vector index: Why managed services are eating the Postgres ecosystem

#postgres #database #ai #infrastructure
1
Comments 1
5 min read
Do Supabase backups include Storage files?
aktisdev profile
AK D

Do Supabase backups include Storage files?

#supabase #postgres #backup #database
Comments
4 min read
Preventing Race Conditions in Symfony with Doctrine and PostgreSQL
mykola_vantukh profile

Preventing Race Conditions in Symfony with Doctrine and PostgreSQL

#symfony #php #doctrine #postgres
6
Comments
8 min read
How to catch a missing index in a test, when your test table has 20 rows.
ldavidsm profile

How to catch a missing index in a test, when your test table has 20 rows.

#python #postgres #testing #performance
Comments 6
6 min read
One View Per Layer: Four Sharp Edges I Found in My Own Code
srdjan_poppovic profile

One View Per Layer: Four Sharp Edges I Found in My Own Code

#postgres #gis #django #webdev
Comments
6 min read
A Small Fintech Challenge, and Why I Let Postgres Hold the Money
jeyem profile

A Small Fintech Challenge, and Why I Let Postgres Hold the Money

#postgres #go #fintech #concurrency
Comments
4 min read
Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python
sergey_rudenko_40963c1b7f profile

Moving Oracle to PostgreSQL with a Single `INSERT` — No Oracle Client, No Python

#dataengineering #duckdb #oracledatabase #postgres
Comments
11 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.