--- title: Best gitconnected posts — September 2024 | daily.dev description: The most upvoted gitconnected posts from September 2024, curated by the daily.dev community. canonical: https://daily.dev/sources/gc/best-of/2024/09 twitter:card: summary_large_image twitter:site: @dailydotdev og:url: https://daily.dev/sources/gc/best-of/2024/09 og:type: website og:site_name: daily.dev og:title: Best gitconnected posts — September 2024 | daily.dev og:description: The most upvoted gitconnected posts from September 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 gitconnected — September 2024 1. 1 [](https://daily.dev/posts/in-search-of-improving-database-performance-a-comprehensive-guide-with-8-key-strategies-pwgeklk4h "In Search of Improving Database Performance: A Comprehensive Guide with 8 Key Strategies") Article gitconnected · 2y In Search of Improving Database Performance: A Comprehensive Guide with 8 Key Strategies The post explores eight key strategies to boost database performance. It covers query optimization techniques, avoiding correlated subqueries, batching operations, leveraging materialized views, utilizing indexes, and analyzing query execution plans. Additional strategies include configuring database settings, employing caching strategies, employing database partitioning, sharding, and replication methods to enhance read/write speeds and manage large datasets efficiently. 301 6 2. 2 [](https://daily.dev/posts/complete-guide-to-building-authorization-systems-using-rbac-rebac-and-abac-zfmsrbtey "Complete Guide to Building Authorization Systems using RBAC, ReBAC and ABAC") Article gitconnected · 2y Complete Guide to Building Authorization Systems using RBAC, ReBAC and ABAC Building a robust and scalable authorization system requires understanding various models like Role-Based Access Control (RBAC), Relationship-Based Access Control (ReBAC), and Attribute-Based Access Control (ABAC). Using examples from GitHub, the post explains the complexities of managing permissions and dynamically updating them in real time. It covers how OpenFGA can be used to model these relationships declaratively for ReBAC and briefly introduces ABAC for attribute-driven access control. 52 [See all gitconnected archives](/sources/gc/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/gc/best-of/2024/09#page","url":"https://daily.dev/sources/gc/best-of/2024/09","name":"Best gitconnected Posts — September 2024","description":"The most upvoted gitconnected posts from September 2024, curated by the daily.dev community.","isPartOf":{"@type":"WebSite","url":"https://daily.dev"}},{"@type":"ItemList","@id":"https://daily.dev/sources/gc/best-of/2024/09#items","numberOfItems":2,"itemListElement":[{"@type":"ListItem","position":1,"url":"https://daily.dev/posts/in-search-of-improving-database-performance-a-comprehensive-guide-with-8-key-strategies-pwgeklk4h","name":"In Search of Improving Database Performance: A Comprehensive Guide with 8 Key Strategies"},{"@type":"ListItem","position":2,"url":"https://daily.dev/posts/complete-guide-to-building-authorization-systems-using-rbac-rebac-and-abac-zfmsrbtey","name":"Complete Guide to Building Authorization Systems using RBAC, ReBAC and ABAC"}]},{"@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":"gitconnected","item":"https://daily.dev/sources/gc"},{"@type":"ListItem","position":4,"name":"Best of","item":"https://daily.dev/sources/gc/best-of"},{"@type":"ListItem","position":5,"name":"September 2024"}]}]} ```