🚀 PGZen is live on the Mac App Store!
A native PostgreSQL client for macOS.
🎁 Giving away 3 free copies!
To enter:
Follow @PgZenApp
Reply with what you're building with PostgreSQL
🏆 3 random winners on Nov 21!
🔗 pgzen.dev/
Use INSERT ... ON CONFLICT for safe upserts.
Avoid SELECT followed by INSERT or UPDATE in application code—it suffers from race conditions under concurrent writes. Use INSERT ... ON CONFLICT with a UNIQUE constraint or index to handle conflicts atomically.
#PostgreSQL #SQL
4
Use IS DISTINCT FROM for null-safe comparisons
In SQL, NULL = NULL and NULL != 'active' both evaluate to UNKNOWN (falsy), which silently drops NULL rows from WHERE clauses.
IS DISTINCT FROM treats NULL as a comparable value, making it much cleaner than chaining OR col IS NULL.
14
PgZen retweeted
MySQL 🤝 Threads
Postgres 🤝 Processes
youtu.be/gJ6b3kIP3KY
PgZen retweeted
Remember, remember, the Go Developer Survey closes 3rd of November!
The 2026 Go Developer Survey is open! Help set Go’s priorities for next year by telling us how you use Go and where it could be better.
⏱️ 10–20 minutes
📅 Open through November 3
blink.qualtrics.com/jfe/form…
#golang
PgZen retweeted
I can’t believe they invented irl excalidraw.
What is this technology.
How we deploy multi-trillion parameter models at scale
Today, let's break down the math for how @cerebras:
1. Fits the full model into on-chip memory
2. Maps the model across multiple chips
3. Handles a high # of concurrent requests
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
12
PgZen retweeted
Which Laravel? 😏
The agents finished porting Campfire to Laravel and Django too. I'm sure there are optimizations that could be found there too, but the whole point is to get a sense of how frontier agents do with different environments out the box. github.com/basecamp/once-cam…
PgZen retweeted
Help agents write relevant Golang code with our new set of AI skills – Modern Go Guidelines.
They cover the most useful features from Go 1.0 to 1.27, including everything in the `modernize` analyzer, and instruct your agents to write modern idioms 👇
github.com/JetBrains/go-mode…
PgZen retweeted
This article by @func25 is one of the best Go articles I’ve read.
I had no idea what a goroutine was but learnt it due to this article
I also learnt more about concurrency in general, and how to effectively wait for a goroutine to finish
Would definitely recommend
func25.dev/posts/go-goroutin…
#Golang #Learning
PgZen retweeted
Cursor is now part of @SpaceX.
Today, we have officially closed our acquisition. We will join the @spacexai team to help make Grok the world's most useful AI and improve Grok Build, Grok Bot, Grok API, Cursor, and more.
SpaceX has built some of the most inspiring and impressive technology in the world, and we’re grateful for the opportunity to become part of such a special company. Onwards.
To be honest, I think they missed the strongest argument in favor of Go: it compiles **fast**.
Even in the LLM age it's extremely important that LLMs can iterate on code quickly and a lightning fast compiler is the biggest factor in that.
developers.googleblog.com/wh…























