#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

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

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

How Patroni Addresses the Problem of the Logical Replication Slot Failover in a #PostgreSQL Cluster

Amazon Aurora #PostgreSQL Serverless – Now Generally Available - - Nice post, @danilop ! #AWS

=# SELECT status, eta FROM postcompass; 𝗗𝗥𝗢𝗣𝗣𝗜𝗡𝗚 | 𝗦𝗢𝗢𝗡 PostCompass: a fast, native desktop app for PostgreSQL. One click. Zero setup. Every cloud, one place. Free, open source, built with Rust + Tauri. 🚀 #PostgreSQL #OpenSource #DeveloperTools #BuildInPublic

PostgreSQL Custom Dashboards Ported to Percona Monitoring and Management 2 #PostgreSQL #Percona #PMM

PostgreSQL 13 handy small feature - DROP DATABASE WITH (FORCE) #PostgreSQL

PostgreSQL is the DBMS of the Year @PostgreSQL #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

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

🆕 Distributed #PostgreSQL comes to #AzureCosmosDB Today, we’re excited to announce Azure Cosmos DB for PostgreSQL, a new Generally Available service to build cloud-native relational applications. Read more: #MSIgnite

Postgres intelligence for AI agents & apps, written in Go #golang #postgreSQL

The software world doesn’t need one company shaping its databases. PostgreSQL proves open alternatives can lead—and MariaDB and Julia show there’s more than one path forward. #PostgreSQL #OpenSource

Spatial Data Management with PostGIS - A free #geospatial course with 12 videos (5 hours) that teaches practical skills for using #PostGIS with #PostgreSQL, #QGIS, #GeoPandas, #Jupyter notebook. YouTube Playlist: #freecourses #programming #GIS #database

PostgreSQL 14 – Performance, Security, Usability, and Observability #PostgreSQL

Build a SaaS App with Django, Stripe, Neon PostgreSQL, TailwindCSS, GitHub Actions #python #django #postgresql #neon

You turned on RLS and your app went blank. That is not a bug. That is the default. RLS on with zero policies means deny everything. User A: 0 rows. Insert fails. The table owner still sees all 3 rows, because owners skip RLS. #Supabase #PostgreSQL

You must know exactly what your AI agents are touching. Scalefield Secure gives real-time visibility to balance autonomous innovation with data safety. Protect your enterprise PostgreSQL estate today. #DataGovernance #PostgreSQL #AI