Andrew Atkinson (@andatki) / X

Andrew Atkinson

3,147 posts

Andrew Atkinson

@andatki

👉 Not using X, please find me at the links below. Thanks!

andyatkinson.com/social-media

Joined April 2014

Following

2,047

Followers

Pinned
Andrew Atkinson
@andatki
Jun 27, 2024
From 2 amazing open source projects #Rails & #PostgreSQL, w/ 9 months writing to 1st draft, 12 mo. editing to “in print,” 15 chapters, 26 mo. since contract signing, 35 contributors, 450 pages, & 900 newsletter subs… 📖🚀 It’s done and in print! TY! 🥳
PragmaticProgrammers
@pragprog
Jun 25, 2024
New Release - This Week's PragProg Featured Book: @andatki's best selling PostgreSQL title is out of Beta - pragprog.com/titles/aapsql #Rails #PostgreSQL
37K
Andrew Atkinson
@andatki
Aug 14, 2024
> I am completely blown away by how amazing this is and how dramatically it impacted performance. Creating a simple index dropped database queries from ~8s to ~20ms on a production DB which containing around 20mil rows. PostgreSQL index only scans FTW. stackoverflow.com/questions/1323…
84K
Andrew Atkinson
@andatki
Aug 30, 2023
🚀It's here! Very excited to announce that "High Performance PostgreSQL for Rails" is now available in Beta! 🎉
40K
Andrew Atkinson
@andatki
Nov 18, 2022
Early career Ruby programmer: add all the gems. 1000 line PRs. Full stack, full kitchen sink. Later career: remove code, remove gems, small as possible PRs, update docs, prefer removals, iteratively deliver PRs back to front. Prefer no code. Recycle, reduce, re-use.♻️
Andrew Atkinson
@andatki
Jul 12, 2024
🎉 Unboxing High Performance PostgreSQL for Rails youtube.com/shorts/11N5fpv… @pragprog #postgresql #rubyonrails #books #unboxing #pgrailsbook
5.4K
Andrew Atkinson
@andatki
Jan 9, 2024
🗣️ Hey folks: I've launched independent consulting! 💎🐘📈 I’m offering Ruby on Rails development services, focused on increasing the performance, scale, and reliability of PostgreSQL database operations. 📅 Please check out and share my consulting page!
High Performance Postgres and Web App Consulting
From andyatkinson.com
21K
Andrew Atkinson
@andatki
Aug 29, 2024
👊 Let’s go! #1 in Ruby Programming “Best Sellers” on Amazon. 😊 #pgrailsbook @pragprog
4K
Andrew Atkinson
@andatki
Jan 19, 2024
“How we migrated our PostgreSQL database with 11 seconds downtime” AWS DMS, Route 53 w/ a 1 second DNS TTL, version 11 to 15, 400GB size. Lots of nice details on timings, prep work, disconnecting clients. HN: news.ycombinator.com/item?id=390483… gds.blog.gov.uk/2024/01/17/how…
5.3K
Andrew Atkinson
@andatki
Feb 10, 2024
“What developers find surprising about Postgres transactions” blog.lawrencejones.dev/isolation-leve… by @lawrjones
What developers find surprising about Postgres transactions
From blog.lawrencejones.dev
9.5K
Andrew Atkinson
@andatki
May 25, 2024
PostgreSQL features are important enough to Active Record and Ruby on Rails that a dedicated Rails Guides page was created. Features like exclusion constraints, that don’t exist in MySQL or SQLite, are included. guides.rubyonrails.org/active_record_… Learn more: pragprog.com/titles/aapsql
guides.rubyonrails.org
Active Record and PostgreSQL — Ruby on Rails Guides
This guide covers PostgreSQL specific usage of Active Record.After reading this guide, you will know: How to use PostgreSQL's datatypes. How to use UUID primary keys. How to include non-key columns...
6.3K
Andrew Atkinson
@andatki
Jun 22, 2024
For a slow PostgreSQL query, filtering 18 mo range on 5+mm row table, left joins to 2 more 5+mm row tables, started at 2s: created a new design that runs in 25ms. Involved multiple materialized views, unique index for concurrent refreshes, union, and targeted covering indexes.
10K
Andrew Atkinson
@andatki
May 19, 2023
Happy Friday. Do you use PostgreSQL 🐘 or Rails,💎 or want to be an early supporter? 📢 Big Announcement! I’m writing a book called “High Performance PostgreSQL for Rails” that’s now in technical review. Subscribe below for early access. Thanks! 😊 pgrailsbook.com
6.3K
Andrew Atkinson
@andatki
Sep 27, 2024
In the @planetargon 2024 Ruby on Rails Community Survey w/ 2,700+ responses, PostgreSQL was the most popular database. I just learned "High Performance PostgreSQL for Rails" was voted one of the top ten most recommended books! 🔥 railsdeveloper.com #RailsWorld @pragprog
3.4K
Andrew Atkinson
@andatki
Sep 27, 2024
Whoa 😍 back to #1 on Amazon in the Ruby Programming category. No doubt related to activity from #RailsWorld. Thank you all!
2.5K