Monitoring Oracle Database using Python

Posted on by Ahmed Abdel Fattah

In this video I'll navigate around an application that I built using Python to monitor the oracle database performance. The main packages that I used to build this application are: Streamlit, Pandas and plotly. In the future, I may share how I built this application in detail, but here I just need to highlight that … Continue reading Monitoring Oracle Database using Python

Simple Way to display Tabular data in Python

Posted on by Ahmed Abdel Fattah

Here below is a simple program to display data (list or list of dictionaries) in a tabular format using the "tabulate" package. This is the required output: Prerequisites: If you don't have the "tabulate" package installed, you can install it using: pip install tabulate The Program: Following is the program code: Sample Run: Following is … Continue reading Simple Way to display Tabular data in Python

Python Script to Track Coronavirus in Your Country

Posted on by Ahmed Abdel Fattah

covid is python package to track the Coronavirus spread in your country.It requires Python 3.6 or later.To install this package: pip install covid Following is a sample script to use this package to track coronavirus numbers for specific country ( here I use Egypt with id=71 as an example): Following is a sample output for … Continue reading Python Script to Track Coronavirus in Your Country

Python Script to format the output of one SQL statement

Posted on by Ahmed Abdel Fattah

I received a text file from a client that contains the output of one sql script (The output represents detailed statistics about all sql statements running in one critical database). The output is similar to the following: You can download a sample file similar to that of our client from:https://1drv.ms/u/s!ArrpKxPFc2APxRw0izNXIYqVHGdw?e=UCgUBs The output is not formatted … Continue reading Python Script to format the output of one SQL statement