#PostGreSQL

Learn how to test Supabase RLS as a second user in 30 seconds. Five lines in the SQL editor. 0 rows means your policy holds. Any rows means user B can read user A's data. AI clone video of me, Roy. #Supabase #PostgreSQL

After a dream last night, I had the idea to animate the flow between nodes. Speed depends on node duration. #pev2 #postgresql #explain

If you’re in SFO this week you *SHOULD* come to @PlanetScale office on Nov 4th to celebrate 30y of @PostgreSQL. The entire PlanetScale Postgres Core Team will be there plus Bruce Momjian “The #PostgreSQL Legend”. Come to have some fun and talk about Postgres. #PostgresForEverything

Come to our office on Wednesday and celebrate 30 years of Postgres

Three RLS policies. One of them lets a stranger write into your account. Read own: auth.uid() = user_id. Insert: with check (true). Update own: auth.uid() = user_id. Which one? #Supabase #PostgreSQL

Database migrations at scale are rarely clean. @Netflix had nearly 400 #PostgreSQL clusters to move and doing it manually was never an option. So they built a self-service automated workflow instead. This is a really interesting read! The approach uses #Aurora read replicas for near-zero downtime, with traffic cutover handled through their Data Access Layer rather than application code changes. Replication lag, WAL validation, and CDC handling were all covered. This writeup from Ram Srivasta Kannan, Wale Akintayo, Jay Bharadwaj, John Crimmins, Shengwei Wang, and Zhitao Zhu is worth a read if you manage databases at any meaningful scale. Check it out!

🐘 Still switching tools to work with PostgreSQL? Bring your database into VS Code. Connect, explore tables, and start writing SQL without leaving your editor. 🎬 PostgreSQL Like a Pro: VS Code Edition #vscode #postgresql

Struggling to pinpoint why your #PostgreSQL query is slow? EXPLAIN (ANALYZE, BUFFERS) gives the execution plan, but complex plans can hide performance clues. 🧠Plan visualizers save the day! What are your favorite tools for visualizing & optimizing Postgres query plans?

A Go-based tool for Effortless #PostgreSQL backups with a user-friendly web interface #golang

Postgres 19 is late. Robert Haas says: “The short answer is that LLMs happened.” AI is finding bugs that sat in the code for years. Commits to the stable branch in the same window: 248 last year, 433 this year. GA: Nov 19. Finding bugs got cheap. Fixing them didn't.

Robert Haas, PostgreSQL committer, explains why Postgres 19 is delayed in this Neon blog post (21 Oct): Release schedule: RC2 on 12 Nov, GA on 19 Nov:

Day 36/100 PostgreSQL 🐘💻 Today, I learned more about database constraints, including UNIQUE, CHECK, and PRIMARY KEY. I also explored the OR operator and how it helps combine multiple conditions in SQL queries. #100DaysOfCode #PostgreSQL #SQL #BackendDevelopment

Paradigma Software drops Valentina 18.4 — major Query Editor upgrades for faster diagram-to-SQL workflows + unattended macOS Server install & Java 27 support. Free version. Learn More [ ] #postgresql #diagram #database

FREE SQL Tutorial with 31 lessons covering every SQL command you for Data Analytics & Data Science. Unlike YouTube tutorials this includes 20+ interactive SQL exercises which you solve directly in the browser! #sql #postgresql #dataanalytics

New to running #Postgres on #K8s? Start here: Getting Started with Percona PostgreSQL Operator #PostgreSQL #Kubernetes

src/include/utils/jsonb.h illustrated :) #postgresql

Spot the missing words: create policy "team read" on notes for select using (true); No TO clause means TO public, and public includes anon. Signed out, as anon: 3 rows. #Supabase #PostgreSQL

Not every database bug produces an error. Concurrent updates can silently leave incorrect data. In a Percona Community post, Jack VanSickle uses two clients to recreate #PostgreSQL lost updates and show a conditional UPDATE fix. #OpenSource #Databases

Someone found your anon key in your JavaScript. Panic? No. Supabase ships it to every browser on purpose. It is now called the publishable key: low privileges, identifies your app, not a user. Every row still goes through your RLS policies. #Supabase #PostgreSQL

PostgreSQL 19 Beta 1 adds ON CONFLICT DO SELECT. Insert a row. If it already exists, return it. Atomic get-or-create, finally. 👇 #PostgreSQL #SQL

How @datadoghq redesigned their #Kubernetes-based #PostgreSQL clusters for failover safety, how they balanced durability against latency, and what they learned while validating this approach through benchmarking & failure testing. #DevOps

Save the date: PGConf India 2027 is on 2–5 March at the Sheraton Grand Hotel, Bengaluru. Talks on 3–4 March, hands-on workshops on 2 and 5 March. #PostgreSQL #PGConfIndia