#PostGreSQL

🐘 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

🐘 Migrating from PostgreSQL 17 to 18? Learn how to back up, migrate, and restore your databases with Portabase. No manual dump scripts required. 📖 Step-by-step guide: #PostgreSQL #OpenSource #Portabase

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

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

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

A quick #PostgreSQL note! 💻 Post-#pgconfeu bug 🤒 but Valencia inspired me to write like crazy! 🇪🇸✨ Next week, blogs on: 🌱 Postgres in Universities 🌍 A new PG Global Support Directory ( yours! 👇) 🇬🇧 The PG UK Gap 🧠 No AI in #ThePostgresRecruiter / #Postgres

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

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

Goodbye etcd! Running #Kubernetes on Distributed #PostgreSQL Kubernetes once favored Etcd as a database for all cluster data. Back then, relational DB lacked the availability & scalability characteristics required by #K8s #KubeCon

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!

Tomorrow I'll publish a deep dive on PostgreSQL’s optimizer and how Postgres decides how to run your SQL. If you only read one of my Postgres posts, make it this one. Great for anyone who writes SQL. 👉 #PostgreSQL #SQL #Databases

🚨 PostgreSQL 18: RETURNING now supports OLD and NEW values on UPDATE! #SQL #PostgreSQL

Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade - MigOps Blog #PostgreSQL

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

🚀 𝗣𝗼𝘀𝘁𝗖𝗼𝗺𝗽𝗮𝘀𝘀 𝗶𝘀 𝗹𝗶𝘃𝗲. PostgreSQL in one click. No Docker. No setup. Free and open source, for Windows, macOS and Linux. ⬇️ #PostgreSQL #OpenSource #BuildInPublic #DevTools

The PostgreSQL project resolved 15 critical pgAdmin 4 vulnerabilities in version 9.19, fixing command injection flaw CVE-2026-116241 and credential leaks. #pgAdmin4 #PostgreSQL #DatabaseSecurity #CVE2026116241 #RCE #Cybersecurity #Vulnerability #InfoSec

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

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

#PostgreSQL #ThePostgresSpectrum #ThePostgresRecruiter #PostgresSupport

Why Postgres? It's popular. That's not engineering. That's gossip. Money, orders, relations → PostgreSQL. Catalogs, content, shapes that keep changing → MongoDB. Choose by your application. Not by hype or price. #BackendEngineering #PostgreSQL #MongoDB #SystemDesign