ZackinLevel Up CodingRecovering with Confidence: A Deep Dive into DBMS Recovery Managers and Recovery AlgorithmIntroducing what the recovery manager is, the data structure of log files, and one of the most famous recovery algorithms: ARIES.May 18, 2023May 18, 2023
ZackinLevel Up CodingThe syntax of URLs: Decoding All Those %$#@! SymbolsThis article provides a comprehensive overview of the syntax of URLs, breaking down each component and its function in web addresses.Apr 25, 2023Apr 25, 2023
ZackinJavaScript in Plain EnglishTransforming Your Data: A “more lazy” way to add double quotes into your javascript “JSON”.Introducing an easy way to convert JavaScript Object into JSONApr 20, 2023Apr 20, 2023
ZackinLevel Up CodingMaximizing Data Retrieval Efficiency: how does the basic tree structure affect DBMSIntroducing tree-based indexing in current DBMSApr 18, 2023Apr 18, 2023
ZackinLevel Up CodingExploring the Role of Hash-Based Indexing in Modern Database ArchitectureIntroducing one of the most popular indexing techniques: hash-based indexing, explaining its different types and their structure.Apr 7, 2023Apr 7, 2023
ZackinLevel Up CodingEfficient Data Management with a Buffer Manager: Exploring the Heart of Database SystemsIntroducing what is buffer manager in DBMS and the strategy it uses.Apr 7, 2023Apr 7, 2023
ZackinJavaScript in Plain EnglishBoosting Redux Performance with Memoized Selectors: Best Practices and Implementation TipsIntroducing what is memoized selector, why we need it, and how to implement it.Mar 18, 2023Mar 18, 2023
ZackWhy You Should Think Twice Before Using console.log, and Tips for Avoiding Performance PitfallsHow does console.log affect your application performanceMar 15, 2023Mar 15, 2023
ZackinLevel Up CodingUnderstanding the Autovacuum Process in PostgreSQL: Everything you need to knowIntroducing autovacuum in PostgreSQLMar 8, 2023Mar 8, 2023
ZackinLevel Up CodingThe Magic of VACUUM: Keeping Your PostgreSQL Database in Top ShapeIntroducing what VACUUM is in PostgreSQL, what it does, and also the difference between regular VACUUM and VACUUM FULL.Feb 27, 2023Feb 27, 2023