
The Changelog: Software Development, Open Source
Picking a database should be simple (Friends)
Aug 9, 2024 · 1 hr 6 min · 64.3 MB
0:00-1:06:45
Streams straight from the publisher. podnod never proxies or re-hosts episode audio.
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.
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
CHANGELOGwhen 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:
Show Notes:
- Jepsen - Consistency Models
- LiteFS
- litestream
- rqlite
- BoltDB, InfluxDB, Key-Value Databases with Ben Johnson (Changelog Interviews #170)
Something missing or broken? PRs welcome!
Join the discussion
changelog.zulipchat.comChangelog++
changelog.comSentry
sentry.io1Password
1password.comINFRASTRUCTURE.md
github.comIntel Innovation 2024
intel.comregister
reg.oneventseries.intel.comWebsite
medium.comGitHub
github.comX
x.comWebsite
jerodsanto.netGitHub
github.comLinkedIn
linkedin.comMastodon
changelog.socialX
x.comJepsen - Consistency Models
jepsen.ioLiteFS
github.comlitestream
litestream.iorqlite
rqlite.ioPRs welcome!
github.com
- 0:00Let's talk!
- 0:38Sponsor: Sentry
- 3:55Ben Depends
- 5:05Why databases
- 6:14Just use Postgres?
- 9:08OO database dreams
- 10:33Where do you put stuff?
- 15:03Sponsor: 1Password
- 18:09Ben's db experience
- 19:03Jerod tries MongoDB
- 21:19Materialized views
- 21:36Graph databases
- 22:49Low-level differences
- 24:29BoltDB
- 26:01Thoughts on Redis
- 27:52Select for update
- 28:19How to learn
- 31:15Ben likes simplicity
- 31:58Reasonable data loss
- 34:27Not building for Amazon
- 35:24Sponsor: Intel Innovation 2024
- 37:26Simplicity, simplicity, simplicity
- 40:01SQLite's simplicity
- 41:33SQLite drawbacks
- 43:36SQLite as web backend
- 44:50The SPA/MPA web dev pendulum
- 46:22LiteFS for horizontal scale
- 48:04Ben on burnout
- 50:28The why behind LiteFS
- 53:12Vector databases
- 55:06Multi-database solutions
- 58:34How to make software simple
- 1:00:25Jamis Buck on API design
- 1:01:22We're still here
- 1:03:00Bye, friends
- 1:03:13Coming up next