Show newer

Database management 101: The difference between zero and null.

🎉 Join (@karenhjex@mastodon) Karen Jex at #PosetteConf Livestream 3️⃣ to learn about skills, tools and techniques for managing #Postgres at scale. ⚖️ 🐘

posetteconf.com

#postgresql #databases #OpenSource

This week on Tue/Wed/Thu Jun 10-12 is @posetteconf, a free & virtual developer conference with 4 livestreams, 42 talks about Postgres, & a live hallway track on Discord 📺

If you use #PostgreSQL 🐘 there's probably something here for you: posetteconf.com/2025/schedule/

🧵(1) A quick story on why #PosetteConf matters (and why virtual conferences matter) 👇

This 4th year of the virtual @posetteconf will have:

💥 45 a-ma-zing speakers from 21 companies
📺 4 livestreams
✅ 42 #PostgreSQL talks
💬 Live virtual hallway track on Discord

The 2 keynotes are by brilliant speakers Bruce Momjian & Charles Feddersen

+ 18 talks about the Postgres core
+ 12 Postgres ecosystem talks
+ 10 talks about Azure Database for PostgreSQL

Hope to see you—or your Postgres database friends—at #PosetteConf

/End 🧵(4)

👉 posetteconf.com/2025/schedule/

Show thread

@tomasv interesting post, did you consider running pgbench on another machine from the postgresql server, might be interesting as to how that shifted things, if you're thinking there is some benefit of the client and server processes being on the same core / core cluster.

⏰ The countdown begins! 5️⃣ days until the 2025 version of POSETTE: An Event for Postgres begins. Have you saved the date? 🗓️

posetteconf.com/2025/

#PosetteConf #PostgreSQL #Postgres

@veronica a partial unique index might do what you want, or get you close.

But it might be worth asking is the data model sensible.

@tomasv yeh, that was more my thought, it's a very simple protocol and gives lots of scope for injecting any specifics you wanted.

@tomasv if you used NBD you could sigkill the server or maybe modify it to simulate different types of the disk doing odd things.

@xahteiwi back in the day, I loved Trac for it's simplicity and ability to write reports in plain SQL. As someone who routinely has Jira imposed on me, I can honestly say I hate it with a passion.

For most of the past decade, the Chromium animation team in Google's Waterloo office has gotten an earful from me about about how the we *had* to get to a point where scroll-based animations were not only possible, but reliably offloaded to the compositor.

And they did it, despite *constant* stop-energy from Apple (who still can't do <body> scrolling right 🙄). The results speak for themselves:

codepen.io/spark/448

codepen.io/HejChristian/pres/V

What Sam Altman Told OpenAI About the Secret Device He’s Making With Jony Ive

“The product will be capable of being fully aware of a user’s surroundings and life, will be unobtrusive, able to rest in one’s pocket or on one’s desk, and will be a third core device a person would put on a desk after a MacBook Pro and an iPhone.”

OpenAI looking at Microsoft Recall and thinking “consumers love the idea! Let’s make something that records everything you do!” is pretty funny.

wsj.com/tech/ai/what-sam-altma

Incredible (but predictable) : #Microsoft has blocked the International Criminal Court's access (#ICC) to its services on the orders of the #Trump mafia.

Read that carefully : an international organisation that has no presence in the United States and no US legal rights has had its work tools blocked simply because it disagrees with the Trump administration. 🚩

Get the hell out of it right now.

apnews.com/article/icc-trump-s

#Facism #Autocraty #Criminal #BigTech

Now presenting at #PGConfdev, Karen Jex of Crunchy Data is giving an update about the #PostgreSQL Europe Diversity Task Force, to help people understand what’s happening (and what you can do to help)

🌐 Join from Anywhere! POSETTE: An Event for Postgres 2025 is timezone-friendly, easy to access, and totally free. #PosetteConf 🆓 4 livestreams. 42 unique talks. 45 amazing speakers.

Join the fun: posetteconf.com/2025/

#postgres #databases #OpenSource #community

Show older
Mastodon

Time for a cuppa... Earl Grey please!