I'm looking forward to #PSQLPhriday posts tomorrow.

#PostgreSQL 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?

What's one #PostgreSQL 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.

Anybody know what this is? 😂

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?

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. 😵‍💫

First time in 🇬🇧 (LHR), but I'm only passing through on my way to #FOSDEM2023 .

I'll be back soon enough to visit Redgate HQ. 😉

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…

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?!?! !

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

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/…

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. 😂

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)

For some reason this morning I realized that I get to think and talk about #PostgreSQL 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! 💪

There are plenty out there, but which is your favorite learning resource for databases?

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

This month's topic: Is your data relational?

Post your submission on Friday February 3 😃

#postgres #postgres ql

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

❄️❄️❄️

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.

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.