Chris Winslett
@winsletts.bsky.social
Reposted by Chris Winslett
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.
i’ve been in this business for a bit and i’m pretty sure i’ve never seen a technology standardized as quickly as MCP
May 21, 2025 at 2:50 PM
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.
April 5, 2025 at 12:22 PM
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...
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...
Creating Histograms with Postgres | Crunchy Data Blog
Histograms are elegant tools for visualizing distribution of values. We walkthrough building a re-usable query for your histogram needs.
www.crunchydata.com
April 4, 2025 at 7:42 PM
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...
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.
April 3, 2025 at 12:38 PM
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.
April 3, 2025 at 12:03 PM
When he said “you have no cards”, he was talking to everyone.
Reposted by Chris Winslett
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. 😅
February 10, 2025 at 5:02 PM
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. 😅
Reposted by Chris Winslett
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?
"Dude!! That fuckin rules!!!"
"No that's fuckin spectacular"
I'm almost 40 now, is that too old to say it hits different?
January 22, 2025 at 8:08 PM
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?
"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
December 31, 2024 at 10:12 PM
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 do use SQL in my migrations though. I find the INSERT INTO ... SELECT pattern is ideal for migrations that require data changes.
December 26, 2024 at 7:10 PM
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 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.
December 18, 2024 at 9:59 PM
I’ve been messing with indexeddb in the browser — now looking for another gratuitous use.
Reposted by Chris Winslett
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!
This is the first time we beat the previous all-time record from 2015!
Ruby is so back!
December 17, 2024 at 1:13 AM
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!
This is the first time we beat the previous all-time record from 2015!
Ruby is so back!
Choose your data stack:
December 17, 2024 at 3:59 PM
Choose your data stack:
My buddy's brother made this. It's good: www.youtube.com/watch?v=VwEf...
Polaroid Christmas - Tim Berryman
YouTube video by HalfFruitRecords
www.youtube.com
December 14, 2024 at 2:15 PM
My buddy's brother made this. It's good: www.youtube.com/watch?v=VwEf...
Reposted by Chris Winslett
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!
TIL about the ROLLUP keyword that can go after GROUP BY which will create subtotals of numeric data!
December 12, 2024 at 9:58 PM
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!
TIL about the ROLLUP keyword that can go after GROUP BY which will create subtotals of numeric data!
Reposted by Chris Winslett
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.
I learned to be very careful when making changes that affect grouping.
Senior devs: Tell us about that time you took down prod
December 6, 2024 at 9:15 PM
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.
I learned to be very careful when making changes that affect grouping.
Reposted by Chris Winslett
Cheeky
Created a new Rails 8 app. Wanted #postgresql not null constraints in generated migrations, w/o editing each migration.
Turns out it's now possible. With a bang! 💥
rails generate scaffold Account name:string!
www.mintbit.com/blog/migrati...
@siaw23.bsky.social @winsletts.bsky.social
Turns out it's now possible. With a bang! 💥
rails generate scaffold Account name:string!
www.mintbit.com/blog/migrati...
@siaw23.bsky.social @winsletts.bsky.social
Migrations in Rails 8: Using the New Not Null Shortcut
In the latest version of Ruby on Rails (Rails 8), developers have been given a handy new shortcut for adding a NOT NULL constraint to database columns. This small but powerful enhancement simplifies t...
www.mintbit.com
November 21, 2024 at 2:58 AM
Cheeky
Want to feel like a kid? Go on a late night bike ride.
November 19, 2024 at 12:20 PM
Want to feel like a kid? Go on a late night bike ride.
Reposted by Chris Winslett
In person.
Where do you think the most educated discourse on tech trends is happening today?
November 18, 2024 at 6:05 PM
In person.
More useful than duct tape.
November 17, 2024 at 3:01 PM
More useful than duct tape.
Morning ride - first 40 degree ride of the fall
November 16, 2024 at 4:52 PM
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."
Wish there was a way to say "follow, but only as long as they are following me."
November 13, 2024 at 4:30 AM
I hate the follow-unfollow game.
Wish there was a way to say "follow, but only as long as they are following me."
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.
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.
November 13, 2024 at 3:41 AM
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.
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.
Reposted by Chris Winslett
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...
8 Steps in Writing Analytical SQL Queries | Crunchy Data Blog
Chris breaks down his approach to building out complex SQL step by step.
www.crunchydata.com
November 12, 2024 at 8:12 PM
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...
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...
8 Steps in Writing Analytical SQL Queries | Crunchy Data Blog
Chris breaks down his approach to building out complex SQL step by step.
www.crunchydata.com
November 8, 2024 at 7:56 PM
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...
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...