Published Aug 9, 2024

Picking a database should be simple (Friends)

Explore the delicate balance between simplicity and complexity in database design as Jerod Santo and database expert Ben Johnson delve into the intricacies of choosing the right database, lessons from SQLite, and the specialty of key-value stores like BoltDB and Redis. Gain insights into determining acceptable data loss, scaling potential, and the architectural nuances essential for making informed database decisions.

Episode Highlights

Topics covered

Episode Highlights

Related Episodes

RethinkDB, Databases, the Realtime Web
Answers 383 questions
MongoDB, NoSQL, Web Scale (Interview)
Answers 383 questions
RethinkDB (Interview)
Answers 383 questions
Just Postgres
Answers 383 questions
Why SQLite succeeded as a database
Answers 383 questions
It all starts with Postgres (Interview)
Answers 383 questions
NoSQL Smackdown! (Interview)
Answers 383 questions
Redis In-Memory Data Store (Interview)
Answers 383 questions
Erlang, CouchBase, Merging with Membase (Interview)
Answers 383 questions
Taking Postgres serverless
Answers 383 questions
ANTHOLOGY – Self-hosted, self-confident & self-employed (Friends)
Answers 383 questions
Building the developer cloud (Interview)
Answers 383 questions
10gen and MongoDB (Interview)
Answers 383 questions
Developer (un)happiness (Friends)
Answers 383 questions
Discovering discovery coding (Friends)
Answers 383 questions

Dexa/The Changelog

Picking a database should be simple (Friends)

Topics covered

Popular Clips

Scalable SDK Development

Redis and Isolation Levels

Data Loss Perspectives

The Power of Simplicity

Simplifying High Availability

Database Isolation Levels

Graph Databases Explained

Embedded Key-Value Stores

Debugging with Data

Embracing Simplicity

Scaling SQLite Globally

Database Diversity

Open Source Realities

Application Logic Debate

Episode Highlights

Designing for Simplicity

Lessons from SQLite

Key-Value Stores

Database Selection Insights

Related Episodes

RethinkDB, Databases, the Realtime Web

MongoDB, NoSQL, Web Scale (Interview)

RethinkDB (Interview)

Just Postgres

Why SQLite succeeded as a database

It all starts with Postgres (Interview)

NoSQL Smackdown! (Interview)

Redis In-Memory Data Store (Interview)

Erlang, CouchBase, Merging with Membase (Interview)

Taking Postgres serverless

ANTHOLOGY – Self-hosted, self-confident & self-employed (Friends)

Building the developer cloud (Interview)

10gen and MongoDB (Interview)

Developer (un)happiness (Friends)

Discovering discovery coding (Friends)

Picking a database should be simple (Friends)

Topics covered

Popular Clips

Episode Highlights

Designing for SimplicityThe discussion shifts to the importance of simplicity in software solutions, with Jerod Santo and Ben Johnson exploring how simplicity can be both a goal and a challenge in database design.

Designing for Simplicity

Lessons from SQLiteBen Johnson examines the limitations and scaling potential of SQLite in web server environments. He discusses tools like Lightstream and Lightfs that address these challenges, offering insights into balancing simplicity and complexity.

Lessons from SQLite

Key-Value Stores

Database Selection InsightsDatabase expert Ben Johnson joins Jerod Santo to discuss the intricacies of selecting the right database for your needs. They explore factors influencing database choice, acceptable data loss levels, and the complexities of using multiple databases in a project.

Database Selection Insights

Related Episodes