About Me

I have decades of experience is software development using .Net Technologies, PHP and wordpress. I love coding and discovering new tech.

Tag: Database

Code Improvement, Coding, Database Management

The Timeless Utility of Flat Files: Advantages and Challenges

Posted on August 2, 2024  - By Kaustav Halder - 0 Comments

Flat files, the simplest form of data storage, have been a cornerstone of computing for decades. Despite the rise of sophisticated databases and advanced storage solutions, flat files continue to hold their ground in many applications. Let’s delve deeper into...

Code Improvement, Database Management, Uncategorised

How to Split a String in MySQL Using the SPLIT_STR Function. The Right Way!

Posted on June 27, 2024  - By Kaustav Halder - 0 Comments

When working with strings in MySQL, there may be times when you need to split a string into individual components based on a delimiter. For example, you might have a comma-separated list of values and need to extract a specific...

Database Management

De-Dupe Your Database: Mastering MySQL’s Tools for Duplicate Removal

Posted on May 10, 2024  - By Kaustav Halder - 0 Comments

Welcome, fellow data enthusiasts! Today, we’re going to tackle a common yet pesky problem that plagues many a database: duplicate records. Fear not, for I shall guide you through the process of removing these unwelcome guests from your MySQL tables...

Coding, Javascript

Saving data to browser local storage using javascript

Posted on September 14, 2022  - By Kaustav Halder - 0 Comments

How to save data on browser local storage for your HTML Website? Overview As website developers, every now and then we come across instances when we need to store some information and want it to persist through out the site....