--- title: Best marmelab posts — February 2026 | daily.dev description: The most upvoted marmelab posts from February 2026, curated by the daily.dev community. canonical: https://daily.dev/sources/Marmelab/best-of/2026/02 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/Marmelab/best-of/2026/02 og:type: website og:site_name: daily.dev og:title: Best marmelab posts — February 2026 | daily.dev og:description: The most upvoted marmelab posts from February 2026, 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 marmelab — February 2026 1. 1 [](https://daily.dev/posts/9-advanced-postgresql-features-i-wish-i-knew-sooner-nezidnbnu "9 Advanced PostgreSQL Features I Wish I Knew Sooner") Article marmelab · 28w 9 Advanced PostgreSQL Features I Wish I Knew Sooner A practical tour of nine underused PostgreSQL features that can replace complex application-level logic with native database capabilities. Covered features include EXCLUDE constraints for preventing overlapping ranges, CHECK constraints for row-level validation, GENERATED columns for derived data, DISTINCT ON as a concise alternative to GROUP BY, the FILTER clause for conditional aggregates, PARTITION BY window functions, ON CONFLICT upserts, composite types for structured nested data, and recursive CTEs for traversing hierarchical data. Each feature is illustrated with concrete use cases and SQL examples, along with relevant limitations and links to official documentation. 115 [See all marmelab archives](/sources/Marmelab/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/Marmelab/best-of/2026/02#page","url":"https://daily.dev/sources/Marmelab/best-of/2026/02","name":"Best marmelab Posts — February 2026","description":"The most upvoted marmelab posts from February 2026, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/Marmelab/best-of/2026/02#items","numberOfItems":1,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/9-advanced-postgresql-features-i-wish-i-knew-sooner-nezidnbnu","name":"9 Advanced PostgreSQL Features I Wish I Knew Sooner"}]},{"@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":"marmelab","item":"https://daily.dev/sources/Marmelab"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/Marmelab/best-of"},{"@type":"ListItem","position":5,"name":"February 2026"}]}]} ```