Postgresql find foreign key references and reset primary key serial without truncate table
in this blog post i will try to explain how to find Postgresql foreign key references and reset primary key serial.
now question is why we need to find Postgresql foreign key references and reset primary key serial ?
sometime we have a scenerio where we need to reset the primary key for business need at
Date: July 22, 2022, 8:57 am Author: Akram Hossain
Given n names and phone numbers, assemble a phone book that maps friends' names to their respective phone numbers.
You will then be given an unknown number of names to query your phone book for.
For each named queried, print the associated entry from your phone book on a new line in the form name=phoneNumber;
if an entry for name is not found, print Not found instead.
Note: Your p
Date: June 25, 2022, 7:20 am Author: Akram Hossain
implement hesabe payment gateway in Nodejs using Typescript
in this blog post i will try explain how to implement hesabe payment gatway in Nodejs using Typescript.
At first we will install two npm package hesabe-crypt-ts and aes-js.
to install this two packages run the following command
npm i -S hesabe-crypt-ts then
npm i aes-js
we have to import this two package on our typescript file as be
Date: June 20, 2022, 1:38 pm Author: Akram Hossain
Serverless architecture initiate cost-effective image processing in the AWS Cloud.
The architecture combines AWS services with Sharp open-source image processing software and is optimized for dynamic image manipulation.
Follow the step-by-step instructions in this section to configure and deploy the Serverless Image Handler into your account.
at first Launch the stack
Log in to the AWS Manag
Date: April 13, 2022, 11:10 am Author: Akram Hossain
Cron is a scheduling system for POSIX computers
Minute Hour Date Month Weekday
10 * * * * At the 10th minute of every hour of every day
*/10 * * * * Every 10 minutes
10 14 * * * At 14:10
10 14 1 * * At 14:10 on the first day of the month
10 14 15 1 * At 14:10 on 15 January
0 2 15 10 * At 2 AM on 15 October
0 3 * 10 0 At 3 AM on all Sundays in October
0 3 * 10 1 At
Date: April 2, 2022, 12:52 pm Author: Akram Hossain
Steps to Clone an AWS instance
Log in to the AWS Management Console.
From top bar, Click on Services menu, search for EC2, Now click to EC2.
Next screen, Click Instances, from instances list select an instance, Click Actions Button
Now click on Create image, Next screen fill up the form with required details and click on Create image Button
this will redirect to Amazon Machine Images (AM
Date: February 23, 2022, 1:24 pm Author: Akram Hossain
Below is the example of how to write CASE Statement & Nested Case in SQLSELECT
when order_items.vat_charges > 0 then (order_items.price * order_items.quantity)/(1+(order_items.vat_charges/100))
else (order_items.price * order_items.quantity)
end as website_price_total,
when shops.shop_id = 24 then
when order_items.vat_charges > 0 then (order_items.cost_price * o
Date: February 21, 2022, 5:19 am Author: Akram Hossain
Given an array,A, of N integers, print A's elements in reverse order as a single line of space-separated numbers.
Print 4 3 2 1. Each integer is separated by one space.
The first line contains an integer,N(the size of our array).
The second line contains N space-separated integers that describe array A's elements.
Date: January 4, 2022, 11:33 am Author: Akram Hossain
Razorpay is the only payments solution in India that allows businesses to accept,
process and disburse payments with its product suite.
It gives you access to all payment modes including credit card, debit card, netbanking,
UPI and popular wallets including JioMoney, Mobikwik, Airtel Money, FreeCharge, Ola Money and PayZapp.
Now we will try to integrate Razorpay in Yii2 application.
Date: December 28, 2021, 12:58 pm Author: Akram Hossain
Hacker Rank: Day 6: Let's Review
Given a string,S, of length N that is indexed from 0 to N-1, print its even-indexed
and odd-indexed characters as 2 space-separated
strings on a single line (see the Sample below for more detail).Note: 0 is considered to be an even index.
s = abdecf
Print abc def
The first line contains an integer, T(the number of test cases).
Date: November 20, 2021, 4:12 pm Author: Akram Hossain
In this blog post i will try to describe how to implement SMSBOX sms gateway in Nodejs application. to implement SMSBOX into any Nodejs application you
will need a SMSBOX account, you can register for new account at https://www.smsbox.com/
which is not free.Upon registration SMSBOX will provide you username and password to login to SMSBOX control panel.
After login to SMSBOX dashboard, Under le
Date: September 6, 2021, 5:45 pm Author: Akram Hossain
Sharp High performance Node.js image processing library.
It is 4x to 5x faster then ImageMagick and GraphicsMagick.
We can convert any larger image to any common format such as png, gif, jpeg, webp.
Also we can modify image dimension on the go without modifying actual image.
Any systems running Node.js v10+ do not need any additional install or runtime dependencies.
Date: July 10, 2021, 5:35 pm Author: Akram Hossain