Reposted by Chris WinslettKelsey Hightower @kelseyhightower.com · 21/05/2025I 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. 417213
Chris Winslett @winsletts.bsky.social · 05/04/2025Watching Premier League, and I saw something I've never seen before: a sun-drenched pitched, and the shadows of players. 000
Chris Winslett @winsletts.bsky.social · 04/04/2025This 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...crunchydata.comCreating Histograms with Postgres | Crunchy Data BlogHistograms are elegant tools for visualizing distribution of values. We walkthrough building a re-usable query for your histogram needs. 010
Chris Winslett @winsletts.bsky.social · 03/04/2025For the experiments that can only be run once, it is worth being certain that what exists is worth being sacrificed for the intended outcome. 000
Chris Winslett @winsletts.bsky.social · 03/04/2025When he said “you have no cards”, he was talking to everyone. 010
Reposted by Chris WinslettAndrew Atkinson @andyatkinson.com · 10/02/2025Wrapped 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. 😅 4131
Reposted by Chris WinslettCody Norman @codynorman.com · 22/01/2025There'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? 2141
Chris Winslett @winsletts.bsky.social · 26/12/2024For 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. 200
Chris Winslett @winsletts.bsky.social · 18/12/2024I’ve been messing with indexeddb in the browser — now looking for another gratuitous use. 000
Reposted by Chris WinslettMarco Roth @marcoroth.dev · 17/12/20242024 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! 36622
Chris Winslett @winsletts.bsky.social · 14/12/2024My buddy's brother made this. It's good: www.youtube.com/watch?v=VwEf...youtube.comPolaroid Christmas - Tim BerrymanYouTube video by HalfFruitRecords 000
Reposted by Chris WinslettProtect Bridgeport Bicyclists @stevevance.net · 12/12/2024if 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! 2244
Reposted by Chris WinslettJoshua Wood @joshuawood.net · 06/12/2024When 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. 0144
Chris Winslett @winsletts.bsky.social · 19/11/2024Want to feel like a kid? Go on a late night bike ride. 000
Chris Winslett @winsletts.bsky.social · 16/11/2024Morning ride - first 40 degree ride of the fall 000
Chris Winslett @winsletts.bsky.social · 13/11/2024I hate the follow-unfollow game. Wish there was a way to say "follow, but only as long as they are following me." 000
Chris Winslett @winsletts.bsky.social · 13/11/2024About 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. 100
Reposted by Chris WinslettCrunchy Data @crunchydata.com · 12/11/2024Want 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...crunchydata.com8 Steps in Writing Analytical SQL Queries | Crunchy Data BlogChris breaks down his approach to building out complex SQL step by step. 041
Chris Winslett @winsletts.bsky.social · 08/11/2024I'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...crunchydata.com8 Steps in Writing Analytical SQL Queries | Crunchy Data BlogChris breaks down his approach to building out complex SQL step by step. 040
Chris Winslett @winsletts.bsky.social · 08/11/2024Hey Siri, play the Some Nights album. It’s that kind of morning … 000
Chris Winslett @winsletts.bsky.social · 01/11/2024Below 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. 130
Chris Winslett @winsletts.bsky.social · 31/10/2024“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. 000
Chris Winslett @winsletts.bsky.social · 31/10/2024For Halloween, I should make daiquiris for the adults. 010
Reposted by Chris WinslettAaron Patterson @tenderlove.dev · 30/10/2024Long day, but at least it's Friday! 😮💨 4272
Reposted by Chris WinslettJeremy Smith @jeremysmith.co · 30/10/2024Hello! 👋 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. 85912
Reposted by Chris WinslettKelsey Hightower @kelseyhightower.com · 30/10/2024All of this money spent on politics only confirms that everything is for sale, including our laws, and the law makers. 1017821
Chris Winslett @winsletts.bsky.social · 29/10/2024Dasha has stepped into the country music void left by Taylor Swift 000
Chris Winslett @winsletts.bsky.social · 27/10/2024For the experiments that can only be run once, it is worth being certain that what exists is worth being sacrificed for the intended outcome. 000
Chris Winslett @winsletts.bsky.social · 25/10/2024I’ve never had a long conversation that ended poorly. I’ve had many short conversations that ended poorly. 010
Chris Winslett @winsletts.bsky.social · 25/10/2024When I run a long-running command line action locally, I append ';say "done."' Then, I get a verbal indication that it has finished. 110
Chris Winslett @winsletts.bsky.social · 24/10/2024This is my kind of humor at the coworking space: 000
Chris Winslett @winsletts.bsky.social · 24/10/2024AI that sees the error thrown by your code, sees the code, and writes a test that triggers the error. 000
Chris Winslett @winsletts.bsky.social · 23/10/2024In 2024, there are people still live editing code on production servers. And, they justify that as a feature of their current deployment processes. 010
Reposted by Chris WinslettCraig @craigkerstiens.com · 21/10/2024Giving 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 23917
Chris Winslett @winsletts.bsky.social · 22/09/2023First, 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. 010
Chris Winslett @winsletts.bsky.social · 19/09/2023For better performance with Postgres + JSON, before throwing your JSON at it, remove the white-space characters. It can significantly reduce the JSON parsing time. 000
