I would argue Docker holds the crown for the fastest technology ever standardized. In less than two years we saw Docker move beyond the hype, into production, and influence the roadmap of almost every tech company.

Watching Premier League, and I saw something I've never seen before: a sun-drenched pitched, and the shadows of players.

This is a banger. It manages to include full outer joins, generate_series, multiple CTEs referencing each other, type casting, string concatenation, and width_bucket -- probably a few more too. www.crunchydata.com/blog/histogr...

For the experiments that can only be run once, it is worth being certain that what exists is worth being sacrificed for the intended outcome.

When he said “you have no cards”, he was talking to everyone.

Wrapped up in intensive PostgreSQL query optimization effort. Tactics: PK/FK data type change, de-normalization, CTE restructure. Results: 77% faster target COUNT(*) query: 75ms vs. 330ms. 96% less IO (fewer buffers). Now the (2nd) hard part: getting these changes into the prod DB and app code. 😅

There's a lot of reasons why I live having tattoo shops and artists as customers. One of my favorites has to be their feedback when they like something. "Dude!! That fuckin rules!!!" "No that's fuckin spectacular" I'm almost 40 now, is that too old to say it hits different?

Last one in 2024

For Rails migrations, I avoid using models -- often, in the future that model is changed, renamed, or removed. I do use SQL in my migrations though. I find the INSERT INTO ... SELECT pattern is ideal for migrations that require data changes.

I’ve been messing with indexeddb in the browser — now looking for another gratuitous use.

2024 is the year with the most Ruby talks in a single year, ever! This is the first time we beat the previous all-time record from 2015! Ruby is so back!

Choose your data stack:

My buddy's brother made this. It's good: www.youtube.com/watch?v=VwEf...

if you use PostgreSQL a lot like I do, @crunchydata.com is indispensable. TIL about the ROLLUP keyword that can go after GROUP BY which will create subtotals of numeric data!

When we first launched HB I deployed a change that broke notification grouping, so it sent a flood of notifications to all of our users. 🤦 I learned to be very careful when making changes that affect grouping.

Cheeky

Want to feel like a kid? Go on a late night bike ride.

In person.

More useful than duct tape.

Morning ride - first 40 degree ride of the fall

I hate the follow-unfollow game. Wish there was a way to say "follow, but only as long as they are following me."

About a month ago, reached out to a friend who I heard was struggling with depression. He finally responded over the weekend, and said he’d enjoy hanging out. We went on a 2 hour hike this morning after he dropped off the kids.

Want to write better analytical queries @winsletts.bsky.social has you covered with a breakdown of 8 great tips and walkthroughs for writing better SQL - www.crunchydata.com/blog/8-steps...

I've written SQL queries for over 20 years. I've learned on a need-to-know basis -- first as a developer, then for business-y data. It's not so much "writing a query" as it is "building a "query." In this post, I lay out the fastest way to get to correct. www.crunchydata.com/blog/8-steps...

Hey Siri, play the Some Nights album. It’s that kind of morning …

Below is the class-pattern I use in Ruby on Rails to work with materialized views. Materialized views assemble the data into a query table. I use this for performance cache.

“If you were chili for hot dogs where would you be?” - me asking another random guy walking around the grocery store Dude totally helped me too.

For Halloween, I should make daiquiris for the adults.

Long day, but at least it's Friday! 😮‍💨

Hello! 👋 I'm new here, but so far I'm liking the vibes. I'm a product-focused Rails dev, working with cool clients, podcasting at indierails.com, and building liminal.forum. I love talking (and reading) about Ruby, Rails, design, the web, digital products, indie business, consulting, etc.

All of this money spent on politics only confirms that everything is for sale, including our laws, and the law makers.

Dasha has stepped into the country music void left by Taylor Swift

“At all times” got me

For the experiments that can only be run once, it is worth being certain that what exists is worth being sacrificed for the intended outcome.

I’ve never had a long conversation that ended poorly. I’ve had many short conversations that ended poorly.

When I run a long-running command line action locally, I append ';say "done."' Then, I get a verbal indication that it has finished.

This is my kind of humor at the coworking space:

AI that sees the error thrown by your code, sees the code, and writes a test that triggers the error.

FDW for the E. DBT for the TL.

In 2024, there are people still live editing code on production servers. And, they justify that as a feature of their current deployment processes.

Giving this starter pack thing a try, if you want a little Postgres in your feed (and who doesn't) here's some folks work a follow - go.bsky.app/Acp7hmk

First, if this truncation doesn’t get more subscribers, I don’t know what will. Second “potentially dangerous situation?” This sounds like a full-on dangerous situation.

saw a murder in broad daylight

For better performance with Postgres + JSON, before throwing your JSON at it, remove the white-space characters. It can significantly reduce the JSON parsing time.