Andrew Atkinson Profile Banner
Andrew Atkinson Profile
Andrew Atkinson

@andatki

Followers
1,971
Following
1,120
Media
117
Statuses
2,742

Software Engineer, Consultant, Speaker, Author "High Performance PostgreSQL for Rails" Staff eng, ex- @Microsoft , @Groupon

Minneapolis, MN, USA
Joined April 2014
Don't wanna be here? Send us removal request.
Explore trending content on Musk Viewer
Pinned Tweet
@andatki
Andrew Atkinson
2 months
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! 🥳
@pragprog
PragmaticProgrammers
3 months
New Release - This Week's PragProg Featured Book: @andatki 's best selling PostgreSQL title is out of Beta - #Rails #PostgreSQL
Tweet media one
0
19
74
10
47
217
@andatki
Andrew Atkinson
25 days
> 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.
5
18
186
@andatki
Andrew Atkinson
1 year
🚀It's here! Very excited to announce that "High Performance PostgreSQL for Rails" is now available in Beta! 🎉
@pragprog
PragmaticProgrammers
1 year
Now in Beta: High Performance PostgreSQL for Rails by Andrew Atkinson Build faster, more reliable Rails apps with scalable and reliable PostgreSQL databases. Join the beta. Be part of the book!
3
20
129
18
38
159
@andatki
Andrew Atkinson
2 years
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.♻️
6
19
159
@andatki
Andrew Atkinson
2 months
Tweet media one
Tweet media two
3
8
110
@andatki
Andrew Atkinson
8 months
🗣️ 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!
2
37
93
@andatki
Andrew Atkinson
8 months
“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:
4
13
86
@andatki
Andrew Atkinson
11 days
👊 Let’s go! #1 in Ruby Programming “Best Sellers” on Amazon. 😊 #pgrailsbook @pragprog
Tweet media one
3
2
89
@andatki
Andrew Atkinson
4 months
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. Learn more:
2
14
77
@andatki
Andrew Atkinson
3 months
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.
5
6
76
@andatki
Andrew Atkinson
1 year
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! 😊
4
8
74
@andatki
Andrew Atkinson
2 years
Hey Rails + #PostgreSQL devs, what's one #PostgreSQL thing you wish you knew more about, that's not covered deeply (or at all) in the Rails Guides? Thanks!
30
11
59
@andatki
Andrew Atkinson
6 months
🎉 I’m excited to teach Rails developers how to "Build High Performance Active Record Apps" this May at @railsconf ! Attendees will learn how to write high performance queries with supportive indexes, and configure Active Record Multiple Databases. I'd love to see you there! 😊
Tweet media one
8
4
59
@andatki
Andrew Atkinson
4 months
“It's not Ruby that's slow, it's your database” Post by Bèr Kessels. Good stuff. Understand the queries. Keep them simple. Avoid footguns and strive to minimize all query components, to maximize reliability and scalability.
1
8
52
@andatki
Andrew Atkinson
2 months
"High Performance PostgreSQL for Rails" is selling & shipping on Amazon. It's currently #2 in Best Sellers in the Ruby Programming category! This algorithmically-generated list of books is a bit sketchy though. We're coming for you... "150 Most Famous Poems!" 😂 @pragprog
Tweet media one
6
5
49
@andatki
Andrew Atkinson
1 month
Feeling incredibly fortunate to have the #1 best selling book in the "Ruby Programming" on Amazon (ok, technically there's the "150 poems" book 😂), and the overall #1 best selling book for nearly 6 weeks on @pragprog . Thank you so much to the readers and supporters!
Tweet media one
8
3
49
@andatki
Andrew Atkinson
6 months
Whoa. Studied PostgreSQL query plan. Times jumped on a Merge join. Source CTE query had no explicit ORDER BY. Added ORDER BY PK ASC. Time dropped from 110ms to 4ms w/ that. Overall: Started at 800ms. Added indexes and optimizations. Ended w/ all Index Only Scans and sub 5ms! 🔥
6
1
47
@andatki
Andrew Atkinson
9 months
It's done! Just sent the email to the editor to make it "official." ✍️📖🛑🐿️➡️🎅 Next week I'll be crafting my reflections and individual thank you messages to those who helped over the last 20 months. Feeling deeply grateful and excited about 2024.
@andatki
Andrew Atkinson
1 year
🚀It's here! Very excited to announce that "High Performance PostgreSQL for Rails" is now available in Beta! 🎉
18
38
159
5
2
48
@andatki
Andrew Atkinson
2 months
Needed a screen time break, but found a lengthy post to read. What to do? Inspired by @aarondfrancis , I used a “printer” to make a physical copy. The year 2000 called and wants their 16 pages back, but they can’t have ‘em. ☀️ Grabbing a pen, cool beverage, and heading…outside!
Tweet media one
7
2
48
@andatki
Andrew Atkinson
5 months
📚 Thanks to recent promotional help from @shortrubynews , #SinCityRuby conference, and appearing on the @tembo_io   "Hacking Postgres" podcast, #pgrailsbook has moved into the #2 weekly bestseller position for @pragprog . 🎉 #PostgreSQL #Rails 👇
Tweet media one
4
5
47
@andatki
Andrew Atkinson
7 months
Besides the benefits of PostgreSQL docs read by a super smart, experienced engineer, a really fun thing about this @hnasr video is experiencing the "joy of learning" secondhand. "Interesting! I didn't know that." 😊 All Postgres Locks Explained 👉
1
8
45
@andatki
Andrew Atkinson
1 year
Posted on Reddit /r/rails over the weekend and got a lot of great responses! It was validating and energizing to see the enthusiasm. Responded to commenters and picked up a lot of new subscribers for the book newsletter. #pgrailsbook #PostgreSQL
1
1
47
@andatki
Andrew Atkinson
1 year
To build hype for the upcoming Beta release of , I'm offering a sneak peek at content exclusively to subscribers. Over the next month 1 email/week will summarize 10 unique gems and extensions from 40+ in the book. Sign up today! First email tomorrow!
0
10
46
@andatki
Andrew Atkinson
7 months
📚 "High Performance PostgreSQL for Rails" back on top of the weekly bestseller list @pragprog ! Thanks so much! Visit the forum for feedback, and please add ratings and reviews on Goodreads. ❓ 🗳️
1
4
45
@andatki
Andrew Atkinson
2 months
Honored to see my book "High Performance PostgreSQL for Rails" included in the @evilmartians "Rails Startup Stack." 😊 @palkan_tula mentioned it here: 👉 Learn about the "Rails Startup Stack": #pgrailsbook @pragprog
1
8
45
@andatki
Andrew Atkinson
4 months
Winding down a big batch of PostgreSQL client DB index optimization. Removed 175 unused indexes. Added 25 new ones. 775GB DB and 250GB indexes. Some dramatic reductions of scan costs, opening up query perf improvements and greater scalability and reliability.
4
4
44
@andatki
Andrew Atkinson
1 month
Excited to see well-known open source Ruby programmer and pgvector PostgreSQL guru @andrewkane has ordered a copy of #pgrailsbook ! Several of Andrew's high-quality, useful, and category-leading libraries in Ruby and Postgres—are featured in the book. Thank you Andrew!
Tweet media one
0
0
43
@andatki
Andrew Atkinson
8 months
Hello. 👋 I’ve got a newsletter for my PostgreSQL 🐘  and Rails book. I’m preparing the next issue now, which features my experience on final revisions, current promo codes, ratings and reviews, and related PostgreSQL content. Sign up to get it  👉
1
6
41
@andatki
Andrew Atkinson
1 year
This is it! 😄Today is the last day before the Beta book release. Subscribe today to get the final pre-Beta newsletter email. Pre-Beta release subscribers will get an exclusive discount code after the book launches. Thanks! #pgrailsbook
2
7
40
@andatki
Andrew Atkinson
11 months
Rails 7.1 was officially released at #RailsWorld . 🎉The sample Rails app "Rideshare" for #pgrailsbook is now running 7.1 and PostgreSQL 16.
2
2
38
@andatki
Andrew Atkinson
2 months
This two hour workshop was recorded @railsconf and is now available on YouTube. Reply if you’d like to try it out and I’ll send instructions. 😊
@winsletts
Christopher Winslett
4 months
Packed house for @andatki talk entitled “Build High Performance Active Record Apps” — the secret ingredient is Postgres.
Tweet media one
4
1
16
9
3
38
@andatki
Andrew Atkinson
9 months
Best Solution for PostgreSQL hosting for Rails 7 Applications
0
4
37
@andatki
Andrew Atkinson
4 months
Want to build snappy Rails backend apps that users love, w/ sub-5ms DB queries? Reach global scale w/o re-architecting or cache stores. These skills aren’t magic. Come to my workshop “High Performance Active Record Apps” at @railsconf to demystify & learn w/ hands-on exercises.
0
5
37
@andatki
Andrew Atkinson
3 months
“If you use Rails and Postgres, this book is required reading. If you use Postgres and a different framework, you will still get a ton of value out of it. Every section goes deep.” Thank you @jpcamara ! 🙌 #postgresql #rubyonrails @pragprog
0
5
35
@andatki
Andrew Atkinson
3 months
📅 Mark your calendars! Next Tues. June 11, 11:00 AM PDT / 1PM CT. @PosetteConf is a free online conf. We'll cover basics of multitenancy and related PostgreSQL DB tech: row level security, table partitioning, Active Record Horizontal Sharding and Citus.
2
6
35
@andatki
Andrew Atkinson
5 months
“PostgreSQL’s optimizer has dropped tail latency by nearly half in the last 10 years!” And that’s software running on greatly improved hardware: faster storage, memory, and more CPU cores! 💨🍃
1
7
35
@andatki
Andrew Atkinson
11 months
#1 bestseller this week at @pragprog 🎉😊Thank you so much to readers for your support, encouragement, and suggestions. Still working hard on simplifying and clarifying the words and examples. Keep the feedback coming. 🙌
@pragprog
PragmaticProgrammers
11 months
Best Sellers High Performance PostgreSQL for Rails: Andrew Atkinson Programming Phoenix LiveView: Bruce Tate Sophie DeBenedetto Machine Learning in Elixir: Sean Moriarity Programming Ruby 3.2 5ed: Noel Rappin Business Success w/ Open Source: VM Brasseur
Tweet media one
0
3
19
2
3
34
@andatki
Andrew Atkinson
4 months
💎 🐘 Code “RailsConf2024PG” at checkout takes 40% off the ebook for a few days following @railsconf . The book is just about fully out of Beta, into print. Print pre-orders from Amazon etc. are available: Thx! @pragprog
Tweet media one
2
13
33
@andatki
Andrew Atkinson
5 months
👋 Arrived in Chicago yesterday for @PgdayCHI2024 . Met @LukasFittl IRL, caught up with Postgres friends @sqlliz @AlfredoDrakoRod . Crashed a Chicago Ruby meetup and met @trevorturk and caught up w/ @i_ribon9 . Fun evening!
Tweet media one
3
2
33
@andatki
Andrew Atkinson
11 months
Hello #RailsWorld and @pgconfnyc ! Use PostgreSQL and/or Rails? Traveling and need podcasts to listen to? I've been hitting the circuit. Episodes linked below. Please repost/share! Then I'd love for you to check out “High Performance PostgreSQL for Rails” ( @pragprog ) now in Beta👇
1
9
32
@andatki
Andrew Atkinson
4 months
That's a @railsconf workshop wrap! Amazing opportunity to share #PostgreSQL knowledge w/ Rails devs. - Pictured: pre-workshop office, 5-6 attended - Great q's. from ~100 people in-person, 150 in Slack, peers helping each other. Love it! 💪 Workshop pic: @winsletts @pragprog
Tweet media one
Tweet media two
1
2
31
@andatki
Andrew Atkinson
5 months
📰 With Postgres shops @supabase @neondatabase and @crunchydata (re-)announcing their General Availability, I wanted to get in on the action. ICYMI, I’m Generally Available for PostgreSQL consulting. 😂 Hit me up if you need some help. 👉
2
7
32
@andatki
Andrew Atkinson
10 months
Amazing. Checked the numbers this morning — 50 copies sold while I was sleeping. 🤯 Back in the #1 slot on the publisher Best Sellers list. What an honor and privilege! @pragprog
@andatki
Andrew Atkinson
10 months
I’m so thankful to the book buyers, and to those helping improve the quality behind the scenes. The strong sales are very encouraging! 🙌
0
1
13
2
1
32
@andatki
Andrew Atkinson
11 months
Just updated! Check out Chapter 10 “Handling Greater Concurrency” of #pgrailsbook , where you’ll configure PgBouncer version 1.21.0 to use Prepared Statements and the `statement` pooling mode, connected to PostgreSQL.
2
3
32
@andatki
Andrew Atkinson
4 months
Packed room for @kaspth at @railsconf !
Tweet media one
2
1
32
@andatki
Andrew Atkinson
6 months
MSP ✈️ LAS for #SinCityRuby 2024 to present “Mastering Query Performance” w/ PostgreSQL & Active Record. Attendees will learn fundamentals of well-designed indexes. With a query on tables w/ 10s of millions of rows, we’ll reduce the exec time by 99% to sub-5ms. Excited to share!
1
8
32
@andatki
Andrew Atkinson
7 months
is what we recommend in High Performance PostgreSQL for Rails as well. Check the book app repo and the "Development Guides" repo for instructions and config on and lots more.
@joelquen
Joël Quenneville
7 months
makes upgrading Postgres and managing multiple versions a breeze on mac. So much easier than on the CLI with homebrew! The work to upgrade was: 1. Check for updates > Install 2. Create New Server (Postgres 15) 3. Profit!
Tweet media one
1
0
21
3
3
32
@andatki
Andrew Atkinson
3 months
🐘 Need some help with PostgreSQL performance or operational challenges? How about booking a session with me? I've got immediate availability to help you out. 👉 Learn more about Coaching and Advisory sessions here:
0
8
31
@andatki
Andrew Atkinson
10 months
Thrilled to see [in Beta] "High Performance PostgreSQL for Rails" at the top of The Pragmatic Programmers bestseller list for another week!  🙌  Thank you so much to the supporters, fans, friends, and readers that are making this possible! #pgrailsbook
@pragprog
PragmaticProgrammers
10 months
Best Sellers High Performance PostgreSQL for Rails: Andrew Atkinson Programming Phoenix LiveView: Bruce A. Tate and Sophie DeBenedetto JavaScript Brain Teasers: Faraz Kelhini Machine Learning in Elixir: Sean Moriarity Hands-on Rust: Herbert Wolverson
Tweet media one
0
2
13
1
2
31
@andatki
Andrew Atkinson
10 months
This looks nice. An APM style tool with easy configuration isn’t something @rails supports. Has someone built on ActiveSupport::Notifications or log parsing? Any recommendations?
@aarondfrancis
Aaron Francis
10 months
The Laravel team continues to push the scope of what a "framework" can be. They just dropped another first-party, free offering that could be a million-dollar SaaS. Pulse is basically a full-on, self-hosted APM tool.
Tweet media one
31
46
576
6
1
31
@andatki
Andrew Atkinson
4 months
🐘 I’m leading a two hour workshop on Active Record and PostgreSQL database topics at @railsconf next week, where dozens or possibly hundreds will attend. ⚡ This is an amazing opportunity to contribute to the technical and professional growth of other Rails developers!
2
7
31
@andatki
Andrew Atkinson
8 months
For anyone that missed over holiday break: High Performance PostgreSQL for Rails was the #3 overall best seller for @pragprog in 2023. 🎉 Not bad since sales started ~ Sep. 1! Discount code "2023Top10" still good for 40% off!
@andatki
Andrew Atkinson
8 months
Great to see #pgrailsbook at the #3 sales spot for 2023! The Beta launched around September 1st. We’re excited for the book to go to print and to see what happens with a full year of sales!
0
1
17
1
6
31
@andatki
Andrew Atkinson
2 years
Had a ton of fun presenting #PgPunyPowerful at #RailsConf2022 . Let's chat about #PostgreSQL scaling challenges and solution techniques. Slides are here: Additional resources page: 🙌
1
8
29
@andatki
Andrew Atkinson
1 month
🇪🇸 Continuing to send signed book copies to VIPs. This person needs no introduction in the Rails community. @fxn helped on editing and consistency with Rails content early in the book content, for which I am very grateful. Gràcies Xavier!
Tweet media one
0
0
30
@andatki
Andrew Atkinson
5 months
If you're a Vim user that writes SQL, this is helpful! "Formatting SQL code with pgFormatter within Vim" 📷 By Josh Tolley
0
5
29
@andatki
Andrew Atkinson
6 months
Very fun to show off the #PostgreSQL query planner and indexing capabilities at #SinCityRuby . Some folks didn’t know about Covering indexes, benefits of sorted data, viewing buffers/pages accessed, or how extensible PostgreSQL is and the hundreds of available extensions.
1
0
29
@andatki
Andrew Atkinson
11 months
Good Job shout out. Background jobs w/ PostgreSQL and Rails. @bensheldon You’ll find Good Job featured in “Chapter 15. Advanced Usage and What’s Next” #pgrailsbook Configuration w/ sample app, exploring PostgreSQL impl details. Curious about Solid Queue.
2
2
28
@andatki
Andrew Atkinson
3 months
🎧 "Just use Postgres with Craig Kerstiens" @SoftwareHuddle Craig is discussing learning Postgres w/ books, and mentions first @TheArtOPostgres then...my book! (21:40) "It's a great, great book!" What a nice surprise, thanks @craigkerstiens ! cc @pragprog
0
5
28
@andatki
Andrew Atkinson
2 years
Thrilled to present at @railsconf on PostgreSQL, Rails, Performance and Scalability next month in Portland, OR!
0
2
28
@andatki
Andrew Atkinson
2 years
Working on #PostgreSQL talk titles. So far I have: "If These WALs Could Talk"
1
1
28
@andatki
Andrew Atkinson
4 months
🇯🇵 Would love help growing awareness of the book in Japan. 📚🐘💎 (English only for now, maybe translations in the future?) ありがとうございます @nateberkopec @jessethanley @junya @kibitan @pragprog
@junya
Junya Ogura
4 months
PragProgの High Performance PostgreSQL for RailsがBETAを脱して内容出揃ったようなので、購入して読み始める。
Tweet media one
2
2
15
3
8
27
@andatki
Andrew Atkinson
10 months
What @dhh is saying about @rails here can be said about another amazing open source project: PostgreSQL. Any dev can download it, use it, compile it, fork it, or build a commercial business on top. No impediments to start. No single entity in control.
@rails
Ruby on Rails
10 months
The @honeypotio Rails documentary Q&A with @dhh @jamis @tobi & @bitsweat is now online. They covered a lot of ground, covering the start of Rails, the state of open source, and so much more. Thank you Elise Shaffer @therubyonrails for moderating! 👉
0
10
63
0
0
27
@andatki
Andrew Atkinson
6 months
Nice detail from the great post "100x Faster Query in Aurora Postgres with a lower random_page_cost" from @shayonj . Shayon shows how to de-risk the config change by setting it for a single session in a Ruby block that calls RESET at the end. Good idea!
1
5
26
@andatki
Andrew Atkinson
20 days
@gwenshap Nice. Another option to check out is , created and maintained by @hnasr !
1
1
25
@andatki
Andrew Atkinson
4 months
💻 As a Rails developer I use “rails console” daily for code, but I don’t use a CLI client like psql to work w/ SQL. Should I? What are the benefits and basic commands? Come to my workshop “High Performance Active Record Apps” at @railsconf to learn more, w/ hands-on exercises.
2
1
26
@andatki
Andrew Atkinson
3 months
⭐ I'm seeing stars! My small Rails API-only app: ☑️ Became the Rails + PostgreSQL app for my book ☑️ Has been used for examples in my presentations and workshops ☑️ Recently gained 100 stars!
1
1
26
@andatki
Andrew Atkinson
7 months
Just wrapped up a live, two-part training on PostgreSQL topics for Rails engineers, running big DBs. We discussed Transactions, MVCC, Query Planning, Indexes, Bloat, Locks, and Partitioning. If your team would benefit from this, please get in touch!
0
4
25
@andatki
Andrew Atkinson
6 months
So cool to have been a guest on ! I’ve been a listener since the first episode in August 2022, and have caught every episode since due to the high quality content! Thanks for the opportunity @michael and @samokhvalov !
@PostgresFM
Postgres FM
6 months
New episode: "Rails + Postgres" Michael and Nikolay are joined by @andatki , author of High Performance PostgreSQL for Rails, to discuss things like where the limits are, how people use the ORM, and things we can improve! 🎧 📺
Tweet media one
1
2
13
0
4
26
@andatki
Andrew Atkinson
5 months
With Redis changing the license, maybe you’d consider migrating that data to PostgreSQL? While less commonly picked for cache data, session ids, and transient background job data, PostgreSQL is capable. DIY (Chp 15): Or hire me:
2
2
26
@andatki
Andrew Atkinson
7 months
Great to meet @shayonj over Zoom for the first time, who's hacking on amazing open source PostgreSQL management tools, written as command-line Ruby programs. Online schema changes 👉 and zero downtime upgrades 👉 Great work!
1
6
25
@andatki
Andrew Atkinson
6 months
🌵 Excited to be in Vegas for #SinCityRuby 2024. Had fun exploring the Hoover dam 🏜️ area with @palkan_tula @inazarova @jeremysmithco @domlizarraga_ yesterday.
Tweet media one
Tweet media two
Tweet media three
0
2
25
@andatki
Andrew Atkinson
2 years
Some ideas: connection pooling, database maintenance, concurrency trade-offs, functions, views, triggers, extensions, partitioning, replication, sharding, query performance, specialized indexes, ...<insert your idea here>???
1
0
25
@andatki
Andrew Atkinson
1 year
Brian of wrote an amazing #PostgreSQL technical blog post called "Cost of a Join" that creates a reproducible set of evidence showing the incremental performance impact of JOINs. Brian refutes common wisdom that denormalization is better than a join.
1
7
25
@andatki
Andrew Atkinson
11 months
Learn about creating and updating Materialized Views using the Scenic gem with Ruby on Rails and Active Record. Add Unique indexes to them to refresh their results concurrently. #pgrailsbook #postgresql #rails PR: Book:
0
2
25
@andatki
Andrew Atkinson
9 months
This extension could be a game changer for more efficiently generating, indexing, and retrieving UUIDs. Crunchy Bridge already supports it! #PostgreSQL
@craigkerstiens
Craig Kerstiens - Finger lime evangelist
9 months
A few new extensions on Crunchy Bridge, uuidv7 support and an extension for anonymizing data 🎉
0
1
17
1
4
25
@andatki
Andrew Atkinson
4 months
💐 While I’m experiencing professional life “highs” recently, today came with a personal life low. I’ve just returned from a beautiful celebration of the life of my friend Katie, a wife, mom, and supremely caring person, serving the community as a dentist, gone way too soon.
3
0
24
@andatki
Andrew Atkinson
4 months
When adding an index to a table, how do know it’s used, and how much an improvement it makes? What about the bytes saved vs. bytes added for writes? Come to my workshop “High Performance Active Record Apps” at @railsconf where we’ll learn about this topic w/ hands-on exercises.
Tweet media one
0
5
25
@andatki
Andrew Atkinson
2 months
Thanks so much for the likes, reposts, and purchases, helping announce the print availability of “High Performance PostgreSQL for Rails.” Currently on top of the @pragprog weekly bestseller list! 🎉
Tweet media one
@andatki
Andrew Atkinson
2 months
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! 🥳
10
47
217
0
2
24
@andatki
Andrew Atkinson
11 months
Hey #Rails devs: if you heard of Unlogged tables in PostgreSQL for the first, you might be wondering what they are. This post briefly shows how to use unlogged tables and the RETURNING keyword for higher performance bulk inserts. #PostgreSQL
2
5
24
@andatki
Andrew Atkinson
11 months
Great lightning talk demo of "pgmq" by @adamhendel Showed how to enqueue jobs, process them, and hide them! (optionally keeping hidden jobs around for analysis). Nice! @tembo_io @pgconfnyc
Tweet media one
0
5
24
@andatki
Andrew Atkinson
10 months
Active Record Multiple Databases Tips: For read replicas, to avoid running migrations and to skip “database tasks” like seeds, use the options “replica: true” and “database_tasks: false” respectively in config/database.yml. #pgrailsbook @rails
0
4
23
@andatki
Andrew Atkinson
6 months
I've just added a YouTube recording link to my slides "How We Made PostgreSQL Fitter, Happier, More Productive" from PGConf NYC 2021, using the new "Resources" section of @speakerdeck . 👀 Check it out!
1
1
24
@andatki
Andrew Atkinson
11 months
> “We picked Postgres as our foundational database. We built tenant virtualization into it, allowing many virtual tenant databases to be placed on physical Postgres databases.” This is big. Congrats on the launch! (cc @gwenshap )
@sriramsubram
Sriram Subramanian
11 months
🚀I am excited to reveal Nile to the world finally! Nile is serverless Postgres database for modern SaaS Nile virtualizes tenants into the database to provide 1. Tenant isolation and per-tenant backups 2. Drop-in organization and user management 3.
32
61
432
1
5
23
@andatki
Andrew Atkinson
1 year
Very grateful to the Technical Reviewers and their feedback for "High Performance PostgreSQL for Rails." Made it through Chapter 1. 😅 Excited to apply the corrective feedback and incorporate their suggestions! #PostgreSQL #PGRailsBook
2
1
23
@andatki
Andrew Atkinson
10 months
Black Friday sales were even more amazing! More than 100 copies sold in a day! Motivates us to work even harder on Beta reader feedback. Feels special to work on a book so many programmers find useful. 😊 turkeysale2023 40% off code still active! @pragprog
@andatki
Andrew Atkinson
10 months
Amazing. Checked the numbers this morning — 50 copies sold while I was sleeping. 🤯 Back in the #1 slot on the publisher Best Sellers list. What an honor and privilege! @pragprog
2
1
32
1
1
23
@andatki
Andrew Atkinson
2 years
Day 1 is wrapping up here at #RailsConf2022 in Portland, OR. Tomorrow morning at 10:30 AM I'll be speaking about PostgreSQL performance and scaling topics with Rails, and hope you can attend! #PgPunyPowerful #postgresql #rubyonrails #scaling
0
3
23
@andatki
Andrew Atkinson
8 months
Met @tobias_petry over Zoom, author of the amazing and multiple books! We discussed writing, promotion, marketing, sales, consulting, DBA vs. developer audiences, query plans in PostgreSQL vs. MySQL, and more. Looking forward to another chat! #databases
2
3
22
@andatki
Andrew Atkinson
5 months
✂️ I wrote about SPLIT PARTITION and MERGE PARTITIONS commands, coming in PostgreSQL 17, 🐘  imagining use cases and showing the DDL needed to try these at home. 🏠 Let me know what you think! #PostgreSQL @nori_shinoda @jer_s @CrestonJamison
@planetpostgres
Planet PostgreSQL
5 months
Andrew Atkinson ( @andatki ): Use Cases for Merging and Splitting Partitions With Minimal Locking in PostgreSQL 17
0
6
24
2
4
22
@andatki
Andrew Atkinson
5 months
ICYMI over the weekend, @railsconf posted a nice presenter intro. Thank you! 💻 Big week for workshop prep! In-person local version happening tomorrow in Mpls w/ 15 participants. 🎙️ Soon: new podcast ep. dropping w/ workshop preview. 🤫 Stay tuned!
@railsconf
RailsConf
5 months
Meet #speaker @andatki , Staff Software Engineer, Independent Consultant and Author 👨🏻‍💻✨ Andrew is the author of High Performance PostgreSQL for Rails. He's spoken at Sin City Ruby, RailsConf, PGConf NYC, PGDay Chicago, and RubyConf Argentina. Learn more:
Tweet media one
0
2
15
0
3
21
@andatki
Andrew Atkinson
8 months
Had a great time meeting Charles ( @cmaxw ), Valentino ( @thecodenamev ), and Dave ( @kobaltz ) at Ruby Rogues! We discussed PostgreSQL with Ruby on Rails. We chatted about the writing process, and how it's aimed at "Application DBAs" (credit: @be_haki ). 👉
@rubyrogues
Ruby Rogues
8 months
Check out this week's episode of #RubyRogues with Andrew Atkinson #𝗥𝗨𝗕𝗬: Powering Rails Applications with Postgres
Tweet media one
0
5
9
1
3
21
@andatki
Andrew Atkinson
4 months
Finished recording my talk for @PosetteConf ! Swapped my normal black t-shirt for a purple one. Let's make #Posette #Purple a thing! 😂 Looking forward to the live event June 11 at 11:00 AM PDT. I'll be online for the live Q&A! @tgcmn @clairegiordano
Tweet media one
Tweet media two
@andatki
Andrew Atkinson
4 months
📼 Recording today! “SaaS on Rails on PostgreSQL” Attend this free online event, to be streamed with live Q&A on June 11! Hope you can attend. 😊 @PosetteConf @rails #PostgreSQL
Tweet media one
0
4
12
1
4
21