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.
Import Data into Light Cloud: Upload a .sql Dump or Stream It with psql
julia_kafarska profile

Import Data into Light Cloud: Upload a .sql Dump or Stream It with psql

#lightcloud #cloudplatform #tutorial #postgres
Comments
4 min read
TypeSQL: type-safe plain SQL in TypeScript
ismailkarsli profile

TypeSQL: type-safe plain SQL in TypeScript

#sql #postgres #typescript #webdev
Comments
4 min read
Shopify can't tell you who changed your stock, so I built a ledger for 4 stores
fahadazhar1 profile

Shopify can't tell you who changed your stock, so I built a ledger for 4 stores

#shopify #postgres #supabase #ecommerce
1
Comments 2
3 min read
Exploring tenant isolation with Spring Boot, OIDC, and PostgreSQL RLS
chafian profile

Exploring tenant isolation with Spring Boot, OIDC, and PostgreSQL RLS

#java #springboot #postgres #security
1
Comments
5 min read
Don't DROP COLUMN while old app code still reads it
labyrinthlab profile

Don't DROP COLUMN while old app code still reads it

#postgres #database #devops #sql
1
Comments
3 min read
Our app opens two Postgres pools, and exactly one method crosses from the first to the second
daniel_pertu profile

Our app opens two Postgres pools, and exactly one method crosses from the first to the second

#postgres #nextjs #serverless #webdev
1
Comments
5 min read
Read-Only Postgres Role for AI Agents: 7 Gaps to Close
claix profile

Read-Only Postgres Role for AI Agents: 7 Gaps to Close

#postgres #ai #security #database
2
Comments 2
10 min read
Measuring realized Cardano staking yield from cardano-db-sync: epoch rewards over epoch stake, split by pool size
elliotagent profile

Measuring realized Cardano staking yield from cardano-db-sync: epoch rewards over epoch stake, split by pool size

#cardano #postgres #sql #datascience
Comments
4 min read
Two AI-Generated PostgreSQL TLS Patches. One Passed. One Broke Startup.
masora profile
Dan G.

Two AI-Generated PostgreSQL TLS Patches. One Passed. One Broke Startup.

#showdev #ai #security #postgres
Comments 2
2 min read
Patroni, Ubuntu 24.04, and two unplanned PostgreSQL failovers
franckpachot profile

Patroni, Ubuntu 24.04, and two unplanned PostgreSQL failovers

#postgres #ha #patroni #ubuntu
1
Comments 1
17 min read
Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON
daniel_pertu profile

Our 32 migrations are 36 KB of SQL, and the folder they live in holds 2.4 MB of JSON

#database #postgres #typescript #webdev
Comments
6 min read
Our maintenance mode is one boolean in a TypeScript file, and it taught us that our sign-in pages are not public
daniel_pertu profile

Our maintenance mode is one boolean in a TypeScript file, and it taught us that our sign-in pages are not public

#webdev #nextjs #postgres #devops
Comments
6 min read
The biggest delete in our app is one line of raw SQL against a table our ORM does not manage
daniel_pertu profile

The biggest delete in our app is one line of raw SQL against a table our ORM does not manage

#postgres #database #webdev #typescript
Comments
6 min read
CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction
labyrinthlab profile

CREATE INDEX on a live Postgres table locks writes. CONCURRENTLY fixes that, if you keep it out of a transaction

#postgres #sql #database #devops
Comments
3 min read
Supabase multi-tenant RLS: membership policy pattern
toritic profile
TIC

Supabase multi-tenant RLS: membership policy pattern

#supabase #postgres #security #saas
Comments 1
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.