--- title: Best Architecture Weekly posts — April 2025 | daily.dev description: The most upvoted Architecture Weekly posts from April 2025, curated by the daily.dev community. canonical: https://daily.dev/sources/architectureweekly/best-of/2025/04 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/architectureweekly/best-of/2025/04 og:type: website og:site_name: daily.dev og:title: Best Architecture Weekly posts — April 2025 | daily.dev og:description: The most upvoted Architecture Weekly posts from April 2025, 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 Architecture Weekly — April 2025 1. 1 [](https://daily.dev/posts/postgresql-jsonb---powerful-storage-for-semi-structured-data-rtjvzqzuu "PostgreSQL JSONB - Powerful Storage for Semi-Structured Data") Article Architecture Weekly · 1y PostgreSQL JSONB - Powerful Storage for Semi-Structured Data PostgreSQL JSONB offers a powerful method for storing and querying semi-structured data. JSONB stores data in a binary format, allowing for efficient indexing and querying without the need for repeated parsing. The article discusses the internal structure of JSONB, performance benefits, and various indexing strategies like GIN and B-Tree to optimize JSONB queries. It also covers practical applications, such as using JSONB for managing heterogeneous data models and ensuring query performance. Although JSONB provides flexibility, it's essential to understand its performance implications for large datasets. 157 2 [See all Architecture Weekly archives](/sources/architectureweekly/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/sources/architectureweekly/best-of/2025/04#page","url":"https://daily.dev/sources/architectureweekly/best-of/2025/04","name":"Best Architecture Weekly Posts — April 2025","description":"The most upvoted Architecture Weekly posts from April 2025, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/architectureweekly/best-of/2025/04#items","numberOfItems":1,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/postgresql-jsonb---powerful-storage-for-semi-structured-data-rtjvzqzuu","name":"PostgreSQL JSONB - Powerful Storage for Semi-Structured Data"}]},{"@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Sources","item":"https://daily.dev/sources"},{"@type":"ListItem","position":3,"name":"Architecture Weekly","item":"https://daily.dev/sources/architectureweekly"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/architectureweekly/best-of"},{"@type":"ListItem","position":5,"name":"April 2025"}]}]} ```