@ryanbooz.bsky.social
@PostgreSQL and DevOps Advocate @Redgate.
If you:
• Teach PostgreSQL
• Build database tooling
• Work in observability
• Want to demo VACUUM, bloat, or query plans
This should feel a lot more useful than a static dump.
Would love feedback from the Postgres community.
www.softwareandbooz.com/introducing-...
It ships ready to run with:
🔹 pg_cron
🔹 pg_stat_statements
🔹 auto_explain
🔹 PostGIS
🔹 pg_trgm
Backfilled historical data + ongoing workload included.
One command and you’re up.
Most sample databases are static.
Bluebox starts with realistic data (video rental schema + recognizable movies) and then keeps generating transactions over time.
That means it actually changes — like a real system would.
Introducing Bluebox Docker — a living PostgreSQL sample database that continuously generates real activity. 🐘
I wanted a sample DB that actually behaves like a real system — so I built one.
Details:
www.softwareandbooz.com/introducing-...
... out loud and get quick feedback on "my data" is more fun and productive than I thought.
Yes, I've still had to correct obvious errors multiple times, but I'm a much faster editor when I have something to start with. I don't (yet) feel replaceable, but definitely more creative right now.
Shoot! I'm vibe coding (SQL'ing) with Claude on my sample Bluebox database ((github.com/ryanbooz/blu...) and... it's pretty amazing... and I'm having a great time.
TBF, I was never totally against using AI/Claude to begin with, time just hasn't been on my side recently. But being able to think...
Chilly morning + hot coffee + new #Techbash mug = 💯
Thanks to everyone I got to meet and connect with the last few days at @Techbash.bksy.cosial. Sorry to miss the last day, but I'm sure it's going to be 🔥!!
I can't believe it's been a year ago already that @gfritchey.bsky.social & I taught our Introduction to Postgres precon at PASS Data Summit & Bruce Momjian was able to join us for a bit.
Not surprisingly, Bruce engaged with everyone afterwards, carrying on the conversation for another 30 minutes!
Hey #Techbash2025!
If you're planning to come to my @techbash.bsky.social precon to learn about PostgreSQL, here's a quick rundown of the Postgres install and sample database I'll be using if you want to try and follow along.
Install instructions: github.com/ryanbooz/blu...
youtu.be/mxFQiIFtNM0
I was just working to make a query in a sample database more efficient when I realized something was off in the EXPLAIN plan.
Apparently, somewhere along the way, I removed some GiST indexes on geography columns and... they're like important or something?
🤦🏻♂️😂
Session card for Ryan Booz's TechBash 2025 workshop, PostgreSQL Introduction for the SQL Server Developer or DBA, happening November 4th at Kalahari Resorts in the Poconos.
Are you a #sqlserver DBA or developer? Join our full-day #postgresql intro workshop with @ryanbooz.bsky.social at #techbash 2025!
Every 4-day registration includes a workshop. Learn more at techbash.com
#database #techevent #developers #data #kalahari #poconos #devconf #nepa #dba #familyfun
Headed to #Stirtrek2025. Always fun to get diverted because of weather. It's been quite a few days with weather related things!
01.05.2025 20:03 — 👍 2 🔁 0 💬 0 📌 0
Big shoutout to Hettie! She's such a force for good in the Postgres community and a works tirelessly to serve her dedicated user group in Chicago. Please consider supporting this new initiative and attending PGDay Chicago on April 25!
02.04.2025 15:15 — 👍 2 🔁 0 💬 0 📌 0
It's one thing to post slides after a talk, but this is next level! Detailed content between each slide from www.linkedin.com/in/karenhjex/ recent talk at DoK Day Europe: "Postgres on Kubernetes for the Reluctant DBA"
02.04.2025 13:03 — 👍 1 🔁 1 💬 0 📌 0
Introducing pgNow: A free, point-in-time diagnostic tool for #PostgreSQL created by @Redgate that helps you identify key performance metrics and configuration optimizations in your running Postgres instance.
10.03.2025 14:02 — 👍 3 🔁 0 💬 0 📌 0
10.03.2025 13:46 — 👍 2 🔁 0 💬 0 📌 0
The bees were loving the nice, warm, early spring day.
They were not, however, happy that I was trying to include them into my promo videos for the book. 😂
(They aren't normally like this, btw. I often spend a lunch break observing them closely. They're just protective in early spring)
🤞😀
13.02.2025 17:21 — 👍 1 🔁 0 💬 0 📌 0Um... thank you? 😂
Regardless, I hope the book without the multi-legged train proves to be helpful to you! 🐘
Share recipe! I have never had/seen GF cinnamon buns like that!
10.02.2025 21:01 — 👍 0 🔁 0 💬 1 📌 0
This was a big week for me & @gfritchey.bsky.social
with the release of our book about #PostgreSQL! We're both thrilled & excited for this milestone!
Here's a quick introduction from my perspective on why we wrote the book & who it's for.
#JustUsePostgres
www.softwareandbooz.com/on-writing-a...
It is not safe to have an open bag of pretzels and Herlocher's dipping mustard around me. Fortunately, the pretzel bag was only about 1/4 full.
04.02.2025 20:42 — 👍 1 🔁 0 💬 0 📌 0
I did not expect to see these little ladies out and about yesterday with 4.5°C/42°F temps. But, with the first clear day in a while and 10x warmer temperatures than a week ago, I'm sure it felt like a heat wave to them too!
Almost makes me believe spring will come someday! 🐝🌻
If you have attended the #PASSDataSummit, fill out the survey on topics for 2025. Redgate will donate to a charity for every response.
reg.passdatacommunitysummit.com/surveys/redg...
Order your digital copy for delivery next Monday, February 3!! Paperback copy will be available for purchase starting Monday as well.
https://buff.ly/3QdWj9H
🎉🎉 #1 New Release on Amazon!!! 🎉🎉
Well this certainly is exciting... and unexpected! Introduction to PostgreSQL for the data professional, the book @gfritchey.bsky.social and I wrote, is the #1 new release in the Servers category on Amazon! And it's not even released yet!
Oh, I know it looks so sunny and nice outside at #CodeMash...
But it was a balmy 4°f/-15.5°c when I woke up this morning. And, with the wind chill, it was certainly below 0°f.
🥶🥶🥶
As always, feel free to reach out with questions. If I can help, great! If not, I probably know someone that can (or at least where to go ask next).
#JustUsePostgres
I had a great crowd of 💯 #CodeMash attendees join me this morning to learn more about getting started with #PostgreSQL. Every time I present, the questions & interactions keep me energized, & *at least* one question stumps me & searching for answers. It keeps this amazing database fresh & new.
15.01.2025 19:51 — 👍 5 🔁 1 💬 1 📌 0
Hey #CodeMash, who's ready to learn about #PostgreSQL tomorrow morning? There's also a chance to get a pre-release copy of the new book by @gfritchy and me. 😀
8am in Nile...
See you there!
