Buka Corner

Sign in Subscribe

Latest

How to Use Hash Functions in Google Sheets: SHA256, MD5, and Beyond

How to Use Hash Functions in Google Sheets: SHA256, MD5, and Beyond

Hashing is a common technique used in software development to generate unique identifiers, verify integrity, or anonymize data. If you're working inside Google Sheets, you might wonder: can I create a hash like SHA256 or MD5 directly in a spreadsheet? The short answer is: not natively, but with

How to Detect Duplicate Values in MySQL Tables: A Practical Guide

How to Detect Duplicate Values in MySQL Tables: A Practical Guide

When working with relational databases, one of the most common data integrity challenges is the presence of duplicate values. Whether you're importing data from spreadsheets, syncing between environments, or simply dealing with legacy data, duplicates can silently degrade the accuracy and trustworthiness of your application. In this article,

Why Your Internal System Should Use Internal IDs (Not External Auth IDs)

Why Your Internal System Should Use Internal IDs (Not External Auth IDs)

Many systems today integrate with external identity providers—services that handle user authentication and issue secure tokens for login. These providers typically return a unique user identifier (like an external_oid, sub, or auth_id) with each session. It might seem convenient to use these external identifiers as the primary

How to Prevent Downtime During Docker Compose Deployments

How to Prevent Downtime During Docker Compose Deployments

Deploying updates to containerized applications using Docker Compose is a common practice in modern software delivery pipelines. However, a simple mistake in the deployment script can cause unwanted downtime, interrupting services for end users. This article explores how to structure your Docker Compose deployment process to avoid downtime, with a

How to Schedule Cron Jobs in a Specific Timezone (e.g., 7AM UK Time) — A Complete Guide

How to Schedule Cron Jobs in a Specific Timezone (e.g., 7AM UK Time) — A Complete Guide

When working with scheduled tasks in Linux using cron jobs, the default behavior is to follow the system timezone. However, when your application or team operates in multiple timezones — or you simply want to schedule tasks based on UK local time (such as 7 AM London time) — things can become

PHP sleep() vs usleep(): What's the Difference and When to Use Each

PHP sleep() vs usleep(): What's the Difference and When to Use Each

When working with time delays in PHP, you'll often encounter two functions that seemingly do the same thing: sleep() and usleep(). While both are used to pause code execution, they differ significantly in precision, unit of time, and appropriate use cases. This article breaks down both functions in

Understanding the Difference Between Content Scripts and chrome.scripting in Chrome Extensions

Understanding the Difference Between Content Scripts and chrome.scripting in Chrome Extensions

When building a Chrome Extension, one of the most common tasks is injecting JavaScript into web pages. There are two main approaches to do this: 1. Using content scripts declared in the manifest. 2. Using the chrome.scripting API to inject scripts dynamically. At a glance, both seem to do