How to Install Sublime Text on Ubuntu 24.04
Sublime text editor can be installed using Sublime’s repository, Snap Store, or the flatpak/flathub. Read out this post for details of each method.
How to Install Google Earth on Ubuntu 24.04
To install Google Earth on Ubuntu or any Linux distro, get the package file from the downloads page and install it using the package manager to install it.
How to Install RealVNC Viewer on Ubuntu 24.04
To install RealVNC Viewer on Ubuntu 24.04, download the “.deb” package file and use the “apt” or the “dpkg” command(s) to install RealVNC from that downloaded file.
How to Run AppImage on Ubuntu 24.04
Get the libfuse2 library and then make the AppImage executable. Finally, run it from the terminal. Read this post to learn more about AppImage.
How to Use SCP Command to Securely Transfer Files
The SCP command uses the SSH protocol for authentication and connection. After establishing a connection, the source file/directory to the destination/target.
How to Install AWS CLI on Ubuntu 24.04
To install AWS CLI, use the snap command or pipx package manager. However, if you need the latest version of AWS CLI, you can directly download its zip file.
How to Install Conda on Ubuntu 24.04
Conda has two main distributions; Miniconda and Anaconda. Read this guide to install them, update, and remove Conda from Ubuntu 24.04.
How to Install and Configure SSH Server on Ubuntu 24.04
Learn an effective way to install the SSH server’s implementation on Ubuntu 24.04. Do check the post for the detailed configuration of the SSH server.
How to Install PostgreSQL on Ubuntu 24.04
To install PostgreSQL on Ubuntu 24.04, update the packages index, and install PostgreSQL along with the “postgresql-contrib” package.
How to Set Environment Variable on Ubuntu 24.04
To set the environment variable use the export command and to make it global place it in the /etc/environment file.
How to Install Anaconda on Ubuntu 24.04
To install Anaconda on Ubuntu 24.04, download its installer from the official website. Then, run the installer by using “sh
What is LIMIT Clause and How Does it Work in PostgreSQL?
LIMIT is an optional clause in PostgreSQL that is executed with a SELECT query to fetch only specific/limited records from a table.
What is DELETE CASCADE and How it Works in PostgreSQL?
“DELETE CASCADE” feature in Postgres ensures referential integrity by automatically deleting all child records when the corresponding parent record is deleted.
PostgreSQL NOW() Function | Check/Get Current Date and Time
The NOW() function returns the current date and time along with the time zone information. The returned data type of this function is “TIMESTAMPTZ”.
How to Find/Check Database and Table Size in PostgreSQL
To find the database and table sizes in PostgreSQL, the pg_database_size() and the pg_relation_size() functions are used, respectively.
How to Scroll in Ubuntu Terminal?
The keyboard shortcut key combinations like “Ctrl+Shift+Up”, “Ctrl+Shift+down”, “Shift+pgup”, “Shift+pgdn”, and “Ctrl+end” are used to scroll in Linux Terminal.
PostgreSQL UPDATE – How to Update Table Rows
To update the table values/data in PostgreSQL, the UPDATE command is used. This statement allows the user to update the previous data to new data values.
PostgreSQL SELECT – How to Select Table Records
In PostgreSQL, the SELECT statement is used with the FROM clause to get/fetch the required result from the specified table.
How to Rename the table in PostgreSQL
To rename a table in PostgreSQL, use the ALTER TABLE statement along with the RENAME TO clause. A table can be renamed manually using pgAdmin.
PostgreSQL INSERT – How to Insert New Rows into a Table
To insert values/rows into a Postgres table, use the INSERT INTO statement. The VALUE clause is used to specify the values that need to be inserted.
How to Add Primary Key Constraint to a Column in PostgreSQL
In Postgres, a Primary key can be added to a column during table creation. It can be added to an existing table using the ALTER TABLE ADD CONSTRAINT command.
PostgreSQL DELETE – How to Delete Table Rows
In PostgreSQL, the DELETE statement is used with the FROM clause to delete a single, multiple, or all rows of a specific table.
How to Create a Table in Postgres
To create a table in PostgreSQL, execute the CREATE TABLE statement either in pgAdmin or in psql. Postgres tables can also be created manually using pgAdmin.
How to Create a Database in Postgres
To create a database in PostgreSQL, execute the “CREATE DATABASE” command in the SQL Shell or pgAdmin. Users can also create databases manually using pgAdmin
How to Drop Columns From a Table in PostgreSQL
To drop/delete a column from a PostgreSQL table, we can use the ALTER TABLE statement and the DROP COLUMN clause together.
How to Drop a Table in Postgres
Execute the DROP TABLE command either in SQL Shell or in pgAdmin to drop a particular table in Postgres. A table can also be dropped manually using pgAdmin.
How to Switch a Database in Postgres
To switch a database in Postgres, execute the “\c db_name” or “\connect db_name” command in psql. Or you can switch a database manually using pgAdmin.
How Do I Mount a CIFS Share?
The CIFS share is mounted when the mount command is used with the cifs-utility. To automatically mount, credentials are added in the/etc/fstab file.
9 Linux Destructive Commands You Should Never Run
10 commands that can be destructive to Linux OS are explained in this blog, and users should avoid running these commands.
How to Reattach to an Existing “screen” Session?
To reattach an existing screen session, use the “screen” tool followed by the “-r(reattach)” argument and the “SID” or the “specific session name”.
What is gdm3, kdm, lightdm? How to Install and Remove them on Ubuntu?
gdm3, kdm, and lightdm are display managers of Linux that provide the interface for the login screen and can be installed or uninstalled.
[Fixed] “Hostname: Name or Service not Known” Error?
The error is caused when the user tries to change the hostname, which is not found in the /etc/hosts file, and it is fixed by adding the hostname to that file.
Why Does Find -mtime +1 Only Return Files Older Than 2 Days?
The find -mtime +1 only returns files older than two days because it only returns the files modified in the last two or less than two days.
How to Completely Uninstall Docker?
While uninstalling docker, a few configuration files and components must be manually deleted through a series of commands which require execution one by one.
How to Reduce a Video Size With FFmpeg?
Sharing large videos takes a lot of time, so FFmpeg is used to manipulate videos, change resolutions, and trim so that the size is reduced.
How to Use SCP with PEM File?
To create a “.pem” file using the SCP, use the “ssh-keygen -f ~/.ssh/id_rsa -e -m pem” command. Then, upload or download a file or directory using SCP.
How to Fix Disk Quota Exceeded in Linux?
When a user exceeds the assigned disk quota, it causes “Disk Quota Exceeded,” which is fixed by freeing the disk space or getting more quota.
KDE vs GNOME | Everything You Need to Know
Explore the differences between KDE and Gnome, two popular desktop environments for Linux. Decide which one is right for you.
How to install .run files?
In Linux, all the “.run” files can be installed by using the “chmod” command and the “Permissions” options to make them executable.
sysctl Command in Linux | Explained
The sysctl command allows the user to modify the kernel parameters on the Linux system at runtime. You should only do that if you are fully aware.
How to Convert mkv to mp4 Using FFmpeg?
FFmpeg is the most widely used video conversion and compression software used for multimedia files … Read More
pwd Command in Linux | Explained
In Linux, the pwd command prints out the directory you are currently working on and provides an exact path from the root to the current directory.
kill Command in Linux | Explained
The kill command is used to pass different signals in Linux to manage the behavior of the processes. In this blog, the kill command has been explained in detail.
cd Command in Linux | Explained
The cd command in Linux is used to change the directory. We can change our directory to another directory, home directory, or directly to the root directory
How to Use grep Command to Find Text in Files in Linux
The grep command can be used to find the words in the files of Linux. The words can be found in the current directory and its sub-directories.
What is Uname Command in Linux
The uname command is used in Linux to display the basic information of the computer, including kernel name, hostname, kernel version, and processor type.
What is GRUB in Linux? What is it Used for?
GRUB is the abbreviation of GRand Unified Bootloader and is a bootloader and a boot manager. GRUB plays a key role in the Boot process.
How to Start, Stop & Restart Services in Ubuntu
To start, stop & restart the services on Ubuntu, use any of these“systemctl”, “service”, and “init” command utilities. Read out this article to learn more.
How to Set or Change Hostname in Linux
You can change the hostname on your Linux system using different methods, such as hostnamectl, hostname, nmtui, nmcli, and system settings.
How to Get the Dictionary Length in Python?
In Python, the “len()” function, the “for loop with isinstance() function”, and the recursive function are used to calculate the dictionary’s length.
Python math.log2() – Logarithm to Base 2
In Python, the “math.log2()” function of the “math” module returns the logarithm of the number to base 2. The input number must be greater than zero.
How to Install Linux Mint 21 From USB?
To install Linux Mint 21 from USB, first, download the iso file of Linux Mint 21, make the USB bootable with the downloaded iso file, and finally install it on the computer.
How to Clear apt Cache in Ubuntu 22.04?
Some of the most common usages of the apt command in Ubuntu are updating and … Read More
Is Ubuntu Debian Based?
If you are wondering whether Ubuntu is Debian based or looking for the key similarities and differences between them. Then read this article for more details.
How to Install Visual Studio Code on Ubuntu 22.04
Visual Studio Code can be installed on Ubuntu 22.04 using the apt package manager “sudo apt install code” or using the “sudo snap install code –classic”.
Python Relational Operators | Explained
In Python, the relational operator is used to draw a comparison between values. The return type of these operators is a Boolean (true or false).
Install OpenOffice in Ubuntu 22.04
To install OpenOffice on Ubuntu 22.04, install the JDK. Then download and unzip setup file, move to the “en-US/DEBS/” directory, and install the “.deb” package.
Python re.sub() Method | Replace Strings Using Regex
The “re.sub()” method is used to replace the strings by taking a string variable as an input. The “re.sub()” method is invoked after the “re” module.
How to Convert Int to Binary in Python
In Python, the “bin()” function, “format()” function, “f-string()” function, and “str.format()” method can be used to convert an integer to binary.
How to copy files from one directory to another in Linux
Files are copied to a different directory using either the “cp” command or the “rsync” tool. Using these, single, multiple, as well as all files can be copied.
How to Install Skype on Ubuntu 22.04
On Ubuntu 22.04, to install Skye, either use Ubuntu Software Center or Snap by executing the “sudo snap install skype –classic” command on the terminal.
Install Latest Telegram Desktop Messenger App on Ubuntu 22.04
To install Telegram on Ubuntu 22.04, use Ubuntu Software Center or run “sudo apt install telegram-desktop -y” on the Ubuntu 22.04 terminal.
How to Install Apache on Ubuntu 22.04
To install the Apache web server on Ubuntu 22.04, first, update the system packages. Then install Apache using “sudo apt install apache2” command on terminal.
How to Install XnView MP on Ubuntu 22.04
XnView MP can be installed on Ubuntu 22.04 using the DEB package or from the flathub repository. XnView MP has not released its repo for Ubuntu 22.04 yet.
Create Animated Presentations with AnimationMaker on Ubuntu 22.04
First, you must install Animation Maker on Ubuntu 22.04. After installation, you can use this robust tool to create animated presentations on Ubuntu 22.04.
How to Install & Use KIO GDrive in Ubuntu 22.04
To install KIO GDrive on Ubuntu 22.04, first install the KDE account provider package. Then install KIO GDrive using “sudo apt install -y kio-gdrive” command.
How to reset the root password on Ubuntu 22.04
To reset root password, open and edit GRUB menu, find line begins with “linux”, add “rw init=/bin/bash” line and use “passwd” command to reset password.
How to Install ZOOM on Ubuntu 22.04 Jammy Jellyfish
Zoom can be installed on Ubuntu 22.04 using the GUI support of snap. Additionally, the deb package of ZOOM can also be used to install it on Ubuntu 22.04.
Install and set up Postman on Ubuntu 22.04
To install Postman on Ubuntu 22.04, first, install snap utility on Ubuntu 22.04 and execute the “$ sudo snap install postman” command on Ubuntu terminal.
How to Download and Install Google Fonts on Ubuntu 22.04
To download and install Google Fonts on Ubuntu 22.04, first download Font zip file from Google site, extract it, then install Font Manager to install Fonts.