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 »

Create Custom AJAX contact submit form for Mobirise

Mobirise Website Builder is a freeware web design application, developed by Mobirise, that allows users to create and publish bootstrap websites, without coding. Mobirise is essentially a drag and drop website builder, featuring various website themes. It is lacking the feature of using own form processing functionality as most of us wish to use own… Read More »

Convert Python into EXE file

Scenario : We want to convert a python application into standalone windows application.   Required Package :   https://pyinstaller.readthedocs.io/en/stable/   What is Pyinstaller : PyInstaller bundles a Python application and all its dependencies into a single package. The user can run the packaged app without installing a Python interpreter or any modules. PyInstaller supports Python 2.7 and Python 3.4+,… Read More »

Portable kepler.gl

Requirement: Implement Kepler in a portable way so that it can be used without installation in any windows x64 computers.   What is Kepler? Kepler.gl is a tool designed for geospatial data analysis. This guide will help you get started creating visualizations in kepler.gl Map Enthusiast? Make beautiful data-driven maps. Data Scientist? Gain insights from… Read More »