Jeff Wilson

An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.

MySQL vs SQLite vs PostgreSQL: Comparing the Relational Database Management Systems

by

MySQL vs SQLite vs PostgreSQL

In this tutorial, we are going to explain the differences between relational database management systems such as MySQL, SQLite, and PostgreSQL.

This type of relational database management system is used worldwide, based on relational models, where the information is stored in tables linked between with relations, making the data to be easily referenced. We will explain the advantages and disadvantages of every type in a couple of sentences so you can better understand which one you should use in different scenarios. Let’s get started!

Read More

How to Install osTicket on AlmaLinux

by

How to Install osTicket on AlmaLinux

In this tutorial, we are going to install osTicket on AlmaLinux and explain in step-by-step detail how to configure it with the LAMP stack.

osTicket is an open-source support ticketing system written in PHP which supports MySQL or PostgreSQL as database types.osTicket has many features such as Advanced Search, Ticket Filters, Service Level Agreements, Custom Columns and Queues and etc. In this tutorial, we are going to use MariaDB as a database and Apache as a web server.

Installing osTicket on AlmaLinux is a very easy and straightforward process that can take up to 20 minutes. Let’s get started!

Read More

How to Install Akaunting on Ubuntu 20.04

by

How to Install Akaunting on Ubuntu 20.04

Akaunting is web-based, free, and open-source accounting software designed to help small businesses. It helps small businesses and freelancers manage and streamline payment, invoicing, and other operations. With its client portal features, administrators are able to share financial information like transactional and invoicing information with the clients. The application also offers complete tools to manage your finances. These are their main features:

Read More

10 basic cat commands in Linux with examples

by

10 Basic Cat Commands in Linux With Examples

In this tutorial, we are going to explain some basic cat commands in Linux, that are applicable on various distributions such as Ubuntu, Debian, CentOS, AlmaLinux and etc.

The “cat” command is a shortcut of the word “concatenate” and is a very useful command that is frequently used, by system administrators and DevOps engineers. With this command you can easily view files, create them, filter information from them, display line numbers in files and etc.

In this post, the cat command will be explained with real examples on Ubuntu 20.04. You can use the Linux distribution of your choice. Let’s get started!

Read More

How to Install Bugzilla on Ubuntu 20.04

by

How to Install Bugzilla on Ubuntu 20.04

In this blog post, we are going to explain in step-by-step detail on how to install Bugzilla on Ubuntu 20.04.

Bugzilla is an open-source web-based bug tracking system written in Perl. This testing tool is developed and maintained by the Mozilla project, and the team of developers is still developing and expanding its features. The main purpose of this detect-tracking software is to track the bugs, issues, and other change requests. The compatibility of the software on multiple operating systems like Windows, macOS, and Linux makes it more popular than any other.

Installing Bugzilla on Ubuntu 20.04 is a very easy process and may take up to 10 minutes. Let’s get started!

Read More

How to Install Sails.js Framework on AlmaLinux

by

How to Install Sails.js Framework on AlmaLinux

In this blog post, we are going to install the Sails.js Framework on AlmaLinux OS.

Sails.js is a Javascript framework, used for building an application in real-time without writing too much code. It is an MVC(Model-View-Controller) framework based and is developed under the Node.js environment. Sails.js offers a number of features built on Express.js and Node.js enabling the applications to be fully based on javascript. It is good to be mentioned that Sails.js provides an object-relational mapping interface using Waterlin.js. In this blog post, we are going to configure Sails.js with Apache as a reverse proxy so you can access your app via a domain name instead of using an IP address and port.

Installing Sails.js on AlmaLinux with Apache as a reverse proxy will take up to 15 minutes. Let’s get things to work!

Read More

How to Install Java 17 LTS on Ubuntu 20.04

by

How to Install Java 17 LTS on Ubuntu 20.04

Java is a free, open-source, high-level, object-oriented programming language that is designed to have as few implementation dependencies and it can run on all major operating systems that support Java without the need for recompilation.

Java 17 LTS is the latest long-term support release that includes security and performance updates, and of-course bug fixes.

Read More