Alexander Arlund NørgaardforBuilding an events app from scratchblog.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...DiscussPostgreSQL
Saby_ExplainforSaby Explain Blogsabyexplain.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...DiscussPostgreSQL
Saby_ExplainforSaby Explain Blogsabyexplain.hashnode.dev·Oct 24, 2024Best Practices for Bulk Optimization of Queries in PostgreSQLAfter reading this article, you’ll learn about the techniques we use to analyze SQL query performance when dealing with millions of queries per day and monitoring hundreds of PostgreSQL servers. We’ll talk about Saby Explain, a tool that helps us han...DiscussPostgreSQL
Saby_ExplainforSaby Explain Blogsabyexplain.hashnode.dev·Oct 23, 2024Decoding EXPLAIN: How to Uncover Its Hidden MessagesThis standard question always comes up when developers and business owners consult with database administrators or PostgreSQL experts. It sounds like, “Why do database queries take so long?” These are the most common whys: ineffective query algorith...Discusspostgres
OBULIPURUSOTHAMAN KforTechnology With Obulipurusothamanobulipurusothaman.hashnode.dev·Oct 22, 2024Sql (vs) NosqlSQL (VS) NOSQL :One of the biggest decisions we make while designing a system is choosing between a Relational (SQL) or Non-Relational (NoSQL) database. Both have their strengths and use cases, but they differ significantly in their approach to data ...DiscussSQL
Nihira ShitapforSQL for the Data-Driven Worldsql-for-the-data-driven-world.hashnode.dev·Oct 8, 2024Best Practices : Know the SQL commands for Data ManagementIn today's data-driven world, the ability to manage, manipulate, and analyze vast amounts of data is a critical skill. SQL (Structured Query Language) is the backbone of database management systems (DBMS), empowering data professionals to extract mea...Discuss#SQLIndexing
Omar AshourforOmarAshouromarashour.hashnode.dev·Oct 1, 2024Database indexingWhen it comes to database performance, optimized and fast queries are essential for efficient data retrieval and manipulation. In today's data-driven world, where applications often handle massive amounts of information, the speed at which a database...Discuss·1 like·82 readsSQL
Rajat SrivastavaforStackUpstackup.hashnode.dev·Sep 15, 2024Efficient Database Lookups: Checking if Email Exists in Millions of RecordsIntroduction Imagine this: Your apps user base has grown rapidly overnight. Suddenly, your fast user registration system is slowing down. The problem? A simple email check to see if a new user's email is already in the database. What used to take mil...Discussbackend
Asfia AimanforAsfia Aiman's blogasfiaaiman.hashnode.dev·Jul 23, 2024Mastering Laravel Debugging: Understanding Query LogsOptimizing and debugging database queries is crucial for building efficient and scalable applications. Laravel makes this process straightforward with its robust query-logging features. Here’s a detailed guide on how to enable and inspect query logs ...Discuss·1 likequery-optimization
Victor OhachorforZero-Stack Engineerzerostackengineer.hashnode.dev·Jul 9, 2024Optimizing Query Performance in SnowflakeOverview Snowflake's architecture is made up of three (3) layers: storage layer, compute layer, and cloud services layer. The cloud services layer has query optimization built into it, which helps whip out some caveats in your queries to yield quicke...DiscussByteBite Wisdomsnowflake