Creating Async Chained Tasks in C#

Scenario :  Want to design a c# controller with following feature. # User will submit a request and system update the database with a status immediately . # System will run some command line to sync source and destination folder which may take hours to complete. # Once the command line copy / sync process… Read More »

Google Collab Alternative Jupyterhub run from Home

Scenario : Want to install jupyter notebook from a single machine and can be utilized by more than 50 users at a time. This can be a ideal solution for schools or python lab where students or users can access from anywhere using their own devices. We have a windows 10  machine with Desktop /… Read More »

Testing Concurrent Connections to MySQL Server using script

Scenario : You want to test number of allowed parallel connections to your mysql Server . Steps: Create a Database Create a Table Create a PHP insert Script Test the Script Use ab.exe tool from apache.   Create a  table CREATE TABLE `test_table` ( `id` int(11) NOT NULL, `session_id` varchar(250) DEFAULT NULL, `date_time` timestamp NULL… Read More »

View Cpanel MySQL data from Excel Sheet

Scenario : You have online website with MYSQL Database and you want to see the live data in excel sheet. Solution : Create a MY SQL User account Give permission for Select query to the specific database Allow remote sql access permission to your ip address Download the .net connector for MYsql for Windows Configure… Read More »

Function for Reverse Geocoding – HTML and Jquery Based

Reverse geocoding is the process of converting geographic coordinates into a human-readable address. Features : This function accepts the Longitude and latitude and output the city and country name as accurate as possible using Google reverse geo coding. Advantage : this works directly from Javascript , Jquery and HTML so no programming or server required. Asynchronously… Read More »

Exporting Windows 10 Saved Credentials

Scenario : We have couple of PC’s in network and forgot the password for one shared network drive. One machine we formatted and we want to add the shared network drive , however we have no password. Solution : Backup the saved windows credentials from any working machine and Restore it on the fresh windows… Read More »