FROM guests SELECT Andrew

Ship It! SRE, Platform Engineering, DevOps

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.

Leave us a comment

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. Visit Neo4j.com/developer to get started.
• 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 – Mastodon, Twitter, GitHub, LinkedIn, Website
• Justin Garrison – Twitter, GitHub, LinkedIn
• Autumn Nash – Twitter, GitHub, LinkedIn

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!

Chapters

1. This is Ship It! (00:00:00)

2. The opener (00:00:51)

3. Sponsor: Neo4j (00:18:19)

https://www.neo4j.com/developer?utm_source=changelog&utm_medium=podcast&utm_campaign=practicalai

4. Welcome Andrew Atkinson (00:19:30)

5. Postgres in 2024? (00:21:32)

6. Avoiding an open source rug pull (00:23:08)

7. Why Postgres? (00:26:53)

8. Why not Postgres? (00:31:57)

9. Migration process (00:36:21)

10. State of the art scaling (00:38:58)

11. Replicating a single instance (00:40:48)

12. Hadoop (00:42:47)

13. Going back to the fundamentals (00:43:51)

14. DB skill sets (00:44:56)

15. Distributed tracing (00:50:25)

16. Importance of knowledge (00:51:28)

17. Autumn's nightmare Ruby experience (00:54:02)

18. Go learn Postgres (00:54:54)

19. Where to reach out (00:55:35)

20. The closer (00:56:10)

21. Outro (01:03:05)