Piotr Olaszewski

@piotrooo.bsky.social

👷🏻‍♂️ Software Architect at Thulium ☕️ Java 🤷‍♂️ All opinions are mine and only mine

PostgreSQL's serial isn't a type. It's a sequence + an integer + a nextval() default, glued together. Which is why GRANT INSERT on the table isn't enough — the role also needs USAGE on the sequence. generated always as identity doesn't have that problem. All ten below 👇

A dark diff-style cheatsheet titled "Don't do This in psql", listing ten PostgreSQL anti-patterns — char(n), varchar(n), money, serial, timestamp, BETWEEN, NOT IN, CamelCase identifiers, table inheritance and trust authentication — each with the wrong SQL in red, the recommended form in green, and a one-line explanation.

Big congrats to my friend! 🎉 He just launched a family #cardgame called The Elements ♠️🔥🌊 I was lucky to be a tester, and now the crowdfunding is LIVE on Gamefound 🚀 Check it out, like it & support if you vibe with it ❤️ 👉 gamefound.com/en/projects/...

The Elements by Elementorum Studio - Gamefound

Simple 2–5 player card game, easy to learn, dynamic elemental interactions, accessible price, and future expansion potential.

gamefound.com

First the first time in a while, I’m convinced about #ai power 💪 I tried to figure out the right way to write a jq selector for a given JSON. After preparing a small example and writing a prompt with the desired result, I have an working jq command. Thanks, Claude 🤖 Supporting, not replacing 👍