Rubyists! I am reviving Ruby Inside after 12 years of hiatus. I have too many Ruby things I want to blog about :-) So far I've got the archive up and running at rubyinside.com/archives/ - it's a bit of a Ruby time capsule..

I wrote a new book that has been in the works for years. It is called Root Cause, and it is for those who enjoy the art of backend engineering. amzn.to/4cKfZhe

Postgres 18: Skip Scan - Breaking Free from the Left-Most Index Limitation www.pgedge.com/blog/postgre...

Did you know High Performance PostgreSQL for Rails has a forum with 30 threads? devtalk.com/books/high-p... Did you know the Rideshare, the Rails app for the book, continues to be updated with newer versions of Postgres? Learn more 👉 andyatkinson.com/pgrailsbook Thanks for taking a look!

The best writing habit experienced developers can build is every time you spend an expectedly long time figuring something out, don't move on! Write about it. If it was interesting & confusing to you, others will find it interesting & valuable too.

Boost your PostgreSQL skills with Andrew Atkinson at PG DATA 2026! Reserve your spot: forms.gle/bijKRFF8bc4n... #PGData #PGData2026 #PostgreSQL 🐘 #SQLPerformance #ORM #DatabaseScaling #DBATraining #TechLearning #OpenSource #HandsOnTraining #DevCommunity

Updated gem versions based on Dependabot security issues. I also ran Rideshare with Postgres 18 and app tests passed, looking good. Originally Rideshare used Postgres 16. I'd planned to keep it updated for at least several years along with the book (published in 2024). github.com/andyatkinson...

What could the mysterious missing feature #10 be in the Aurora Postgres 18.1 Preview?! 😂 docs.aws.amazon.com/AmazonRDS/la...

TIL "order by" in Postgres can filter rows w/ an expression, e.g. create table foo (c text); insert into foo (c) values ('bar'), ('baz'), (null); select * from foo order by c = 'baz' desc nulls last; c ----- baz bar (3 rows) Weird to me, but valid! www.postgresql.org/docs/current...

🎓 Trainings are included with your PG DATA 2026 ticket — at no extra cost! Explore the available sessions: 2026.pg-data.org/sessions/ Reserve your spot: forms.gle/bijKRFF8bc4n... #PGData #PGData2026 #PostgreSQL 🐘

Five PostgreSQL Anti-Patterns By Shey Sewani shey.ca/2025/09/12/f...

You can play the original SkiFree game from the Windows 3.1 days in your browser - this is not a drill! retrotick.com

I'm excited to have met @billkarwin.geek.org virtually and to get started reading "More SQL Antipatterns," a modernized version of the 2010 classic “SQL Antipatterns.” The new book uses Postgres, Python, and is in Beta now. Take a look! pragprog.com/titles/bksap...

High Performance PostgreSQL for Rails picked up a new 5-star review and is back to #1 in the Ruby Programming category on Amazon. Thank you readers! 💙 @pragprog.com a.co/d/0e61DsQX

Tomorrow's Postgres Meetup for All is about scaling Postgres ... but without boiling the ocean. Should be a great discussion. Join us! www.meetup.com/postgres-mee...

Re: commenting on indexes, I like the ideas to track creation time and last reindex timestamps as comments. Could use comma separated key:value for a format. Using a shared script on a team, it could perform the operation then annotate it. @samokhvalov.bsky.social @michristofides.com

Re: query comments in Rails @samokhvalov.bsky.social @michristofides.com besides Marginalia, there’s also Query Logs built into Rails, which is also based on the SQLCommenter standard. Also, I always recommend enabling source code line level info. andyatkinson.com/source-code-...

Can confirm 🥶

New in Beta - All new with advanced queries like relational division, efficient pagination, and pivoting. Explore optimization tradeoffs, including denormalization, JSON, and choosing SQL versus NoSQL. Scaling out with sharded databases. pragprog.com/titles/...

📚✨ ICYMI — Book Club @ WNB.rb! Just getting started & you’re welcome to jump in 💜 High Performance PostgreSQL for Rails 🚀 🗓 Thu • 12:30 PM ET 💬 wnb-rb.dev #WNBrb #RubyOnRails #RubyCommunity #onlinemeetup

📢 PG DATA 2026 CFP — Deadline Extended! Holiday travel slowed things down, so we’ve extended the Call for Proposals. 🗓️ New deadline: Jan 7, 2026 👉 Submit: sessionize.com/pg-data-2026 🌐 Learn more: 2026.pg-data.org #PGDATA2026 #PostgreSQL#CallForProposals #PostgresCommunity #DataConference

**Reminder** PG DATA 2026 CFP is open! We’re looking for PostgreSQL talks Submit your proposal! sessionize.com/pg-data-2026 #PGData2026 #PostgreSQL #PostgresCommunity #CallForPapers #CFP #TechSpeakers #DataConference #MidwestTech #ChicagoTec

Thrilled to see my contributions to the custom DB sharding design help power the backend of the #1 ranked Apple App Store app over the weekend!

🎄🎁 Ruby 4.0.0 Released www.ruby-lang.org/en/news/2025...

If you update or delete often rows watching bloat tables and indexes is important. This article is a great explanation and I also recommend using the gem rails-pg-extras to watch bloat ratios: github.com/pawurb/rails...

