Tutorials

PostgreSQL vs. MySQL
PostgreSQL vs. MySQL
  • Know-how

Many web developers will already be familiar with MySQL as a relational database management system (RDBMS). Those managing more professional projects may be aware of its powerful competitor PostgreSQL. But did you know the latter is an object-relational database management system (ORDBMS)? Find out what this difference means in practical terms.

PostgreSQL vs. MySQL
Install PostgreSQL on Windows Server 2016
Install PostgreSQL on Windows Server 2016
  • Configuration

PostgreSQL is an open source object-relational database system with over 15 years of active development and a reputation for reliability. Learn how to install PostgreSQL on Windows Server 2016.

Install PostgreSQL on Windows Server 2016
Telnet – the system-wide remote protocol
Telnet
  • Tools

Remote access to remote computer systems has always been a part of well-organized networks. Administrators can manage individual users as well as work on the move since it’s possible to access company data with a remote connection. One of the first protocols developed specifically for this purpose was Telnet. Read more here.

Telnet
Linux editor: effective code editing with Vim
Vim - The Linux editor
  • Tools

In order to edit text files or receive source codes from software or websites, you require a text editor. Whether you’re using Linux, Windows, or Mac: the majority of operating systems these days already have them installed by default. There are also editors like Vim, which have a wider range of functions and simplify working with the confusing lines of code.

Vim - The Linux editor
How to check Debian version
How to check Debian version: the quick and easy way
  • Know-how

Knowing which Debian version you have not only helps you to choose the right install package for a program – you also need it to get appropriate support in forums. There are several different methods to check your Debian version. In this step-by-step guide, we’ll explain how to check your version using Terminal and Hardinfo.

How to check Debian version: the quick and easy way
Adding favicons in WordPress
Favicons in WordPress: how to add and change
  • Blogs

Browser tabs contain two elements - the title of your website and a small image known as a favicon. A good favicon makes it easier for users to navigate their browsers and strengthens your brand identity. So how do you add a favicon to your WordPress site? There are three ways of doing it - using the WordPress Customizer, by using a plug-in, or doing it manually. Keep reading for step-by-step...

Favicons in WordPress: how to add and change
NGINX Password Authentication
Set up Password Authentication with NGINX
  • Configuration

Learn how to set up a basic HTTP authentication system. This will allow you to password protect particular directories on your website, so that they can only be accessed after logging in with a username and password.

Set up Password Authentication with NGINX
Nginx tutorial: getting started with nginx.conf
NGINX Tutorial - Commands and configurations
  • Configuration

Nginx is very different from traditional server software such as Apache in the way that it responds to client requests and the fact that it also involves configuration changes. In this nginx tutorial you can learn how to make changes without having to restart the web server software as well as how to set up a simple proxy server for images in just a few steps.

NGINX Tutorial - Commands and configurations
Reinstall WhatsApp
How to reinstall WhatsApp without losing data
  • Social media

Sometimes you have to reinstall WhatsApp as a last resort when replacing a device or experiencing problems with the popular messaging app. If you want to reinstall WhatsApp without losing data, you should use a local backup or a cloud backup. You can learn how to uninstall and reinstall WhatsApp on Android and iOS here.

How to reinstall WhatsApp without losing data
Excel shortcuts
30 Excel shortcuts to speed up your work
  • Web analytics

Excel shortcuts enable you to carry out your work a lot faster, but you first have to learn them. We present you with 30 useful Excel key combinations that faciliate your daily work. From navigation, to inserting cells, to calculating totals. If there isn’t already a shortcut for a function you regularly use, you can easily create your own Excel shortcuts.

30 Excel shortcuts to speed up your work