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

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

The 10-year database architecture cycle: 2015: SQL is obsolete. Schemas are too rigid. Put everything in NoSQL JSON documents. 2018: Wait, we need to join users and orders. Let's write a 400-line nested loop in JavaScript to join them in RAM. 2021: Wait, if the server crashes halfway through the loop, we lose money. We need ACID transactions. 2026: Quietly puts everything back in PostgreSQL and never speaks of it again.

@Arikalabs Mongodb is better than postgres in every single possible way. Mongo has indexes and achemas and relationships of course. If you're still doing postgres it's sad.

@justinmchase @Arikalabs I've been using MongoDB since 2012 and I disagree with you. PostgreSQL is way better than MongoDB. For small projects, it's fine, but for big ones, it's not worth it. Postgre is a lot better, especially with some valkey usages ( Redis).

6 #PostgreSQL HA stack docs, now in 8 languages: Patroni · pgBackRest · PgBouncer · pgBadger · HAProxy · etcd Read at

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

Daniele is heading to @FastAPI Conf 2026 in Amsterdam on the 28th October 🚀It’s the first ever official FastAPI conference! Come say hi if you’re there 👋 #FastAPI #Python #PostgreSQL #Psycopg #FastAPIConf #OpenSource

Are you learning SQL or interested in becoming a DBA or Database Developer? Give me a shout and I'll be happy to help! Have a great day and keep supporting each other! #SQL #PostgreSQL #DBA #Databases #RDBMS #developers #coaching #support

Hey Rails + #PostgreSQL devs, what's one #PostgreSQL thing you wish you knew more about, that's not covered deeply (or at all) in the Rails Guides? Thanks!

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

Day 1: PostgreSQL ✅ Installed it. Created and managed databases. Practiced SQL. One day better. One step closer to becoming a strong backend developer. 🚀 #PostgreSQL #BackendDevelopment #90DaysOfCode

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

Scaling Postgres 440 is released! In this episode, we discuss how to reach 10 million queries per second efficiently, Postgres performance on GPUs, the next release of pgrust and not trusting ON DELETE CASCADE: #Postgres #PostgreSQL

Use ⁠RETURNING⁠ to avoid extra ⁠SELECT⁠ round-trips Don't run a second query just to fetch generated IDs, defaults, or updated values. Add ⁠RETURNING⁠ to ⁠INSERT⁠, ⁠UPDATE⁠, or ⁠DELETE⁠ to get the mutated rows back in a single database round-trip. #postgresql

Hello friends! PostgreSQL Anonymizer 3.3 fixes 12 vulnerabilities. If you mask data, please upgrade. #PostgreSQL #DataSecurity #letsconnect #TeamFollowBack

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

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

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

We're here. PG Down Under 2026 is underway. Come find our team and let's talk PostgreSQL. #PostgreSQL #PGDownUnder2026