This post is part of the 🏔 Our Tech Journey track of 🔮 Crafting Tech Teams where we cover podcast episodes on engineering culture topics covering extreme programming, technical coaching and team collaboration.
Originally aired April 18th, 2024.
🥇 Summary
We made an in-depth analysis of SQL and NoSQL databases in the context of building React and Next.js applications, covering use cases, advantages, and challenges.
The efficiency of NoSQL in handling large data volumes, efficient clustering, and specific data structures, while highlighting SQL's scaling issues and the emergence of neo-SQL solutions like VITESS.
Considerations on ORMs, caching strategies, and database configurations, offering real-world examples and practical advice for small and medium businesses.
Tools such as DynamoDB, Redis, and MongoDB are mentioned, along with modern platforms like Superbase that combine SQL capabilities with JAMstack principles for rapid MVP development.
Discussed trends like on the shift in open source licensing towards profit and future focus areas on PaaS/SaaS for small-medium businesses.
Hey—It’s Denis: Interesting fact about NoSQL usage as a primary DB, a few weeks after our episode Stripe released an Engineering Blog about how they have leveraged and scaled their in-house MongoDB cluster as their core database.
📌 Timestamps
00:00 Introduction to NoSQL
00:30 Debate on NoSQL in React and Next.js Apps
01:31 Challenges with SQL Databases
03:18 Understanding ORMs and Their Role
05:19 Complex Queries and NoSQL Solutions
52:12 Caching Strategies and NoSQL Databases
53:14 Kitchen Example and Indexing Challenges
56:40 MongoDB Use Cases and Best Practices
01:01:05 Redis and Event Sourcing
01:18:22 Licensing Issues and Future Trends
If you are new, welcome to 🔮 Crafting Tech Teams. I publish to you every week on how to become a better engineering leader. As a subscriber you will receive these posts straight to your favorite inbox.
Free subscribers get access to about half of each paid post and the free content related to the book club and 🏔 Our Tech Journey.
Whenever you’d like to become a paid subscriber you will receive full access to all content including early previews of books and coaching I offer.
🙏 That’s it for now, more stream episodes next week!
NoSQL Databases For Small-Medium Businesses