--- title: Best NoSQL posts — August 2024 | daily.dev description: The most upvoted NoSQL posts from August 2024, curated by the daily.dev community. canonical: https://daily.dev/tags/nosql/best-of/2024/08 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/tags/nosql/best-of/2024/08 og:type: website og:site_name: daily.dev og:title: Best NoSQL posts — August 2024 | daily.dev og:description: The most upvoted NoSQL posts from August 2024, curated by the daily.dev community. og:image: https://media.daily.dev/image/upload/s--VAY5ToZt--/f_auto/v1724209435/public/daily.dev%20-%20open%20graph --- # Best of NoSQL — August 2024 1. 1 [](/posts/just-use-postgres-lri3afrxh "Just use Postgres") [](/tags/[tag]/best-of/[year]/[month]) 7m read time • Aug 17, 2024 ### Just use Postgres When developing a new application requiring persistent data storage, Postgres should be the default choice, especially for web applications. SQLite is suitable for desktop or mobile apps but not ideal for websites. NoSQL databases like DynamoDB, MongoDB, Cassandra, and others offer performance benefits if the access patterns are well-defined beforehand but are less flexible when handling evolving access needs. Redis is efficient for caching but can be used as a primary database with some trade-offs. Datomic and XTDB present innovative approaches with specific benefits and challenges. While advanced databases like Kafka and ElasticSearch excel in niche tasks, Postgres often suffices for general needs, potentially complemented by simpler built-in search functions. +5 62 13 2. 2 [](/posts/designing-data-intensive-applications-book-wrgyyarlt "Designing Data Intensive Applications Book") [](/tags/[tag]/best-of/[year]/[month]) 4m read time • Aug 06, 2024 ### Designing Data Intensive Applications Book The post discusses the book 'Designing Data Intensive Applications' as part of a book club, focusing on the first two chapters which cover reliability, scalability, and maintainability of applications, as well as different data models and query languages. It explains the historical context and comparisons between relational and document databases, including the benefits and drawbacks of each model, and the impact of these choices on application design. +3  36 1 3. 3 [](/posts/embracing-simplicity-and-composability-in-data-engineering-bujn5gafy "Embracing Simplicity and Composability in Data Engineering") [](/tags/[tag]/best-of/[year]/[month]) 11m read time • Aug 05, 2024 ### Embracing Simplicity and Composability in Data Engineering The post highlights the importance of simplicity and composability in data engineering, drawing lessons from decades of industry experience. It discusses the Unix philosophy of treating data as files, the evolution of databases and NoSQL, and the complexity introduced by new ecosystems like Hadoop and Kubernetes. The post also critiques the over-complication of agile methodologies and stresses the necessity of adhering to fundamental principles to maintain flexibility and long-term value in software systems. +5  24 4. 4 [](/posts/counting-billions-of-content-usage-at-canva-nynnyfwdk "Counting Billions of Content Usage at Canva") [](/tags/[tag]/best-of/[year]/[month]) 10m read time • Aug 13, 2024 ### Counting Billions of Content Usage at Canva Canva faced significant challenges in accurately counting content usage for their Creators Program due to the rapidly growing data volume which was originally handled by a MySQL-based system. The MySQL design, while simple, created scalability issues. Canva explored transitioning to DynamoDB but found it wouldn't solve their processing problems. Ultimately, they moved to an OLAP-based solution with Snowflake, significantly improving latency and handling billions of records efficiently. The new architecture provided numerous benefits including reduced latency, simplified incident handling, and decreased data storage needs, though it also introduced some new complexities in data transformation and infrastructure management. +4  20 [See all NoSQL archives](/tags/nosql/best-of) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@graph":[{"@type":"CollectionPage","@id":"https://daily.dev/tags/nosql/best-of/2024/08#page","url":"https://daily.dev/tags/nosql/best-of/2024/08","name":"Best NoSQL Posts — August 2024","description":"The most upvoted NoSQL posts from August 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/tags/nosql/best-of/2024/08#items","numberOfItems":4,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/just-use-postgres-lri3afrxh","name":"Just use Postgres"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/designing-data-intensive-applications-book-wrgyyarlt","name":"Designing Data Intensive Applications Book"},{"@type":"ListItem","position":3,"url":"https://daily.dev/posts/embracing-simplicity-and-composability-in-data-engineering-bujn5gafy","name":"Embracing Simplicity and Composability in Data Engineering"},{"@type":"ListItem","position":4,"url":"https://daily.dev/posts/counting-billions-of-content-usage-at-canva-nynnyfwdk","name":"Counting Billions of Content Usage at Canva"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Tags","item":"https://daily.dev/tags"},{"@type":"ListItem","position":3,"name":"NoSQL","item":"https://daily.dev/tags/nosql"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/tags/nosql/best-of"},{"@type":"ListItem","position":5,"name":"August 2024"}]}]} ```