Aqiraqirlone.hashnode.dev·Apr 4, 2024Improving performance in a Ruby on Rails application with PostgreSQLImproving performance in a Ruby on Rails application with PostgreSQL involves several strategies: 1. Database Indexing: Ensure that your database tables are properly indexed, especially for columns frequently used in queries. This can significantly s...Discuss·75 readsRuby
kalam ahmedkalam714.hashnode.dev·Apr 2, 2024Enhancing Database Query Performance with Advanced Laravel Eloquent TechniquesAs a chef, you know that ingredient quality significantly affects the flavor of your dishes. Similarly, in web development, optimizing your database queries is like using top-notch ingredients to boost your recipe’s performance. Imagine you’re cookin...Discuss·10 likesAdvanced Techniques
Aditya Ladadityaladblog.hashnode.dev·Mar 16, 2024Database ShardingWhat is Database Sharding? It is the process of storing a large database across multiple machines by splitting data into smaller chunks called shards. Importance of Sharding As an application grows, too many attempts of users to access the applica...Discuss#DatabaseInfrastructure
SOURAV BERAsouravtechzone.hashnode.dev·Feb 28, 2024Unlocking Database Design: Mastering ER Diagrams and Understanding CardinalityIntroduction to ER Diagrams: An Entity-Relationship (ER) diagram serves as a blueprint for database design, showcasing the relationships between entities within the system. This visual representation elucidates how various entities interact with each...Discuss·11 likesERDiagrams
Seye Ogunnoworead.seyeogunnowo.com·Jan 29, 2024Advanced Query Techniques in Django's ORMAs a seasoned Django developer, you're likely well-acquainted with the power and convenience that the Django Object-Relational Mapping (ORM) system provides. However, to truly master Django development and optimize your database interactions, it's cr...Discussraw sql
Ian Carsoniancarson.hashnode.dev·Jan 15, 20245 Database Lessons I learnt the hard way.Some of the lessons and patterns that are called standards or best practices, came as result of several years of experiences and in some cases, studies. I have had my fair share of tough lessons that I learnt the hard way. Below are a couple of the l...DiscussDatabases
Rishabh Chandelchandel.hashnode.dev·Jan 1, 2024Boosting PostgreSQL Performance with BRIN IndexesIntroduction PostgreSQL, known for its extensibility and robustness, offers a variety of indexing options to optimize query performance. Among these, Block Range INdexes (BRIN) provide a unique approach to indexing large tables with ranges of values....Discuss·12 likes·189 readsBRINvsBTree
Ian Carsoniancarson.hashnode.dev·Dec 27, 20235 Critical Rules to design a good database.A good and performant database is not an accident, neither a Miracle. It is a combination of proper planning and execution. The more experienced one is with dealing with Databases, the better the design and the higher the chances that the database wi...Discuss·1 likeDatabases
Kariuki Georgeblog.kariukigeorge.me·Aug 22, 2023The write-behind patternWelcome back, this is part 5 of the "caching patterns with Redis" series. Click here to get to the fourth part. Assume our posts application has reached massive scales with a lot of traffic. Our database is struggling to keep up with the sheer amount...Discuss·57 readscaching patterns with redisNode.js
SynergyTopsynergytop.hashnode.dev·Jul 5, 2023Unconventional Database Performance Optimization TechniquesGetting your database performance to hit warp speed is more crucial now than ever before. But we know that you know the classic tricks of the trade for optimizing databases. Still hungry for that extra edge? It's time to dive into the unconventional....DiscussDatabase Performance Optimization Techniques,