41 articles found under 'guides'

Jan 2, 2025 , updated on: Jan 3, 2025

How to use MySQL Binary Logging to Update Site Incrementally?

Let me show you how to update a site incrementally by making use of MySQL/MariaDB binary logs. Learn how to use the mysqlbinlog/mariadb-binlog utility effectively to replicate changes to a remote database from a local staging area.

Dec 17, 2024

5 Major Sorting Algorithms

Some of the popular sorting algorithms, how they work, and their time complexity, space complexity, and stability.

Dec 11, 2024

What is a Database, by the way?

Ever wondered what a database actually is? What's the difference between database and database management system? SQL vs. NoSQL? This article tries to demystify those questions.

Dec 10, 2024

How to master SQL? What all things to learn?

SQL - Structured Query Language is the language to interact with relational databases including MySQL, MariaDB, PostreSQL, and MS SQL. Here is a list of the topics you may need to learn in order to master it, from beginner level to advanced.

Aug 26, 2023 , updated on: Sep 11, 2023

OAuth Demystified & What is OAuth & How it Works

OAuth is a mechanism that allows authorizing applications with popular providers like Google, Facebook, etc. Here is a deep dive into how it works behind the scenes.