Want to learn how to use Rails + SQLite? Check out our course: https://highleveragerails.com.
DHH and Aaron discuss modern SQLite, the one-person framework, conceptual compression, stoicism, and ONCE.com's newest product: Workbook.
Get production ready SQLite with Turso: https://tur.so/af.
Follow Aaron:
Twitter: https://twitter.com/aarondfrancis
LinkedIn: https://www.linkedin.com/in/aarondfrancis
Website: https://aaronfrancis.com - find articles, podcasts, courses, and more.
SQLite Course: https://highperformancesqlite.com.
Chapters:
00:00 - Intro
01:06 - Talking About SQLite
02:19 - Decision to Use SQLite in Campfire
03:37 - The Shift to Single-Tenant Web Software
05:05 - Simplifying the Stack for User-Friendly Software
06:18 - Rediscovering SQLite for Web Applications
07:50 - Overcoming SQLite’s Performance Limitations
09:30 - Stress Testing SQLite at Scale
11:05 - How Hardware Advances Benefit SQLite
12:02 - Conceptual Compression in Development
13:20 - Aligning SQLite with DHH's Philosophy
14:45 - The Simplified Complexity of SQLite
17:50 - Open Source Software and SQLite’s Future
19:59 - Celebrating SQLite as a Pillar of Simplicity
23:54 - The Single-Person Framework and Its Philosophy
27:50 - Keeping Development Simple and Efficient
33:06 - Using Stoicism in Software Development
37:06 - Solid Cache and Solid Job with SQLite
41:05 - The Value of SQL for Modern Development
44:07 - Workbook: The New Free Product for Writers
49:00 - Source-Included Software as an Educational Tool
52:01 - Wrapping Up