Lavanya VarshneyforThe NAMESPACE Community Blogblog.namespacecomm.in·Dec 24, 2024GraphQL Uncovered: Unlocking the Power of Efficient APIIntroduction In web development, efficient data fetching is essential for responsive applications. While REST APIs have been the traditional choice for client-server communication, their limitations often lead to over-fetching or under-fetching data....9 likes·112 readsGraphQL
Mohan Dubeyand-this-is-how-fired-myself.hashnode.dev·Dec 24, 2024...And This Is How I Fired MyselfPicture This: Founders, a reporting manager, and a team of 40+ people, all relying on daily reports and data sheets manually prepared by running complex SQL queries. Some queries took over a minute to execute, clogging the database and slowing down d...SQL
Darshit Anjariadarshitanjaria.hashnode.dev·Dec 24, 20248 Proven Tips for Optimizing Database Queries and Improving App SpeedIn the fast-paced world of software applications, database performance is critical. Whether you're managing an e-commerce platform with millions of transactions or a content delivery service handling real-time requests, slow database queries can lead...webdev
Saby_Explainsabyexplain.hashnode.dev·Dec 23, 2024Reading Parallel Plans CorrectlyHistorically, the PostgreSQL server operating model looks like many independent processes with partially shared memory. Each process serves only one client connection and handles one query at a time, meaning no multithreading occurs. That’s why, with...PostgreSQL
Saby_Explainsabyexplain.hashnode.dev·Dec 19, 2024Bringing PostgreSQL Query Issues to Light with Insightful VisualsAs we keep sharing more features of our PostgreSQL query analysis service Saby Explain, today we'll give you a quick overview of how to spot issues in large and complex query plans by just taking a quick look at their visualization. You’ll see that ...PostgreSQL
Saby_Explainsabyexplain.hashnode.dev·Dec 17, 2024Reading PostgreSQL Query Plans Brought to a New LevelWe've already introduced you to Saby Explain, an open service designed to help you read and analyze query plans in PostgreSQL, and shared the insights on improving poorly performing queries using Explain recommendations. In this post, we’ll highligh...PostgreSQL
Data & Devrvats20.hashnode.dev·Dec 9, 2024Mastering Database Performance: 10 Key Query Optimization TechniquesOptimizing query performance is a crucial aspect of database design and maintenance. Here are ten effective techniques to improve query performance, along with explanations, use cases, and code samples. 1. Indexing Indexing allows the database system...SQL seriesSQL
Godwin Lawalgodwinlawal.hashnode.dev·Dec 1, 2024Are Your Database Queries Costing The Business Time and Revenue?Why Should You Care The performance of a business website or application can determine if a company gains or loses customers. Customer expectations are rising, so every part, including the database design, must be optimized to meet these expectations...37 readsdatabase administration
Alexander Arlund Nørgaardblog.alexnorgaard.dk·Nov 3, 2024Building an Events Application: Querying events and indexing with GINIn my last blog post we explored how to expose a simple API using the Echo Go framework and GORM ORM. We also took a look at how I wanted to represent an event in the database, including using tags and geolocation for search and filtering purposes. G...PostgreSQL
Saby_Explainsabyexplain.hashnode.dev·Oct 25, 2024Remedy for Poor-Performing SQL QueriesIn previous posts, we introduced you to Saby Explain, a public service for the analysis and visualization of PostgreSQL query plans. Several months after the launch we've reached the milestone of 6,000 usages, but one of the helpful features sometime...PostgreSQL
