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”

An introduction to CherryPy, a lightweight Python web framework

CherryPy is an open source, fast, and stable python web framework that allows the developers to build the web applications. The developers can build the web applications as the way they would build the other object-oriented python programs. Many developers still haven’t heard this simple, Continue reading “An introduction to CherryPy, a lightweight Python web framework”

How to write a Python script to grab banners for network geeks

Lately i haven’t posted much because i have been busy working on some programming projects, but today i will share a python script with you guys. This script is written in pure python and it can be used to grab banners from different services running on your subnet. Some of these services are SSH, Telnet, FTP, SMTP etc.

This script is useful to system administrators to check their services and penetration testers to check the service for different vulnerabilities. We use the socket library, Continue reading “How to write a Python script to grab banners for network geeks”