Language Selection

English French German Italian Portuguese Spanish


Topicsort iconRepliesCreatedLast reply
Ubuntu - More coverage or less coverage? 0 6 years 43 weeks ago
by Roy Schestowitz
Syndicate content

More in Tux Machines

First Linux Kernel 5.12 Release Candidate Is Now Available for Public Testing

The merge window that opened with the launch of the Linux 5.11 kernel series two weeks ago is now closed and Linus Torvalds published the first Release Candindate in the upcoming Linux kernel 5.12 series, giving us an early taste of the new features and improvements. The final release of Linux kernel 5.12 is expected to hit Linux distros sometime this Spring in late April 2021, either on the 18th or the 25th, which depends on how many Release Candidate milestones will be published during the entire development cycle. Read more

Review: LibreELEC 9.2 and Kodi

I recently got into a discussion with someone who had purchased a second television for their house and, knowing that I have a fondness for open source and do-it-yourself projects, they asked if there was a suitable alternative to Fire TV. For those not familiar with the device, a Fire TV stick is a small device which looks like a large USB thumb drive and attaches to the HDMI port of a television. The device connects wirelessly to local networks and can be used to stream shows and movies from a variety of services like Netflix and Disney+. The device is operated by a small, dedicated remote control. I was pretty sure a minimal Linux distribution running on a spare, minimal personal computer or a single-board device like a Raspberry Pi would probably be a suitable replacement. I figured a distribution that ran Kodi could probably do the work, connecting to the TV through an HDMI cable. The user could likely use the Kodi mobile app in place of a dedicated remote control. For the sake of comparison, I looked up information on the Fire TV stick which was $55 USD if i wanted it in two weeks or $60 if I wanted it in one week. The person I was talking with already had one and knew it was a "plug and play" type device, so the total set up time would be under ten minutes. I did some on-line shopping in my area and the closest open source style equivalent I could come up with was a Raspberry Pi 3B. The Pi was $47 USD. The Pi included a Wi-Fi option, but no microSD card, no HDMI cable, and no power supply. Adding these items to my tally brought my total up to $78, including tax. In other words, even with a free software solution, it looked like the open source route was going to be slightly more expensive with parts available in my region. Read more

today's howtos

  • How to Install Papirus Icon Theme on Linux Mint 20 – Linux Hint

    Papirus is a popular and eye-catching icon theme. The Papirus icon theme works with various desktop environments, i.e., Cinnamon, GNOME, Unity, etc., and is available in multiple variants. It can be installed on Linux Mint from the PPA repository, installer script, and Debian package.

  • How to Setup Synology NAS? – Linux Hint

    Synology specializes in Network Attached Storage (NAS) devices and software. Synology NAS devices are easy to use and configure. Its built-in DSM (DiskStation Manager) web app allows you to access and configure the NAS from a web browser. Synology’s management web interface, the DSM web app, is one of the best NAS management tools out there. The DSM web app differentiates the Synology NAS from its competitors.

  • How to Install WireGuard VPN on CentOS 8 – Linux Hint

    WireGuard is a popular point-to-point open-source communication protocol that is used to create a secure and fast Virtual Private Network tunnel. This VPN was designed for use in the Linux Kernel. WireGuard is a lightweight VPN that provides extremely fast speeds to users. This article shows you how to install and set up WireGuard on your CentOS 8 system. The installation and setup of WireGuard are much easier than the already-existing VPNs, like OpenVPN, and this is a major reason behind its growing popularity in the Linux community.

  • How to Install Yarn on Linux Mint 20 – Linux Hint

    Yarn is a JavaScript package and dependency management tool that helps users to automate the tasks of installing, updating, removing, and configuring NPM packages. Yarn is an open-source package manager that saves a lot of time for JavaScript programmers because it creates a cache of downloaded packages. Using Yarn, a programmer can easily access and re-use a package without re-downloading it every time. This article shows you how to install Yarn on Linux Mint 20.

  • Linux List All IP Addresses on the Interface – Linux Hint

    All the people who belong to the networking background know that an IP address acts as a unique identifier of the devices within a network. Therefore, we must know the IP addresses of the devices within a network to enable smooth network communication. Today’s article will focus on the different methods of listing all the IP addresses on the Interface in Linux Mint 20.

  • Running Docker Containers on Synology NAS – Linux Hint

    Docker is a containerization platform. Docker is used to running lightweight containers on your computer. Synology NAS has official support for Docker. Docker can be an alternative to virtual machines. If you don’t have enough memory to run virtual machines on your Synology NAS, you can run Docker containers instead. Docker containers require a very little amount of memory and system resources to run. In this article, I will show you how to install and use Docker on Synology NAS. So, let’s get started.

  • How to Enable Automatic Login on Ubuntu 20.04? – Linux Hint

    For Ubuntu’s latest versions, users can enable automatic login for the ease of users. If enabled, then users do not need to type the password whenever they try logging in. If you are the only user of your system, then it is a very useful method for easy access to relevant files. In this article, we will analyze the methods of enabling the automatic login on the Ubuntu 20.04 system.

