Blog


MySQL like any other database has its own pros and cons, you can find them on the web easily, here are a couple Pros & Cons of MySQL Blob’d Images or Pros and Cons of MySQL In this blog I will talk about INNER JOIN vs. IN and LEFT JOIN vs. NOT IN, you can also swap this Read more…


As promised from my previous blog “Converting Data Attribute to Table Attribute Part I”; here is the MySQL code demonstration. First, let us create the two tables and populate them with some data DROP TABLE IF EXISTS users; DROP TABLE IF EXISTS user_attribute; CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(128), first_name VARCHAR(255), Read more…


WHAT IS THIS ALL ABOUT? Sometimes there is a need to create dynamic tables or views with variable field structure; In this post, I’m going to explain how to convert data attributes into table attributes; data attributes are values in table field; TABLES STRUCTURE WE HAVE Users table id Username Firstname lastname 1000 Jkhar Jasim Khar 2000 Read more…


In this blog, I will walk you throw an example of how to migrate data from csv file into MySQL, this is not the only way you can do this but I found this simple and easy in the case I was handling Data migration/conversion goes throw the following: – 1. data preparation: loading data from files Read more…


Introduction In most businesses, data migration/conversion becomes a necessary routine and is something that we deal with on a regular basis. To add to the problem, most business systems now hold far more data than in previous years and so there is far more data that need to be moved. Furthermore, many databases and information stores are Read more…


I’ll try to explain the situation here as much as I can; we have a .net web app that uses MySQL as the backend database; database size is about 250GB and has 130GB of memory; the app is multi-tenant; one of the app components is a windows services that runs continuously loading data based on newly added Read more…


Over the last several years and as I grew in my field, I’ve been observing and watching how I manage and lead different teams and compare myself with other managers and leaders; I have learnt a lot from great managers and leaders over those years but again no one is perfect including myself! Some managers that I Read more…