Forem: Ismail

Reduce your AWS S3 cost

Ismail — Wed, 26 Apr 2023 20:16:18 +0000

🚀 Introducing s3-abort-multipart-uploads: A Time and Cost-Saving Tool for AWS S3!

Are you tired of dealing with incomplete multipart uploads in Amazon S3? open-source project helps you clean up your storage and reduce costs with ease.

🌟 Key Features:

Automatically aborts incomplete multipart uploads in S3
Improves storage usage and lowers costs
Easy to deploy in AWS CloudShell

🔗 Explore the code and contribute on GitHub: https://github.com/richtechteam/s3-abort-multipart-uploads

SQL query optimization, 3 min to 0.5 sec

Ismail — Wed, 29 Mar 2023 10:57:05 +0000

Today, I was working on an SQL query and managed to optimize it. Previously, it took almost three minutes to run, but after optimization, it now takes only 0.5 seconds.

To achieve this optimization, I converted some of the sub-queries into joins. This is because sub-queries tend to take a lot of time when dealing with large amounts of data.

Generate Dynamically months array in PHP

Ismail — Tue, 07 Feb 2023 08:20:22 +0000

if date is 2023-02-07 then run only till to feb
if date is 2022-06-12 then run loop only till to June if date is 2022-12-31 then run till to dec

$selected_date= "02/07/2022" // d/m/Y
$selected_month_number = date('n', strtotime($selected_date));
$selected_year = date('Y', strtotime($selected_date));

$months = array();

for ($i = 1; $i <= $selected_month_number; $i++) {
    $month_name = date('M', strtotime("$selected_year-$i-01"));
    array_push($months, $month_name);
}
 print_r($months);
//  Out put will be Array ( [0] => Jan [1] => Feb )

Google map how to show city boundaries

Ismail — Sat, 21 Jan 2023 09:18:25 +0000

I recently worked on a project where I had to show city boundaries on a Google Map, and it was not an easy task. However, I was able to figure it out and complete the project successfully. If you're interested, you can check out my article on how to display city boundaries using Google Maps. It goes into detail on the process I followed and the challenges I faced.

https://richtech.io/google-map-show-the-city-or-any-area-boundaries-on-map/