How to execute multiple queries in the backend Mysql database through PHP computer programming language

Communication with a backend database management system gets easier due to the specific support for the task by different computer programming languages. One of the many languages which supports connection with a database and interaction with it is PHP, a computer programming language which is used to write applications for the web.

Having experimented lately with the PHP computer programming language, I decided to share my experience with it so far. Through this blog post you will learn how to execute multiple sql queries in a Mysql database by making use of a custom PHP script.
Continue reading “How to execute multiple queries in the backend Mysql database through PHP computer programming language”

How to write a python script which communicates with the MySQL server

Python is a very useful utility when it comes to scripting automatic tasks. When interacting with a database management system in the backend, Python is my favorite programming language to automate the job. Through this blog post, I am going to teach you guys how to automate the process of interacting with a MySQL server by sharing the Python code which I have written for my personal usage.
Continue reading “How to write a python script which communicates with the MySQL server”

Sql commands you should know as a computer geek

Being a computer geek, there is a lot of information to learn each day it passes. Lately I am experimenting a little with the structured query language, a language which is a domain specific one. According to the information shared on Wikipedia, sql is a language which is being put to use to manage data in a relational database management system.
Continue reading “Sql commands you should know as a computer geek”

How to connect to mysql with python

Being a Python geek, lately I am experimenting with database oriented applications. Building the projects from scratch, I am making use of the Mysql server as the database management system in the backend.

For those of you geeks who have no idea, Mysql is an open-source relational database management system that can be automatically populated with data through the structured query language known as SQL.
Continue reading “How to connect to mysql with python”

How to make use of the Python pytube tool to download videos from YouTube

Introduction to the pytube tool

pytube is a python package written for the main purpose of downloading videos from the famous video website Youtube. According to the official documentation there are no third party dependencies to this tool, in other words it is a standalone package making use of the standard python libraries. Continue reading “How to make use of the Python pytube tool to download videos from YouTube”

A simple introduction to the fuser utility for linux geeks

What Is The fuser Command?

The fuser command is a very smart unix utility used to find which process is using a file, a directory or a socket. It also gives information about the user owning the process and the type of access. The fuser tool displays the process id(PID) of every process using the specified files or file systems.
Continue reading “A simple introduction to the fuser utility for linux geeks”