Load very large file in the MySQL database table using mysql in built bulk load utility and python and using a very local computer. I am using 8 GB of RAM and 4 core domestic processor. Step 1: Install required libraries:Python library required: mysql-connector-python Step 2: Setting the variables: Note: I am using IMDB dataset… Continue reading Load huge or large files into MySQL database
Blog
PDF manipulation with Python: Part 1
Under the hood If you are a coder and comfortable with python, there are many libraries by which you can manipulate PDF file as your own wish. Here are some list of python library which can be used to create or edit PDF files: PDFMiner – This tool is to extract text data from a… Continue reading PDF manipulation with Python: Part 1
Scraping YouTube with BeautifulSoup and Python3
There are few ready made YouTube video download library present in python already. “youtube-dl” is one of them which is very convenient to use. It also has command line interface (CLI) to download video from YouTube hence you do not need to use python code to download video. This article is for some more details.… Continue reading Scraping YouTube with BeautifulSoup and Python3
Build your own email tracker using PHP-MySQL
Sometimes tracking email is useful to know if the recipient received an email and whether they opened the same. There are some free and paid solution is already available in the market. In this post, I am writing to describe the strategy of tracking email using popular technology PHP and MySQL database. Use Cases Email… Continue reading Build your own email tracker using PHP-MySQL
Some cool yet advance and hidden features of Python
Python has really some great features which make some tasks easier to write from the coding perspective. Sometimes these features called as hidden features as these are either very unique to Python or not very well known. For…Else loop Comparison operator chaining Slicing/Extended slicing Multiple Assignment Value Swapping Argument unpacking / Star operator Yield Statement… Continue reading Some cool yet advance and hidden features of Python
Download image from Instagram Post Link
Instagram doesn’t allow you to download an image from the app or its website. Even on the website, you can’t get the image related options in the context menu(right-click): There are few ways to get the image from the Instagram. I am going to describe the easiest way of doing the same. Get the post… Continue reading Download image from Instagram Post Link
Prevent GNOME auto sleep
Recent update in Kali linux is having one problem with the auto suspend operation. Even the power settings are perfect (Automatic suspend = Off), the computer sleeps every 20 minutes. Steps to perform to disable auto sleep: Search for below parameters, uncomment if commented. Set the value to 0. Once done, run below command to… Continue reading Prevent GNOME auto sleep
AWK commands equivalent to SQL query – Data manipulation
Introduction Data Warehouse and Business Intelligence involves all about data handling for business insights, we often very much rely on the SQL query to do data analysis and analytics. We can achieve the same through some BI tools as well. But if we are comfortable with SQL then I am sure that you will prefer… Continue reading AWK commands equivalent to SQL query – Data manipulation
Few online free tools
Here is the list of few online tools you can use for free. They have premium option as well for advanced features. But these tools are very user friendly, free, watermark free and useful on the go. Photo design / Infographics editor / photo editor There are lots of options available over the internet. https://www.canva.com/… Continue reading Few online free tools
Class mysqli not found error after upgrading to php 7.3
The problem seems to be related to the fact that after PHP 7.2 or PHP 7.3 is installed, the version of PHP 7.0 still continues to be used. And in spite of the fact that extensions, for example such as php7.0-mysql, do not disappear from the system, but they cease to be picked up by the PHP… Continue reading Class mysqli not found error after upgrading to php 7.3