Skip to content
FROM guests SELECT Andrew episode artwork

May 18, 2024 1 hr 3 min

FROM guests SELECT Andrew

from Ship It! Archive Hosted by Justin Garrison and Autumn Nash

Andrew Atkinson joins Autumn & Justin to tell them why folks should (and are) picking PostgreSQL as their database in 2024 and how to scale it. Join the discussion Changelog++ members save 2 minutes on this episode because they made the ads disappear. Join today! Sponsors: Neo4j – Is your code getting dragged down by JOINs and long query times? The problem might be your database…Try simplifying the complex with graphs. Stop asking relational databases to do more than they were made for. Graphs work well for use cases with lots of data connections like supply chain, fraud detection, real-time analytics, and genAI. With Neo4j, you can code in your favorite programming language and against any driver. Plus, it’s easy to integrate into your tech stack. Fly.io – The home of Changelog.com — Deploy your apps and databases close to your users. In minutes you can run your Ruby, Go, Node, Deno, Python, or Elixir app (and databases!) all over the world. No ops required. Learn more at fly.io/changelog and check out the speedrun in their docs. Featuring: Andrew Atkinson – Website, GitHub, LinkedIn, Mastodon, X Justin Garrison – GitHub, LinkedIn, X Autumn Nash – GitHub, LinkedIn, X Show Notes: Links of the week sysctl explorer The gender pay gap will ‘never’ close unless this happens Interview Andrew’s website Fresh OSS rHttp tu poetry-camera website Women in Open Source Awesome TUIs Awesome tmux Something missing or broken? PRs welcome!

Episode details come from the podcast's RSS feed.

Embed this episode

Ready to play

FROM guests SELECT Andrew

0:00 1:03:57

Chapters

  1. 0:00 This is Ship It!
  2. 0:51 The opener
  3. 18:18 Sponsor: Neo4j
  4. 19:30 Welcome Andrew Atkinson
  5. 21:32 Postgres in 2024?
  6. 23:07 Avoiding an open source rug pull
  7. 26:52 Why Postgres?
  8. 31:57 Why not Postgres?
  9. 36:21 Migration process
  10. 38:57 State of the art scaling
  11. 40:47 Replicating a single instance
  12. 42:46 Hadoop
  13. 43:51 Going back to the fundamentals
  14. 44:56 DB skill sets
  15. 50:25 Distributed tracing
  16. 51:27 Importance of knowledge
  17. 54:01 Autumn's nightmare Ruby experience
  18. 54:54 Go learn Postgres
  19. 55:35 Where to reach out
  20. 56:10 The closer
  21. 1:03:05 Outro

No transcript yet.

Requests help us decide what to transcribe next.

Frequently asked questions

How long is this episode of Ship It! Archive?

This episode is 1 hour and 3 minutes long.

When was this Ship It! Archive episode published?

This episode was published on May 18, 2024.

Can I download this Ship It! Archive episode?

Yes. Use the download control on the episode player to save the publisher-provided media file.