Nahid Akhtar

🧩 Sharing a summary of what I have learnt today.
🗓️ Date: 01-11-24
❓ About: RDS Proxy
Summary:
1. Manages RDS/Aurora DB connection pools.
2. Establish, maintain and terminate connections.
3. Can build a target groups with multiple DB instances and let RDS proxy to maintain load and balances across the instances.
4. Reduces DB instance workload by removing overheads.
5. IAM authentication can be applied, what increases security.
6. RDS proxy prevents DB to be publicly accessible. Must access from VPC.

Use Cases:
1. If you have a large fleet of applications that are using single one or fewer DB instances, then it will be hard to maintain DB connection pools. Sometimes we may have faced such problems while setting up DB connection pools from application end. Though we can manage it from application but it is always at some extent, there can be fail-over. So, to maintain more reliability and less fail-over we set a Proxy in middle. It reduces about 66% fail-over.
2. If we are using a good amount of lambda to manage our business logic and other application staff, then it will be a great concern to maintain and to keep in limit the number of DB connections. So, in such case we can setup a Proxy to protect our DB from overwhelming number of connections and maintain a fewer connection to DB instance from proxy.

hashtag hashtag hashtag

Send a message to learn more

A few days ago. I took a dive into caching. I found it difficult to get necessary information about various caching topics and how to implement them with python. So I have decided to make it easy for others to get that information about caching. So, here is my first blog on Caching.
Contents: Basic understanding of caching, Popular caching policies and implementation with python, streamlit caching implementation with python.
You can read it from my medium account:
https://nahid-ibne-akhtar.medium.com/start-caching-with-python-basics-caching-policies-and-streamlit-caching-with-python-b4d31fc07c04
You also find it on vivasoft blog:
https://www.vivasoftltd.com/start-caching-with-python-basics-caching-policies-and-streamlit-caching-with-python

Nahid Akhtar Send a message to learn more

A few days ago I intended to transfer some money from my bank account to bkash account, My bank account deducted the money successfully but It was not deposited in my bkash account, I waited for half an hour and contacted the bkash help center. They refunded the deduced money in my bank account.

So, what is the problem do you think happened here?
It was a failure of transaction. For a successful transaction, the system(sender, receiver) has to ensure some criteria.

What are those criteria ?
These criteria are shortly said as "ACID".

The photo has been taken from Very Academy

https://blog.iron.io/how-we-went-from-30-servers-to-2/

How We Went from 30 Servers to 2: Go | The Iron.io Blog We were a consulting company building apps for other companies and there were two really hot things at that time: Amazon Web Services and Ruby on Rails.

Trade-offs for Monoliths and Microservices | Vivasoft Limited When developing an application, we as software engineers face different types of architecture for building an application. Among them, Monoliths and Microservices are considered to be the latest trends. When designing an application, we can consider both, monolithic or microservice-based architectur...

Learning basics of Docker, how to build Django projects on docker or Dockerize existing Django projects. Thought to create a basic cheat sheet for it. Please have a look at this.
If you have any suggestions for me, please feel free to mention them. And, It would be great, If you tell me or suggest to me any resources about using Docker in production and real DevOps environment.

Django App on Docker or Dockerize Your existing Django App on Windows 10. In this article we will be learning the simplest way to built django application on docker and also see how to dockerize the existing…

The page was keep notifying me that it is long you have not posted anything and I also have to remember this cz I forget passwords. 😑😑😑😑😑😑

I forgot my mysql shell's login password. If you have the same problem of not able to memorize the password for your local mysql shell then this is how you can reset it.

*If MySql is running then stop it from services(search at the window services, then right click on the mysql57/ mysql(Your version) and stop.

*Go to any root directory(Example: F:\)of your PC and create a text file. Inside the text file write down the following command:

USE mysql;
UPDATE mysql.user SET Password = PASSWORD('Your new Password') WHERE User = 'root';
FLUSH PRIVELEGES;

*save the text file.

*Now find the my.ini file. Generally it is in following file directory.
C:\ProgramData\MySQL\MySQL Server 5.7\my.ini

*Then go to the bin directory of the installed MySQL. For me it was-
C:\Program Files\MySQL\MySQL Server 5.7\bin

*Now open command prompt in the bin directory.
This is how You can open command prompt at any folder:

1. Go to your desired folder and click on the location bar of Windows Explorer.
2. Then type cmd and press Enter key.
3. The command prompt will be opened in the folder.

*Now in the command prompt, You have to type the following command:

mysqld --defaults-file="my.ini file's file path(Example: C:\ProgramData\MySQL\MySQL Server 5.7\my.ini)" --init-file=F:\name of text file you have created at the root directory.txt

*After entering the command, if there is a return message like "mysqld starting as process....." then you have to go the task manager and end task the process named "mysqld.exe"
If there is not any returned message and ready to take a new command then you dont have to do anything.

*Now go to your MySql shell and login with your reset password.
Thank You.

This is about a simple Login and Registration system using Flutter and http Post method of RESTful-API. I have used reqres to test the system. Going through you will get a basic concept about the topic.

Flutter Login, Register and Logout using Rest-API http Post request. In this article we will be implementing a simple login, register and logout system in flutter using http Post request. We will be using…

Written my first blog on "Flutter Assets Audio Player, A Guideline to Build an Audio Player Selecting Files From ‘assets’ Directory". From here you will get an introductory knowledge of implementing flutter's audioplayers library, extracting files from local assets directory and present that in a list through listview.builder() library. I have also resolved some issues regarding the implementation of the library on assets directory. This is my first blog on something, So, guys,,your review and suggestion will be very helpful and appreciated.

Flutter Assets Audio Player, A Guideline to Build an Audio Player Selecting Files From ‘assets’… Introductory guide for flutter’s audioplayers library to create a local assets directory audio player and how to deal with multiple mp3…