#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!

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

Day 2: PostgreSQL 🚀 Learned to filter data using SELECT, WHERE, AND, OR, IN, BETWEEN & LIKE. Small progress. Stronger SQL skills. One step closer to becoming a better backend developer. 💻 #PostgreSQL #BackendDevelopment

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

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

Today, I learned an important backend lesson while building my NestJS e-commerce API. Migrating existing data safely. I learned about data backfilling, SQL migrations, foreign keys, and data integrity. Backend engineering is more than writing endpoints. #NestJS #PostgreSQL

my new suitcase ... #postgresql on tour :) ...

Day 30/100 PostgreSQL 🐘💻 Today, I worked with date calculations using AGE() and NOW(), modified my table structure with ALTER TABLE, and practised inserting and retrieving records. #100DaysOfCode #PostgreSQL #SQL #BackendDevelopment

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

Introducing #GoogleAlloyDB — a new and powerful, fully-managed, relational database service that combines the best of @Google with #PostgreSQL. Get started today ↓

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

Oracle to PostgreSQL is more than moving data: schema and PL/SQL conversion, app dependencies, testing, and cutover. Our practical guide to doing it on Azure: #PostgreSQL

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

Supabase's 30 Oct rollout: new tables in the public schema need explicit grants for Data API access. Existing grants stay; RLS still applies. Test a new table via the app's API role. Apr 28 source + screenshot: #Supabase #PostgreSQL

PostgreSQL 14 gets its last release on 12 Nov. RDS, Aurora, Cloud SQL and Azure each start their own clock after that. Find your 14s and pick an upgrade path: #PostgreSQL #AWS #DevOps

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 Database Administration (DBA) for Beginners - Full Course #postgresql #database #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

Unlocking the Cloud: Your First Postgres Database on Google VM #GoogleCloud #PostgreSQL #CloudDatabase #GoogleVM