How To Install php-sql-formatter on Ubuntu 18.04
Introduction
In this tutorial we learn how to install php-sql-formatter on Ubuntu 18.04.
What is php-sql-formatter
php-sql-formatter is:
SqlFormatter is a lightweight PHP class to format SQL statements. It can automatically indent and add line breaks in addition to syntax highlighting.
There are three methods to install php-sql-formatter on Ubuntu 18.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install php-sql-formatter Using apt-get
Update apt database with apt-get using the following command.
sudo apt-get update
After updating apt database, We can install php-sql-formatter using apt-get by running the following command:
sudo apt-get -y install php-sql-formatter
Install php-sql-formatter Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install php-sql-formatter using apt by running the following command:
sudo apt -y install php-sql-formatter
Install php-sql-formatter Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install php-sql-formatter using aptitude by running the following command:
sudo aptitude -y install php-sql-formatter
How To Uninstall php-sql-formatter on Ubuntu 18.04
To uninstall only the php-sql-formatter package we can use the following command:
sudo apt-get remove php-sql-formatter
Uninstall php-sql-formatter And Its Dependencies
To uninstall php-sql-formatter and its dependencies that are no longer needed by Ubuntu 18.04, we can use the command below:
sudo apt-get -y autoremove php-sql-formatter
Remove php-sql-formatter Configurations and Data
To remove php-sql-formatter configuration and data from Ubuntu 18.04 we can use the following command:
sudo apt-get -y purge php-sql-formatter
Remove php-sql-formatter configuration, data, and all of its dependencies
We can use the following command to remove php-sql-formatter configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge php-sql-formatter
References
Summary
In this tutorial we learn how to install php-sql-formatter package on Ubuntu 18.04 using different package management tools: apt, apt-get and aptitude.
