Picking a database should be simple (Changelog & Friends #56)

Changelog Master Feed

Database aficionado, Ben Johnson, joins Jerod to answer the age ol’ question: which database should you use? Answering that isn’t always easy, which means it’s time to play the “It Depends” jingle & weigh (some of) the options.

Leave us a comment

Changelog++ members save 9 minutes on this episode because they made the ads disappear. Join today!

Sponsors:

• Sentry – Code breaks, fix it faster. Don’t just observe. Take action. Sentry is the only app monitoring platform built for developers that gets to the root cause for every issue. 90,000+ growing teams use sentry to find problems fast. Use the code CHANGELOG when you sign up to get $100 OFF the team plan.
• 1Password – Build securely with 1Password - 1Password simplifies how you securely use, manage, and integrate developer credentials. Manage SSH keys and sign Git commits. Access secrets stored in 1Password. Automate administrative tasks. Integrate with third-party tools. Also, check out our INFRASTRUCTURE.md file for more details on how we do secrets with 1Password.
• Intel Innovation 2024 – Early bird registration is now open for Intel Innovation 2024 in San Jose, CA! Learn more OR register

Featuring:

• Ben Johnson – Twitter, GitHub, Website
• Jerod Santo – Mastodon, Twitter, GitHub, LinkedIn

Show Notes:

• Jepsen - Consistency Models
• https://github.com/superfly/litefs
• litestream
• rqlite
• BoltDB, InfluxDB, Key-Value Databases with Ben Johnson (Changelog Interviews #170)

Something missing or broken? PRs welcome!

Chapters

1. Let's talk! (00:00:00)

2. Sponsor: Sentry (00:00:38)

https://sentry.io/

3. Ben Depends (00:03:55)

4. Why databases (00:05:05)

5. Just use Postgres? (00:06:14)

6. OO database dreams (00:09:08)

7. Where do you put stuff? (00:10:33)

8. Sponsor: 1Password (00:15:03)

https://1password.com/changelogpod

9. Ben's db experience (00:18:09)

10. Jerod tries MongoDB (00:19:03)

11. Materialized views (00:21:19)

12. Graph databases (00:21:36)

13. Low-level differences (00:22:49)

14. BoltDB (00:24:29)

15. Thoughts on Redis (00:26:01)

16. Select for update (00:27:52)

17. How to learn (00:28:19)

18. Ben likes simplicity (00:31:15)

19. Reasonable data loss (00:31:58)

20. Not building for Amazon (00:34:27)

21. Sponsor: Intel Innovation 2024 (00:35:24)

https://intel.com/innovation?regcode=CMCCHL&utm_campaign=Changelog

22. Simplicity, simplicity, simplicity (00:37:26)

23. SQLite's simplicity (00:40:01)

24. SQLite drawbacks (00:41:33)

25. SQLite as web backend (00:43:36)

26. The SPA/MPA web dev pendulum (00:44:50)

27. LiteFS for horizontal scale (00:46:22)

28. Ben on burnout (00:48:04)

29. The why behind LiteFS (00:50:28)

30. Vector databases (00:53:12)

31. Multi-database solutions (00:55:06)

32. How to make software simple (00:58:34)

33. Jamic Buck on API design (01:00:25)

34. We're still here (01:01:22)

35. Bye, friends (01:03:00)

36. Coming up next (01:03:13)