Ryan Booz(@ryanbooz) 's Twitter Profileg
Ryan Booz

@ryanbooz

Sinner saved by Grace, Husband to @laurabooz, Father of 6,
#PostgreSQL πŸ₯‘ @Redgate. #SQL #family, 🎡 🐝 ⚾️. Opinions my own.

ID:17131719

linkhttp://www.softwareandbooz.com calendar_today03-11-2008 14:57:17

3,2K Tweets

620 Followers

288 Following

Ryan Booz(@ryanbooz) 's Twitter Profile Photo

I'm looking forward to posts tomorrow.

has expanded support for non-relational data over the last number of years. Indexing JSONB & ARRAY types, PostGIS, or sometimes just using the functions internally to move data around.

What's your story?

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

What's one function that changed how you work w/data & made your job easier once you knew it existed & how it worked?

I'll go first.

regexp_matches(), especially used w/ a CROSS LATERAL JOIN

For powerful ELT, the entire regexp family can't be beat.

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

Sitting in terminal 2 at LHR, and I just realized that I haven't heard one gate announcement in the last hour over the loudspeaker. Is that just a US thing?

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

Shoot, just had a coffee waiting at the airport but my body just realized it's technically only 4:30am and confusion has set in. πŸ˜΅β€πŸ’«

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

First time in πŸ‡¬πŸ‡§ (LHR), but I'm only passing through on my way to .

I'll be back soon enough to visit Redgate HQ. πŸ˜‰

account_circle
pgDay Paris(@pgDayParis) 's Twitter Profile Photo

We’ve just published the agenda for pgDay Paris 2023 & we are so excited about it! Check out the great talks and training sessions & register now for March 22 & 23. postgresql.eu/events/pgdaypa…

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

Um... I've generally been a keyboard shortcut maniac for most of my computer life (at least since learning to touch type in 7th grade).

I accidentally just held the control key while hitting backspace and... IT DELETED ONE WORD AT A TIME!!!

How did I not know this?!?! !

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

No guarantee with ~6 weeks to go until weather is more consistent, but seeing the 🐝 active never gets old.

No guarantee with ~6 weeks to go until weather is more consistent, but seeing the 🐝 active never gets old.
account_circle
Claire Giordano ✨ @clairegiordano@hachyderm.io(@clairegiordano) 's Twitter Profile Photo

Carpe diem! The CFP for Citus Con: An Event for Postgres | CFP is open!: An Event for Postgres 2023 will close on Sun Feb 5th

Will you submit? We'd love to see your talk proposals about:
- PostgreSQL
- Citus database extension Citus Data
- Azure Database for PostgreSQL
- Azure Cosmos DB for PostgreSQL
citusdata.com/cituscon/2023/…

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

Just me, over here, banging out some regex rules to match cross database syntax checks.

I'm surprised how much I honestly love figuring out regex... until I can't figure out regex. πŸ˜‚

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

As the ❄️ falls outside & @mlb chatter picks up ahead of pitchers and catchers reporting in a few weeks, it hit me how much I miss watching baseball.

I think we're at T-20 days now (Feb. 15)

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

For some reason this morning I realized that I get to think and talk about every day as part of my job! 🐘

I still have a billion things to learn, but I really do love how much my 🧠 gets πŸ”₯ up each day by the challenge of it.

Alright... back at it! πŸ’ͺ

account_circle
RustProof Labs 🐘(@RustProofLabs) 's Twitter Profile Photo

I'm thrilled to be this month's host!

This month's topic: Is your data relational?

Post your submission on Friday February 3 πŸ˜ƒ

ql

blog.rustprooflabs.com/2023/01/pgsqlp…

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

Electrical tape.

You know you have at least 5 rolls somewhere in the house but can never find any when you need it. 🀦

Finally found some in the utility shed.

account_circle
Ryan Booz(@ryanbooz) 's Twitter Profile Photo

I recently setup a server for the first time. No idea why it's taken me this long (laziness I guess) and after 1 week: 48% of all queries?!?!!

The internet is so broken.

I recently setup a #PiHole server for the first time. No idea why it's taken me this long (laziness I guess) and after 1 week: 48% of all queries?!?!! The internet is so broken.
account_circle