#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

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!

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

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

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

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

The best PostgreSQL GUI depends on your workflow. Compare leading tools by SQL editing, schema management, platform support, security, licensing and budget in our 2026 guide. Explore the comparison in the first reply 👇 #PostgreSQL #DatabaseTools

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?

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

🐘 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

#psycopg3 3.0 has been released! Thank you @linuxhiker, @obartunov and thank you to everyone who has contributed, sponsored, helped. Try it out. It's good stuff. #python #postgresql #freesoftware

Go Authentication Tutorial | Registration, Login & Session Cookies with PostgreSQL by @bright_alaribe #golang #postgresql

What a week with the PostgreSQL community in Valencia! 🐘🇪🇸 We were proud to be a Gold Sponsor of #PGConfEU, with Percona speakers taking the stage and our team connecting with PostgreSQL enthusiasts from around the world. Thanks for a great week! 📸 #PostgreSQL #OpenSource

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

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

Protect sensitive PostgreSQL data with DataSunrise. Apply dynamic and static masking, preserve data usability, and reduce exposure across production, development, analytics, and data-sharing workflows. #PostgreSQL #DataMasking #DataSecurity

Hot off the press 📣 Deep dive into why & how the UK Coronavirus Dashboard uses #PostgreSQL on Azure * open-access time series data * role of open source * distributed scale w/@citusdata * perf tuning Thx 👏 @clairegiordano & @Pouriaaa 👋 for this post

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

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

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