Databases: MySQL and PostgreSQL Technical Manuals (New)

  • How to Install MySQL on Linux Mint 20 and Ubuntu 20.04?

    MySQL is an open-source, simple, and relational database that uses SQL (Structured Query Language) to manage and manipulate the data.

  • MySQL Add a Column to Existing Table

    MySQL Database System is a highly scalable database service for creating cloud-native applications. Therefore we have to perform different operations while working on it. The ALTER TABLE declaration is being cast-off to add, remove, or alter columns while working on an already existing table in any schema of MySQL. We’ll teach you exactly how to declare a column to an existing table utilizing the MySQL ADD COLUMN expression in this guide.

  • MySQL Count Matching Records With COUNT

    Data redundancy occurs for a lot of reasons. Several of the complicated duties you should cope with while working with database systems is trying to discover duplicate values. For this purpose, We will be using the COUNT() aggregate method. The COUNT() method returns the sum of rows residing in a specific table. The COUNT() function permits you to sum all rows or only rows matching the condition defined. In this guide, You’ll get to know how to identify duplicate values for one or maybe more MySQL columns using COUNT().

  • MYSQL Import Data from CSV File – Linux Hint

    A CSV or comma-separated value document is a delineated text document that distinguishes values from a comma. Every line is its information record. Each data, parted by commas, comprises one or extra fields. The origin of the title for this document layout is the usage of the comma as a field divider. For sharing information between various programs, such documents are used. For instance, Database and contact administrators also endorse CSV files. The theory is that from one program to a CSV document, you may transfer complex information and afterward import the information in that CSV document to some other program. In this tutorial, we will learn how to import data from a CSV file into MySQL workbench. Let’s get started.

  • MYSQL Find Matching Records with LIKE – Linux Hint

    The MySQL LIKE operator tests if a particular character string resembles the pattern mentioned. We will match a portion of the overall data present in a segment that doesn’t need to match precisely. We will cup tie our keyword with the sequence of the information available in columns by using wildcard query in various combinations. MySQL Wildcards are symbols that help match difficult criteria with search results and have been used in combination with a compare operator called LIKE or a contrast operator called NOT LIKE.

  • MySQL Limit Results Returned With LIMIT – Linux Hint

    You eventually hit the stage where data volume greatly increases when we start to deal with DBMS like MySQL. It is difficult for us to manage and use. MySQL has built-in capabilities that make it easy to handle. In MySQL, the LIMIT clause is being used to cut down the number of rows throughout the result set using the SELECT expression. We will discover how to use the MySQL LIMIT clause in this guide to restrict the number of rows that a query returns.

  • MySQL Sort Results with ORDER BY Statement – Linux Hint

    While working with MySQL queries, the results are obtained in the same sequence as the records inserted into the schema utilizing the SELECT command. It’s the standard order for sorting. You would be aiming at how we might arrange our query result. Sorting is re-arranging the outputs of our query in a defined manner. Sorting may be done on one field or more than one field. The ORDER BY statement is being used to arrange the query results in an ascending or descending order in MySQL. The ORDER BY statement organizes data by default in go-up order if ASC or DESC is not specified. The DESC term is being used to organize the data in descending way.

  • MySQL Subqueries – Linux Hint

    A subquery is a SQL query within a greater query that is recursive, or a subquery is considered an internal query. In contrast, an outer query is termed as the query that includes the subquery. A MySQL subquery can be embedded in the queries, including SELECT, INSERT, UPDATE, or DELETE. Furthermore, within another subquery, a subquery may be nestled. The phrase subquery should be closed in brackets wherever it is used. We’ll teach you how and when to use MySQL subquery to compose complicated queries and describe the idea of the associated subquery. Open the command-line shell from your desktop and write your password to start using it. Press Enter and continue.

  • PostgreSQL FAQs – Linux Hint

    According to StackOverflow’s 2020 Annual Developer Survey, PostgreSQL is the second most popular database management system available, and this is not without good reason. Since its initial release in 1996, PostgreSQL, or Postgres, has improved considerably, adding several useful features, including user-defined types, table inheritance, multi-version concurrency control, and more. PostgreSQL is also very lightweight, easy to set up, and can be installed on several platforms, such as containers, VMs, or physical systems. Besides its default GUI, pgAdmin, Postgres also supports over 50 other IDEs, a third of which are free to use. This article will cover some of the most frequently asked questions (FAQs) about PostgreSQL.