Published inLevel Up CodingWhy Knowing TOAST in PostgreSQL is necessary for Backend Devs!PostgreSQL’s TOAST manages large data values. This article explains TOAST, its supported data types, storage strategies (PLAIN, EXTERNAL…2d ago2d ago
Published inLevel Up CodingCan We Test Postgres at the Database Level? From Functions to Indexes, Here’s How!When working with complex database features like triggers, functions, and indexes, testing at the database level can boost reliabilityJan 71Jan 71
Published inLevel Up CodingFull-Text Search in PostgreSQL: Backend Developer Guide — Part 2In Part 2, learn to leverage Trigram indexes, use the similarity function, rank search results effectively, and highlight matches directly…Dec 27, 2024Dec 27, 2024
Published inLevel Up CodingFull-Text Search on PostgreSQL: Backend Developer Guide — Part 1Unlock the power of PostgreSQL full-text search! This article dives into how full-text search works, why B-Tree indexes fall short, and…Dec 15, 2024Dec 15, 2024
Published inLevel Up CodingPostgreSQL Shared Buffer, What Backend Developers Should KnowFor us as Backend Developers it is important to find the optimal amount for shared_buffers depending on the machine resources.Dec 2, 2024Dec 2, 2024
Published inLevel Up CodingNumber of System Calls in a Simple Nodejs Read FileHow many system call are we making for reading a file and logging it to the Console?Oct 13, 2024Oct 13, 2024
Published inLevel Up CodingPostgreSQL Clustered Index: When to Use? Does it Worth?PostgreSQL Clustered Index is an operation that let you reorder the table on the disk and helps optimize your table for specific queries.Oct 6, 2024Oct 6, 2024
Published inLevel Up CodingHow MongoDB Time Series Collection Works Under the HoodIn this article, we delve into the inner workings of MongoDB’s time series collections, exploring how they efficiently store and manage…Jun 3, 2024Jun 3, 2024
Published inLevel Up CodingBehind the Scenes of useState: Implementation InsightsIn this article we want to answer the question of how the useState hook is implemented. In the first section we take a look into the…Apr 14, 2024Apr 14, 2024
Published inLevel Up CodingCould Converting Nodejs Functions to C++ Add-On Boost Your Code PerformanceWe learn how to create a C++ add-on and we answer an important question!Mar 24, 20241Mar 24, 20241