☃️ This holiday season, give the gift of Postgres! 🐘🎁 ​Grab a copy of "PostgreSQL Mistakes and How to Avoid Them" to learn from the pros and optimize your database. 🏷️ ​Save 35% with code: au35ang ​Get it here: hubs.la/Q03Nc0hv0 ​#TechBooks #Books #PostgreSQL #Postgres #OpenSource #Database

Nice post! Via Creston Jamison / Scaling Postgres podcast VACUUM Is a Lie (About Your Indexes) boringsql.com/posts/vacuum...

🐘 Oh, that's nice: Postgres 19 is going to ship read-your-writes for standbys when using asynchronous replication, via a new command WAIT FOR LSN (similar to WAIT_FOR_EXECUTED_GTID_SET in MySQL). Very cool! www.postgresql.org/docs/devel/w...

We're in the final phase of prep for Postgres infrastructure: online maintenance work, ahead of expected big load next week. We're rebuilding all indexes for tables (concurrently) or individually for jumbo ones. Recent example reduced total index size (4) for a table by ~40%! (~50GB in this case).

Optimizing the index (micro optimization) supporting a query that runs at about 3100 QPS, expected to scale up further in the peak period. Added a custom covering index. Now it's an index only scan, no heap fetches, 4 shared buffer hits in total, 16 microseconds execution time. 👌

Scrolling HN this morning and saw my UUID v4 blog post was submitted and made it to the front page. news.ycombinator.com/item?id=4627...

Prod example today of game-changing alignment of query and targeted Postgres index. Added multicolumn index on an expression. 2.5m rows. Query duration avg 1200 ms. Slowest sample @pganalyze.bsky.social 2300 ms (2.3 seconds). With index exec now just 3 shared buffer hits, 1.2 ms. 99.99% faster!

A quick reminder that the PG DATA 2026 Call for Proposals is still open! Submit here: sessionize.com/pg-data-2026 #PGData2026 #PostgreSQL #PostgresCommunity #CallForPapers #CFP #TechSpeakers #DataConference #MidwestTech #ChicagoTech

Meet the PG Data 2026 CFP Committee! They’re shaping a program that highlights innovation, real-world Postgres expertise, and diverse voices. Inspiring talks that elevate the Midwest Postgres ecosystem! #PGData2026 #PostgreSQL #PostgresCommunity #PGConf #CFPCommittee

Thanks to buyers over the Thanksgiving holiday weekend, the save50 promo, and BFCM. Great to see High Performance PostgreSQL for Rails back in the best sellers list! @pragprog.com

PG DATA CfP is open! We’re building a new Postgres conference series focused on education, community, and collaboration. 👉 Submit your talk proposal here: sessionize.com/pg-data-2026 Join us in June! #PGData2026 #PostgreSQL #PostgresCommunity #MidwestTech #ChicagoTech

Newsletter issue sent to 1020 recipients! 50% off Prag Prog books. Conferences. Winding down 2025. — Issue #21 Subscribe here and ping me if you missed it and want to see it: pgrailsbook.com

I collected all Ruby Black Friday deals I could find & posted them in one spot. Highlights include: $130 off @beautifulruby.com Phlex on Rails course $81 off @gorails.com annual subscription +20% @joemasilotti.com Hotwire native content Lots of @pragprog.com deals Enjoy! 🦃🔥💰

Pragprog Early Black Friday sale 50% off with code Save50 Includes all Beta books pragprog.com/categor...

The job of a programmer is to manage exactly two things: uncertainty and complexity. Code is sometimes an asset and sometimes a liability, but itself has no meaning outside the context of those two factors.

If you're open to books, @andyatkinson.com 's "High Performance PostgreSQL for Rails" is on sale for 50% off. bsky.app/profile/andy...

I'm really enjoying working through this book, and it's on sale! #WomenInTech #WomenWhoCode #TechSky

Pragmatic Bookshelf has 50% off nearly every book including mine: pragprog.com/titles/aapsq... Use code "save50" to get the e-book for around $20. Please share in your backend engineering team chat. Check out quotes from past readers: andyatkinson.com/pgrailsbook Thanks for your support!

Big performance problems 🤝 tiny CS tricks Our latest blog breaks down how bloom filters helped us take an API from 5s to 0.3s - even with millions of alerts in play. If you’re fighting slow queries or Postgres under pressure, this one’s worth a look: go.incident.io/r9jgcI9

It's time for the big @pragprog.com Black Friday sale! This year, 50% off with code "save50" -- I think this is the biggest sale in Prag Bookshelf history! Ends December 1st. Go to media.pragprog.com/newsletters/... for more info.

Wale is great! Check this out. If you're looking for a Rails consultant get in touch with @wale-olaleye.bsky.social. bsky.app/profile/indi...

Thanks again for the idea Andy, blog post published, let us know if it could be clearer or more useful — Michael www.pgmustard.com/blog/what-do...

Learn Bash and SQL. I have used so many programming languages and even more frameworks over the years. But basically every project used Postgres and Linux. Learning shell scripting and SQL is probably the best tech investment I made.

🎃 What’s spookier than deploying a high risk change, months of work, 100s of commits, on a Halloween Friday? Doing that without the rounds of unit tests, load tests, canary releases, and dozens of PRs/deploys this had. Fortunately the release today was buttery smooth! 🍬 Now let’s eat candy!