139: Alex DeBrie - DynamoDB for Relational Database Diehards

Full Stack Radio

Episode | Podcast

Date: Fri, 08 May 2020 12:04:00 +0000

<p>Topics include:</p><ul> <li>Does DynamoDB only make sense for things like your cache, or is it a good choice for a primary data store?</li> <li>An overview of the terminology used in DynamoDB and how the terminology compares to a relational database</li> <li>How primary keys work in DynamoDB</li> <li>What data types are available in DynamoDB</li> <li>How DynamoDB is a schemaless database</li> <li>Why it's important to understand your access patterns in advance with DynamoDB, unlike in a relational database</li> <li>Understanding why and how you usually have multiple record types in a single DynamoDB table</li> <li>What "index overloading" is in DynamoDB</li> <li>Understanding partition keys and sort keys</li> <li>How to structure your data in DynamoDB to make it possible to query related data, and how those queries work</li> <li>How secondary indexes work, allowing you to access the same data in different ways</li> <li>How to accommodate access patterns you didn't know about before you designed your schema</li> <li>When to flatten relationships vs. nest them</li> <li>Should you use DynamoDB if you aren't "web-scale"?</li> <li>How local development works with DynamoDB</li> </ul><p>Links:</p><ul> <li><a href="https://aws.amazon.com/dynamodb/">DynamoDB Homepage</a></li> <li> <a href="https://www.alexdebrie.com/">Alex's blog</a>, loaded with great DynamoDB content</li> <li> <a href="https://www.dynamodbbook.com/">The DynamoDB Book</a>, Alex's recent book</li> <li><a href="https://www.dynamodbguide.com/">DynamoDB Guide</a></li> </ul><p>Supporting the show:</p><p><br />I decided to stop taking sponsors for the show because I think advertisements are annoying and no one wants to listen to them.</p><p>If you do want to support the show, the best way to do it is to purchase one of my products:</p><ul> <li> <a href="https://tailwindui.com">Tailwind UI</a>, a collection of professionally designed, fully responsive HTML components built with Tailwind CSS</li> <li> <a href="https://refactoringui.com/book">Refactoring UI</a>, a book and video series I put together with Steve Schoger on designing beautiful user interfaces, without relying on a designer.</li> <li> <a href="https://adamwathan.me/advanced-vue-component-design">Advanced Vue Component Design</a>, a course on designing simpler, more flexible Vue components that are both more powerful and easier to maintain.</li> <li> <a href="https://course.testdrivenlaravel.com">Test-Driven Laravel</a>, a massive video course on designing robust Laravel applications with TDD. Learn how to build a real-world application from scratch without writing a single line of untested code.</li> <li> <a href="https://adamwathan.me/refactoring-to-collections">Refactoring to Collections</a>, a book and video course that teaches you how to apply functional programming principles to break down ugly, complex code into simple transformations — free of loops, complex conditionals, and temporary variables.</li> </ul>