I love Bluey. My kids love Bluey. I even ended up with Bluey Christmas inflatable yard ornaments this year (something I vowed I'd never do). It's a phenomenal show with witty characters and more one-liners that my kids can spout off than I can count on multiple hands and feet.
But wow, kudos to the mom on my flight from ORD to SFO today that watched Bluey for 4.5 hours with her ~15/month old to help pass the time. Not sure I could have done that. You rock.
Now... where is my feather wand?
Postgres roles and privileges are tricky.
Itโs actually one of my favorite areas to dig into โ mostly because I got stung by it early in my return to Postgres years ago.
And yetโฆ I still messed it up in my new demo database, Bluebox Docker, that I released this past week.
I spotted the issue, made what I thought was a quick 30-second fix, pushed it between meetingsโฆ and didnโt test it.
The next morning I woke up to my first GitHub issue:
The container wouldnโt start. ๐คฆ๐ปโโ๏ธ
The fix really was simple. I knew better.
But I thought it was worth walking through what happened โ both to own the mistake and to hopefully help others understand Postgres security just a little more clearly.
Video Recap: https://t.co/77aDxYrvhs
Bluebox Docker project: https://t.co/BUyOj2iIz2
Introducing Bluebox Docker โ a living PostgreSQL sample database that continuously generates realistic activity. ๐
I wanted a sample database that actually behaves like a real system โ something you can use to explore VACUUM, bloat, query plans, and monitoring in a realistic way.
So I built one.
One command and youโre up & running with:
๐น Backfilled historical data + ongoing transactions
๐น pg_cron driving real workload
๐น pg_stat_statements, auto_explain, PostGIS, pg_trgm
๐น Support for multiple Postgres versions
If you teach Postgres, build tooling, or demo observability, this should feel a lot closer to reality than a static dump.
Details:
https://t.co/VYgblewgpl
Shoot! I'm vibe coding (SQL'ing) with Claude on my sample Bluebox database (https://t.co/sqFRMXOzQ1) 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 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 I do feel more creative having this conversation.
Wait till you see what I'm cooking up now! Schema version 0.5 coming this week. ๐ ๐
Has @Betterment been hacked @BettermentHelp?
You'll triple my crypto sent to a random address for three hours only... with no other context?
Instead it looks like a recently uncovered threat actor, Haby, is at it again?
Yay! ๐๐๐
It's the only hive of mine that's still alive this year, so hoping we can make it until March... and then we'll try to start splitting the hives.
Last two flights of the year... and first ever #PointsRun to retain United status. An out-and-back from MDT > IAD > MDT. First world problems... I know. (looking at you @GFritchey@way0utwest)
Not sure what travel looks like in the coming year, but still hoping to be at a number of #Postgres events on both sides of the pond. Coming from a small regional airport, status is a game changer. So... Here I am.
Side note, I've never flown so light and care free - just a coffee and an iPad!
Anyone at #reinvent that has a 5k race bib for tomorrow morning but probably won't use it and wants to give it to someone who does? Apparently there are only 200 remaining that you have to show up at 4am to try and claim. ๐คฆโโ๏ธ
#reinvent2025
Chilly morning + hot coffee + new #Techbash mug = ๐ฏ
Thanks to everyone I got to meet and connect with the last few days at @Techbash. 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 & I taught our Introduction to Postgres precon at @passdatasummit & 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 there #Techbash2025!
If you're planning to come to my @techbash precon 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: https://t.co/Ypo9sOwN76
https://t.co/pOjoE37QL9
Years ago someone pointed out how often people say โactuallyโ when they mean โfiguratively.โ
Editing a transcript today from a recent video, I realized I actually use โactuallyโ correctly โ I just use it way too often.
Itโs actually pretty annoying how much I actually say โactually.โ ๐คฆ๐ปโโ๏ธ
#NoteToSelf